Monthly Archives: May 2010

Self-Service BI, PowerPivot and the future of traditional BI (DWH, OLAP, MDX)

SQL Server 2008R2 | Excel 2010/PowerPivot Since I’m using the recently released Microsoft PowerPivot Add-In for Excel 2010 and when reading the rumors about the future of traditional OLAP and MDX there are some questions about the big picture of … Continue reading

Posted in Allgemein | Leave a comment

Analyzing the number of visits per customer

SQL Server 2008 | SQL Server 2008 R2 OLAP is perfect for analyzing fact records that are mapped to dimensions. However, what can be done, if the reference to the dimension changes depending on the selected period? I’m not talking … Continue reading

Posted in Allgemein | Leave a comment