22-25 April 2026
SQLBits 2014

Power Query in Modern Corporate BI

Explore Power Query features to import data from existing Corporate BI systems.
In a Corporate BI environment, it is common having data available in controlled data sources such as Data Warehouse, relational Data Marts, Analysis Services cubes. Consuming this data with self-service BI is very useful, but how do you manage and validate the access to corporate data sources? How do you share and validate new queries created by end users? How can users extracts data at the right granularity level? Power Query bridges the gap between corporate and self-service BI. It empowers end-users so that they can extract and manipulate data from several data sources, inside and outside of the company. In this session, you will learn the Power Query best practices that enable the extraction of data from existing database and cubes, guided by an expert that know both worlds (Corporate BI and Power Pivot data models).

Speakers

Marco Russo

sqlbi.com/blog/marco

Marco Russo's previous sessions

Aggregations in Power BI
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?
Learn when to use ALL / VALUES instead of ALLEXCEPT in DAX calculations.
 
Understanding window functions in DAX
Introduction to DAX window functions and apply semantics through several examples to understand their capabilities and performance.
 
Power BI Performance Analyzer crash course
Learn how to use Performance Analyzer in Power BI to get a first idea of performance bottlenecks in Power BI reports.
 
VertiPaq Analyzer crash course
Introduce VertiPaq Analyzer features in DAX Studio and as a library available in other tools.
 
My Power BI report is slow: what should I do?
Use Performance Analyzer and DAX Studio to find the performance bottleneck in a slow Power BI report.
 
Time Intelligence in Power BI
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.
 
VertiPaq Analyzer crash course
Learn how to read the information provided by VertiPaq Analyzer 2.0 and optimize data models in Power BI, Analysis Services, and Power Pivot.
 
Different types of many-to-many relationships in Power BI
Clarify differences between many-to-many and weak relationships in Power BI
 
DAX Best Practices
Best bractices in DAX formulas from real world experience.
 
Power BI Dashboarding
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
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
 
DAX Patterns
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
 
Power Query in Modern Corporate BI
Explore Power Query features to import data from existing Corporate BI systems.
 
Modern Data Warehousing Strategy
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 Tabular
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 Practices
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 Introduction
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 Approach
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.