Power Pivot versus Power Query
Speaker(s):
Avi Singh
Duration: 60 minutes
Track: Discover & Integrate
If all you have is a hammer, everything looks like a nail. To build a successful Power BI solution, you need to know when to wield Power Pivot vs Power Query. Power Pivot is a powerful data modeling tool with a rich formula language (DAX). Power Query lets you clean, shape and transform your data and whip it into shape.
If you do not use Power Query to shape your data model correctly, you end up writing overly complex DAX measures in Power Pivot. If you are using Power Query to do Power Pivot's job, you end up with a highly inefficient data model.
Avi Singh, has worked with numerous Fortune 500 clients, where he has seen Power BI solutions of all shapes and sizes. Avi, would present real life examples of "bad" Power BI behavior and show you how to remedy that with the right dosage of Power Pivot and Power Query. If your goal is to build a healthy - agile and scalable - Power BI solution, this session is just what the doctor ordered.
Accompanying Materials:
No material found.