Category Archives: Business Intelligence

Business Intelligence Requirements Gathering

There are three fundamental steps in building a data warehouse for a BI solution (see Why you need Business Intelligence): Identify the data the users interact with, or would like to interact with, via interviews.  Make sure to determine the … Continue reading

Posted in Business Intelligence, SQLServerPedia Syndication | 2 Comments

Industry Expert Interview

I don’t know if I would consider myself an industry expert, but hey, it says it on the Internet, so it just be true (because you can’t put anything on the Internet that’s not true).  An interview I did to … Continue reading

Posted in Business Intelligence, SQLServerPedia Syndication | Comments Off on Industry Expert Interview

PASS SQL Saturday in Chicago Presentation Slides

Thanks to everyone who attended my sessions “What exactly is Business Intelligence?” and “Building an Effective Data Warehouse Architecture” at the PASS SQL Saturday in Chicago. Here are the PowerPoint presentation: What exactly is Business Intelligence? and Building an Effective Data Warehouse Architecture. What … Continue reading

Posted in Business Intelligence, Data warehouse, PASS, Presentation, Session, SQLServerPedia Syndication | Comments Off on PASS SQL Saturday in Chicago Presentation Slides

SQL Server 2012 Business Intelligence Enhancements

My first article in SQL Server Pro magazine has been published, in the April 2013 issue.  It is entitled “SQL Server 2012 Business Intelligence Enhancements” and can be found here (web) or here (mag).  I hope you enjoy it!

Posted in Business Intelligence, SQL Server 2012, SQLServerPedia Syndication | 4 Comments

Benefits of using views in a BI solution

Using SQL Server views throughout a Business Intelligence (BI) solution can provide a tremendous amount of benefits.  Here is a list of such benefits, taken in large part from the excellent video SQLBI Methodology by Marco Russo and Alberto Ferrari: Benefit … Continue reading

Posted in Business Intelligence, SQLServerPedia Syndication, SSAS, SSIS | Comments Off on Benefits of using views in a BI solution

Why you need Business Intelligence

First lets define what Business Intelligence (BI) is.  My favorite definitions: Forrester Research: “Business Intelligence is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, … Continue reading

Posted in Business Intelligence, SQLServerPedia Syndication | 5 Comments

Top BI Enhancements for SQL Server 2012 Presentation Slides

Thanks to everyone who attended my session “Top BI Enhancements for SQL Server 2012” at the Houston Area SQL Server User Group Monthly Meeting. Here is the PowerPoint presentation: Top BI Enhancements for SQL Server 2012 Top BI Enhancements for SQL Server 2012 What are … Continue reading

Posted in Business Intelligence, Presentation, Session, SQL Server 2012, SQLServerPedia Syndication | Comments Off on Top BI Enhancements for SQL Server 2012 Presentation Slides

Top BI Enhancements for SQL Server 2012 Presentation

Next Tuesday, March 12th at 1:15pm CST, I will be presenting the session “Top BI Enhancements for SQL Server 2012” at the Houston Area SQL Server User Group Monthly Meeting.  Below is the abstract.  I will be presenting in person but you … Continue reading

Posted in Business Intelligence, Presentation, Session, SQL Server 2012, SQLServerPedia Syndication | Comments Off on Top BI Enhancements for SQL Server 2012 Presentation

Visual Studio 2012 now supports BI!

My most popular blog has been Visual Studio 2012 does not support BI.  In short, this means VS 2012 does not support SSAS, SSIS, or SSRS.  Well, not anymore!  Just released is Microsoft SQL Server Data Tools – Business Intelligence for … Continue reading

Posted in Business Intelligence, SQL Server, SQLServerPedia Syndication, SSAS, SSDT/Juneau, SSIS, SSRS, Visual Studio 2012 | 9 Comments

“DBA: Transitioning to a BI Role” Presentation Slides

Thanks to everyone who attended my presentation “DBA: Transitioning to a BI Role” at the PASS Professional Development Virtual Chapter.  The recording of the session is available here. Here is the PowerPoint presentation: DBA: Transitioning to a BI Role I had some excellent questions … Continue reading

Posted in Business Intelligence, Presentation, Session, SQLServerPedia Syndication | Comments Off on “DBA: Transitioning to a BI Role” Presentation Slides