Porto.Data #82 Let's improve the Tabular Model by Combining queries
Details
Next Porto.Data meetup we will be dedicated to Power BI, and we are extremely happy to have a professional to talk about it.
Our invited speaker, Ana María Bisbé York has more than twenty-five years of industry experience, currently works as a Business Intelligence Consultant and Trainer.
She is focused in the Data world on Microsoft technologies, modeling, Data Analysis with SQL Server BI, Excel BI, Azure ML, R, and Power BI. She can be a speaker, organizer, or attendee in technical events and forums. Microsoft Data Platform MVP. Microsoft Partner in Power BI. LinkedIn Learning Trainer, Winner of Globant Award Techfluencer Spain 2022, Book author of Curso Power BI (Spanish).
Session language: English
Abstract
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. We will show how to solve the following: To identify entities and attributes, respect the star model design, protect the fact tables model, Data quality tasks, VLookUp vs. Aggregates, and more.
Agenda
17:55 - Welcome
18:00 - "Let's improve the Tabular Model by Combining queries" by Ana María Bisbé York
19:10 - Closing