THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Free online session at PASS DW/BI Virtual Chapter #sqlpass – Tues Jan 10th, 2012

Tomorrow January 10th, 2012 at 3pm Eastern Time (which is 8pm GMT) I will deliver a free online session for the PASS DW/BI Virtual Chapter. This is the official description of the session.

Vertipaq vs OLAP: Change Your Data Modeling Approach

While in classical OLAP cubes the clear winner data modeling technique is dimensional modeling, it is interesting to understand what will happen with the new Vertipaq engine. In Vertipaq there is no real need to do dimensional modeling, because the engine is able to manage relational modeling too. In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both UDM and Vertipaq. This will lead to an interesting discussion about how to develop your data warehouse in order to make it working with both UDM and Vertipaq.

This is the same session I delivered at PASS Summit 2011, maybe with just some update and fix according to the feedback I received at PASS and new knowledge I’ve got in the last two months.

Thanks to some feedback I received, I’d like to advise you that this session is not a comparison between Vertipaq and OLAP in terms of performance, scalability or features set. The focus of this session is about data modeling, and how you may change the data model on the relational side (and in Tabular, too) in order to leverage the characteristics of the Tabular technology. Just to make an example: in an OLAP model you are used to move part of the calculation in the ETL (snapshot tables, ranking, and so on). Is this still necessary with Vertipaq or not? You might guess the answer, but this and other topics will be the base for the discussion during this session.

Set your agenda and connect to the LiveMeeting session following this link (Tues Jan 10th 3pm Eastern (US) – 8pm GMT)

Published Monday, January 09, 2012 3:39 PM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Massimo Morelli said:

Marco, I thank you for this presentation that was very very good. I have done similar things (ABC, database snapshots) and I have struggled with ETL every time. It's good to know that there are methods in DAX to treat the problem in other ways.

Is it possible to have a description (a transcript an article a book) of these tecniques? Would you point me in the right direction?

January 12, 2012 8:43 AM
 

Marco Russo (SQLBI) said:

You can find a complete covering of ABC Analysis in PowerPivot in our book. PowerPivot uses the same DAX technique you can use also in BISM Tabular.

http://www.amazon.com/dp/0735640580/?tag=se04-20

There is also a blog post that shows ABC in PowerPivot in a shorter example (not covering all the alternatives):

http://sqlblog.com/blogs/marco_russo/archive/2010/01/19/abc-analysis-in-powerpivot.aspx

If you're talking more in general about DAX techniques I illustrated in the session... well, we're just at the beginning of this exploration, this is a brand new world and we just scratched the surface.

January 12, 2012 8:50 AM
 

Massimo Morelli said:

Thanks, Marco, awesome work.

I've ordered the book from amazon.

January 12, 2012 9:49 AM

Leave a Comment

(required) 
(required) 
Submit

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.

This Blog

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement