Power BI Training Bootcamp: 4-Day Workshop

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