The next Monday, March 21st, I will join a special event organized by the Danish SQL Server User Group, Excelbi.dk and the Swedish SQL Server User Group. The meeting will start at 18:00 at the Radisson Royal Blu in Copenhagen, and this is the topic we will discuss.
PowerPivot / BISM and the future of a BI Solution
The next version of Analysis Services will offer the BI Semantic Model (BISM) that is based on Vertipaq, the same engine that runs PowerPivot. DAX and PowerPivot have been created as tools for Excel users but in Denali they will be available on the Corporate BI stack technology for Microsoft, as part of Analysis Services. The impact of this technology is huge, because many assumption that are made today for an OLAP cube (star schema models, surrogate keys and so on) might be no longer the optimal way to design a complete BI solution.
This session is about this impelling change: after an initial introduction about PowerPivot, DAX and Vertipaq changes that are relevant to this topic and some consideration about design impact on Data Warehouse, Data Mart and ETL pipeline, the session will become an open discussion with all attendees, in order to share experience, needs, technical challenges and understand future directions in corporate BI world.
I hope to meet many friends I only know by email in this meeting.
I will be in Copenhagen next week for the PowerPivot Workshop: if you are interested, hurry up, these are the last days to register, then we’ll run one workshop in Dublin and another in Zurich in the following two weeks.