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.

Leave a Comment

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.