Alberto Ferrari

Alberto Ferrari is a Business Intelligence consultant. Alberto helped several software houses to build complex BI solutions, from the OLTP to the final OLAP cubes, providing planning hints all over the development lifecycle. He is a book author also, having worked on "Exper Cube Development with Microsoft SQL Server 2008" with Marco Russo and Chris Webb and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning with Marco Russo.

During this session we are going to analyze common business problems that require and advanced usage of DAX functions and data modeling with PowerPivot.
Deep dive into the handling of many to many relationships in DAX. How to make them work and how to optimize their speed thorugh many patterns and live examples of M2M usage.
We are going to show how to compute classical time intelligence with the built-in DAX functions. Then, we will show some more complex time intelligence formulas that require to think out of the box, using advanced data modeling techniques.
In this session, we will analyze the way DAX solves filtering. Starting from simple queries, we will follow the steps DAX does with the filter context, discovering the internals of the query engine of DAX.
A deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine and understand the best way to model your data warehouse to leverage the features of VertiPaq.
Alberto will start with a simple query and he will perform on stage all the necessary steps to optimize it, showing you the tools ant the techniques used to identify the bottleneck and to fix the performance issues
This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional
Alberto will show you some common techniques to use when building a budget model with Power Pivot and Power Query, including previous year allocation, multiple-step budgeting with linked back tables, handling of budget on non-existing products

Blog posts RSS

New Whitepaper from SQLBI: Vertipaq vs ColumnStore 17 Aug 2012
At the end of June 2012, I was in Amsterdam to present some sessions at Teched Europe 2012 and, while preparing the material for the demos (yes, the best demos are the ones I prepare at the last minute), I decided to make a comparison between the two...(read more)

DAX in Action 31 Jul 2012
I do not normally blog about my activity at conferences, courses and workshop, not because I don’t like these “marketing” topics, but only because I forget to do it. That said, sometimes I do some really exciting activities and, well, I need to share...(read more)

Clever Hierarchy Handling in DAX 30 Apr 2012
Hierarchy handling in DAX is not very easy, due to the fact that hierarchies, unlike it was in MDX, are not first-class citizens in the DAX world. While hierarchies can be easily defined in the data model, there are no DAX functions that let you access,...(read more)

Speaking at Lisbon NetPonto UG on 02/13/2012 09 Feb 2012
As you might (or not) know, I travel a lot for work and, when possible, I always try to speak at local user groups. It is fun and I always learn a lot by speaking with other professionals like me. Being in Lisbon next week, I’ll deliver a speech at Microsoft...(read more)

OT: A Good Reason to Attend #SQLBits 30 Jan 2012
My 4yo son keeps asking me why I should leave home so often to attend SQL conferences around the world and today, after a couple of days of snow, he discovered a good reason, along with the best place for the SQLBits scarf....(read more)