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. He also enjoys delivering evening sessions at local user groups during his trips.
Marco Russo's Training Days
Advanced DAXSQLBits 2024
Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.
Improve Power BI performance by optimizing DAXSQLBits 2022
Learn how to optimize DAX expressions in a Power BI model to improve query performance.
Improve performance with DAX and Power BISQLBits 2020
You learn how to discover bottlenecks of DAX calculations using tools such as DAX Studio and VertiPaq Analyzer, how to capture and read the information from a DAX query plan, strategies to improve the query performance.
Advanced DAXSQLBits 2019
Move your DAX knowledge to the next level - not for beginners!
Improve performance with DAX and Power BISQLBits 2018
Identify and solve common performance issues in Power BI.
Creating a Power BI Solution in one daySQLBits 2014
Introduction to all the tools included in Power BI, creating a complete solution in one day and showing how to use each tool in a practical way, with many demos.
From 0 to DAXSQLBits 2013
In this course you will be guided in the process of learning the DAX language, through many examples and scenarios that will help you understand what are the important concepts of DAX and how to leverage them in your everyday work.
Marco Russo's Sessions
Aggregations in Power BISQLBits 2024
Introduce Power BI aggregations with practical examples, evaluate pros and cons, and learn how to use alternative approaches by using DAX to control the aggregation used.
Using ALLEXCEPT or ALL/VALUES?SQLBits 2024
Learn when to use ALL / VALUES instead of ALLEXCEPT in DAX calculations.
Understanding window functions in DAXSQLBits 2024
Introduction to DAX window functions and apply semantics through several examples to understand their capabilities and performance.
DAX Best PracticesSQLBits 2018
Best bractices in DAX formulas from real world experience.
Power BI DashboardingSQLBits 2015
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.
SSAS Tabular from the Trenches SQLBits 2015
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
DAX PatternsSQLBits 2014
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
Power Query in Modern Corporate BISQLBits 2014
Explore Power Query features to import data from existing Corporate BI systems.
Modern Data Warehousing StrategySQLBits 2013
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.
Create a Data Model in BISM TabularSQLBits 2012
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.
Analysis Services Advanced Best PracticesSQLBits 2011
This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.
BISM IntroductionSQLBits 2011
Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".
Vertipaq vs OLAP: Change Your Data Modeling ApproachSQLBits 2011
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.