Power BI Foundations: 2-Day Workshop

Supercharge your analytics and reporting skills with Microsoft's dynamic duo. Designed to handle huge volumes of data, these tools will transform the way you work!

Two Days in our class and you are EMPOWERED!

Learn Microsoft's secret weapon behind Power Pivot & Power BI: DAX You don’t need to be an IT professional – most of our students come from an Excel background

Who Can Benefit? -Intensive users of Excel, particularly those responsible for reporting and analysis. -Business leaders who need to mine their data for actionable insight – using existing resources and on short deadlines -Organizations looking to leverage Microsoft’s groundbreaking Power BI offerings. -Business Intelligence and Database professionals looking to increase their professional agility and dramatically expand their capabilities.

What’s Included: -“Zero to sixty” on Power Pivot, Power BI, and Power Query -Not just the “hard” skills, but also the “soft” stuff (when and why to use it, how to get the best results for your organization, etc.) -Full-color copy of our 2nd edition eBook for immediate download -Pricing includes up to 15 participants

Day 1 Agenda -Loading Data, Creating Relationships & DAX Columns -Intro to DAX Measures and Common Functions -Under the Hood of the Calc Engine, Data vs Lookup Tables -CALCULATE, ALL, FILTER and the DATES Function Family

Day 2 Agenda -Deep dive on visuals: Chart, Table, Slicer, Card, Matrix -Basic Data Shaping with the Power Query Editor -Filtering at multiple levels, Publishing to Power BI Service -Sharing published reports, Scheduling refreshes