Marco is a business intelligence consultant and mentor. He wrote several books about Power BI, Analysis Service, and Power Pivot. He also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services.
Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide.
Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and Sqlbits. He also enjoys delivering evening sessions at local user groups during his trips.
Sessions
This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.
Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".
In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both Multidimensional (MOLAP) and Tabular (Vertipaq), looking at how to enable your data warehouse to support both.
In this session you will see how to create a BISM Tabular data model from scratch, providing the required metadata in order to improve user experience navigating the data model by using client tools like Excel PivotTable and Power View.
This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
Explore Power Query features to import data from existing Corporate BI systems.
Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources.
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
Best bractices in DAX formulas from real world experience.
DirectQuery best practices in Analysis Services and Power BI
Clarify differences between many-to-many and weak relationships in Power BI
Use Performance Analyzer and DAX Studio to find the performance bottleneck in a slow Power BI report.
Create the right Date table and use DAX time intelligence functions or custom filters to get the desired calculation aggregating and comparing data over time.
Learn how to read the information provided by VertiPaq Analyzer 2.0 and optimize data models in Power BI, Analysis Services, and Power Pivot.
Use Performance Analyzer and DAX Studio to find the performance bottleneck in a slow Power BI report.
Learn how to use Performance Analyzer in Power BI to get a first idea of performance bottlenecks in Power BI reports.
Introduce VertiPaq Analyzer features in DAX Studio and as a library available in other tools.