Let's improve the Tabular Model by Combining queries

Cleaning and reshaping data with Power Query is one of the best parts of designing and delivering analytical reports with Power BI. This session will demo several scenarios in which combining queries could be the perfect solution for the optimal tabular model.

Cleaning and reshaping data with Power Query is one of the best parts of designing and delivering analytical reports with Power BI. This "full of demo" session will demonstrate several scenarios in which Combining queries could be the perfect solution for the optimal tabular model. Some examples about what will be covered using Combining queries in this How's style session are the following: Identify entities and attributes. Respect the star model design Protect the fact tables model Data quality tasks Version control of data Management of excluded sets VLookUp vs. Aggregates and Role-Playing Dimensions

Speaker

Business Intelligence Consultant and Trainer. Microsoft Data Platform MVP. Microsoft Partner in Power BI. LinkedIn Learning Trainer. Speaker at Power Platform and SQL Saturdays events in Europe, USA, and LATAM.

Ana Maria Bisbe York's Sessions

Let's define Entities and attributes for tabular models in 20 minutes.

Ask the Expert - Group A (Wed 11:10 to 13:00)

Getting closer at the anomaly detection in the data

Let's improve the Tabular Model by Combining queries

Power BI Tooltips: how, where and when

Lets play with a date field & Time Intelligence in Power BI

Lets do the cleansing with M and / or Python languages

Some transformations that can save your ETL in Power BI