5/15: Power BI Basics
5/15—5/16: Power BI Basics + Intermediate
5/15–5/17: Power BI FULL Bootcamp

*This will be a hands-on application of PowerBI tools. Participants should bring a laptop/device to the session to optimize this immersive learning experience.

Are you drowning in data, while starving for reliable and actionable insights? Are you spending endless hours double-checking, and refining ever-expanding Excel sheets and manual reports? Are the numbers not quite as consistent or reliable as you would like? Could the right information help you focus on what matters, make better decisions more quickly, and improve operational performance and results?

The Power BI bootcamp will jump-start your analytics and digital transformation journey by providing tools to develop your own in-house capabilities to convert data into insights! To offer increased flexibility, participants can register to attend day 1 only (basics), the first two days (basics + intermediate), or the full 3-day bootcamp.

DAY 1: Power BI Basics

DAY 1 – AM: Introduction + Data Loading + Interactive Visualizations

• Power BI – What/Why? Benefits over Excel? (incl. real-world examples)
• Installing Power BI
• Overview of the Power BI User Interface (incl. Report View, Data View, Model View, and Power Query Editor)
• Data Sources & Types
• Connecting to different Data Sources
• Visualization Types
• Creating and Editing Visuals
• Visual Interactions (incl. cross-filtering and cross-highlighting)
• Drill-Down/Roll-Up across Hierarchies
• Slicers & Filters
• Analytics (incl. built-in forecasting ability)

DAY 1 – PM: Hands-on practice! (“follow-along”, instructor-led)

• Applying all concepts covered during the morning session by building a dashboard from scratch! (instructor leads and participants follow along)

DAY 2: Power BI Intermediate

DAY 2 – AM: Data Transformation + Data Modeling

• Loading, Transforming, and Cleaning data (“Data Shaping”)
• Combining Data (appending & merging)
• Fact Tables vs. Dimension Tables
• Date Tables
• Data Modeling (relationships)

Everything covered through hands-on exercises!

DAY 2 – PM: Data Enrichment

• Introduction to “Data Analysis Expressions” (DAX)
• Calculated Columns
• Calculated Fields (“Measures”)
• Iterator Functions, e.g. SUMX()
• Filter Context and the CALCULATE() function

Everything covered through hands-on exercises!

DAY 3: Power BI Advanced

DAY 3 – AM: Putting it All Together (hands-on practice to solidify newly gained data analytics skills)

• Building a complete dashboard from scratch! (participants work to create or replicate a dashboard themselves, with support from instructors)
• Additional useful concepts and techniques being introduced:
• Time Intelligence
• Quick Measures
• What-If Parameters
• Bookmarks and Buttons
• Dashboarding Best Practices

DAY 3 – PM: Publication, Automation, and Integration

• How to publish reports and dashboards?
• How to update reports and dashboards automatically?
• How to build integrations with MS SharePoint, Teams, Power Apps, and Power Automate?
• Where to find good further Power BI resources? (incl. reference materials and practice data