💥Up to 50% OFF Selected Courses and Bundles until 31st Oct - see course page pricing for promo code, if applicable 💥

About
Courses
Courses Overview Course Bundles Power BI & Power Apps Excel & Modelling Free Resources Testimonials FAQs
Knowledge Hub
Videos Insights In-Depth Guides Example Models Free Resources
Contact

Claritix Insights

Blog thumbnail with title and company logo
Unpivoting Data in Power Query for use in Power BI & Power Pivot power bi power pivot power query tips

Before working with data in Power BI or Power Pivot, it’s essential to structure your data correctly so the data model and DAX can work with it. This process is carried out in Power Query, and here we...

Continue Reading...

Dan Stockdale

#DanDan

I'm a former PwC Excel & Financial Modelling Instructor and Consultant. I've also worked as a Financial Modeller, Commercial Analyst and Management Accountant in Industry, supporting CEOs, CFOs and Strategy. I crush down all the experience from over the years into my blog posts to tell you what you really need to know, all from a best practice, commercial viewpoint.

Categories

All Categories automation big data excel financial modelling performance & optimisation power bi power pivot power query tips
Course Bundles
Power Automation Big Data Excel Pro
Excel Courses
Excel Modeller Excel Analyst Excel Express Python in Excel
Power Courses
Power BI: Financial Reporting Power Query & Power Pivot: Automating Reporting
Resources
Videos Insights Example Models Free Resources
eBooks
Power BI Tips & Advice Modelling Top Tips Excel Top 10 Tips
Claritix
About Contact