Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in measure data of a fact table.  You may have unknown foreign keys from your dimension data but even those unknown foreign keys relate to some kind of fact data.  If… Read more

There are many posts available that describe how to test Analysis Services security from inside the development environment.  Today I would like to share a nice way to do this from excel.  When you create a connection to your Analysis Services database in Excel it creates an .odc file.  This… Read more

Last week the final sessions for SQL Rally were announced, and I was very excited to find out my Performance Tuning Analysis Services was voted in!  I want to thank everyone for voting and I promise to make it a great session.  It will be a fun, entertaining, and of… Read more

I wanted to announce that you can now pre-order your copy of my latest book to be released called SharePoint 2010 Business Intelligence 24 Hour Trainer  (http://tinyurl.com/SharePointBITrainer). This book was written so that someone completely new to SharePoint or BI could get their feet wet and produce value… Read more

This week the voting for the SQL Rally BI track went out, and I wanted to send a quick reminder to everyone to vote!  Of Course PragmaticWorks is a Business Intelligence shop you will find myself and several of my co-workers have submitted sessions.  It looks like no matter who… Read more