Untangling Nested Headers in Power Query

KIRILL PERIAN (Pragmatic Works) – Untangling Nested Headers in Power Query

We have all seen those pivot tables with multiple headers that make us pause, scratch out heads and wonder how in the world are we going to consume such a monster into our data model. In a short 30-minute session we will go through a couple of use cases step by step and create a perfect (and repeatable) query to create a fact table for your Power BI data model.

Kirill Perian is an MCSA in BI Reporting and a Senior Consultant at Pragmatic Works. He is a huge fan of data analytics, always looking to learn new things in the field of business intelligence, data governance and visualization best practices. Kirill enjoys solving data problems and being part of data community, both on local and global scale.

Download Kirill’s training content: click here

Portland Power BI User Group

Portland Power BI User Group

The Portland Power BI User Group is a community of people excited about the business analytics tool, Power BI. We believe the platform offers rich possibilities, and we keep pace by sharing our learning and doing deep-dive explorations of topics. We run the gamut from new to experienced users and welcome anyone who shares an interest in data analytics. Some great perks to joining our monthly meetups are networking, knowledge transfer, and community building. We aim to foster a vibrant community that shares success in implementing best practices for Power BI. Complimentary pizza and refreshments are served at every meetup.
Share on twitter
Share on facebook
Share on linkedin
Share on email


Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?