Day 1 - Power BI Foundations

Discover the building blocks of Power BI – What is Power BI
Power BI Platform Breakdown: Power BI Service and Power BI Desktop
Data sourcing and transformations using Power Query (M)
Tabular Data Modeling – loading/linking your data and understanding relationships
DAX – Creating Measures and Calculated Columns for key metrics
Power BI visualization best practices

Day 2 - Power BI Foundations

Power BI Service: How we use it for Collaboration and Sharing
Creating Power BI Apps in the Service
Understanding CALCULATE and Time Intelligence DAX functions
Security: role level security, managing security roles, and assigning report/role level security
Power BI Reports vs Power BI Dashboards: when to use them and what their differences are
Introduction to the proper report building process

Day 3 - Data Shaping, Modeling & Visualization

Instructor guided report build, that allows users to gain real-world experience in building a Power BI Report
Review the process of how to approach a report building project
Using DAX to build-out measures that formulate the metrics desired
Report Collaboration: Create Power BI Apps and share with colleagues ‘Show and Tell’ sessions

Day 4 - Classroom to the board room

Students use their company data to work through real-life reporting challenges and bring their new Power BI skills to life
Instructor-led report build that utilizes skills acquired during days 1 to 3
Conduct requirements gathering for new PBI report
Create desired measures using DAX identified during requirements gathering
Shape the desired data set using Power Query skills gathered during days 1 - 3
Create PBI visuals determined during Requirements gathering
Publish PBI Report to the Power BI Service for Collaboration
Show and tell
Wrap up and Q&A

Power BI Training Bootcamp: 4-Day Workshop

Collectiv LLC