Category Archives: Business Intelligence

Presentation slides for Houston SQLSaturday

Thanks to everyone who attended my two sessions at SQLSaturday in Houston (more info).  Here are the abstracts and PowerPoint links: Best Practices to Deliver BI Solutions If your company is planning to build a data warehouse or BI solution, you … Continue reading

Posted in Business Intelligence, Career, Presentation, Session, SQLServerPedia Syndication | 1 Comment

Business Intelligence/Data Warehouse Assessment

When I am tasked to do a business intelligence or data warehouse assessment, the steps I take to do that depend on the amount of time and the number of people I have.  The result of the assessment will be … Continue reading

Posted in Business Intelligence, Data warehouse, SQLServerPedia Syndication | 2 Comments

Does Business Intelligence equal Data Warehousing?

I have seen many times at clients where the terms business intelligence and data warehousing are used interchangeably.  In reality, these are two separate disciplines. This is especially true for enterprise data warehouses due to an EDW’s scope, complexity, and large volumes … Continue reading

Posted in Business Intelligence, Data warehouse, SQLServerPedia Syndication | Leave a comment

Best Practices to Deliver BI Solutions

If your company is planning to build a data warehouse or BI solution (see Why you need Business Intelligence), you need to be aware that BI projects have high failure rates.  Gartner says between 70% to 80% of corporate business intelligence … Continue reading

Posted in Business Intelligence, SQLServerPedia Syndication | 1 Comment

Presentations slides for Best Practices to Deliver BI Solutions

Thanks to everyone who attended my session “Best Practices to Deliver BI Solutions” for Pragmatic Works.  The abstract for my session is below and the recording will be available soon here.  I hope I provided some good info for you. Here … Continue reading

Posted in Business Intelligence, Presentation, Session, SQLServerPedia Syndication | Leave a comment

Best Practices to Deliver BI Solutions Presentation

I will be presenting a brand new session entitled “Best Practices to Deliver BI Solutions” tomorrow, August 6th, at 11am EST for Pragmatic Works.  You can register here.  The abstract for my session is below.  I hope you can make … Continue reading

Posted in Business Intelligence, Presentation, Session, SQLServerPedia Syndication | 2 Comments

Why You Need a Data Warehouse

Introduction You likely have heard about data warehousing, but are unsure exactly what it is and if your company needs one.  I will attempt to help you to fully understand what a data warehouse can do and the reasons to … Continue reading

Posted in Business Intelligence, Data warehouse, SQLServerPedia Syndication | 4 Comments

Business Intelligence Maturity Assessment

Do you ever wonder how your business intelligence (BI) and data warehousing (DW) environment compares to other companies and what steps you should be taking to progress your analytics platform? One of the first steps in any BI project is … Continue reading

Posted in Business Intelligence, SQLServerPedia Syndication | 3 Comments

Ralph Kimball Books

If you are involved in Business Intelligence, then the books by Ralph Kimball are required reading: The Data Warehouse Lifecycle Toolkit: Practical Techniques for Building Data Warehouse and Business Intelligence Systems, Second Edition, 2008, 636 pages (Amazon).  Subject: Implementation guide.  Primary … Continue reading

Posted in Business Intelligence, SQLServerPedia Syndication | 7 Comments

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