Power BI - Intermediate Course

Zack Warren and Michael Hirsch

The Power BI - Intermediate course is designed for users with over 40 hours of hands-on experience who want to deepen their skills in Power BI, specifically using industrial datasets from the upstream oil and gas sector. The course goes beyond basic button-clicking, offering a blend of conceptual learning and practical exercises focused on advanced topics such as DAX, Power Query, data modeling, and geospatial analysis. It emphasizes real-world application using anonymized client datasets and covers essential BI adoption strategies to help users maximize organizational impact. With a mix of storytelling, technical insights, and humor, the course aims to equip analysts and report authors to be more productive and knowledgeable in data analytics. It also touches on migration from Excel to Power BI and the future landscape of Microsoft's data tools.Read more...

Who Should Take This Course
• Data analysts and report authors
• Those migrating from Excel or Spotfire
• Users with 40+ hours Power BI experience
• Professionals with industrial backgrounds

What You Will Learn
• Mapping and geospatial analysis
• Data modeling fundamentals for BI
• Managing BI adoption and consistency
• Advanced DAX and Power Query techniques

Why This Course Works
• Solve real industrial data problems
• Ensure data consistency and currency
• Maintain secure, governed data access
• Fit BI solutions to diverse user needs

Access All SAGA Wisdom Training content Subscribe
Already a member? Sign in

Course contents

    Chapter 1 - BI Adoption

    01-00 - Introduction (6 min.)  Sample Lesson

    01-01 - Okay so I know how to click some buttons. Now what?! (10 min.)

    01-02 - Escaping from Excel (18 min.)

    01-03 - Sliding Over from Spotfire (12 min.)

    01-04 - Our Favorite Aphorisms (9 min.) Quiz

    Chapter 2 - Putting the Power in Power Query

    02-01 - Power Query & ETL (21 min.)

    02-02 - Unstructured Data (10 min.)

    02-03 - Visualizing Log Data (15 min.)

    02-04 - Extracting .pdf Data & Append Queries (21 min.) Quiz

    Chapter 3 - Deeper Dive on DAX

    03-01 - How Do You Spell DAX? (23 min.)

    03-02 - Some Basic Calculations for Revenue Analysis (26 min.)

    03-03 - The Queen of DAX: CALCULATE() (29 min.)

    03-04 - DAX for Date Tables (25 min.)

    03-05 - Get Parameterized (18 min.) Quiz

    Chapter 4 - Data Modeling for Dummies (Like Engineers)

    04-01 - What the Heck is a Data Model? (19 min.)

    04-02 - A Basic Multi-Fact Data Model (23 min.)

    04-03 - Common Patterns (19 min.)

    04-04 - Using Power BI Data Models (28 min.)

    04-05 - Troubleshooting (24 min.) Quiz

    Chapter 5 - Mapping and Geospatial Analysis

    05-01 - Map Visuals Overview (20 min.)

    05-02 - Azure Maps (20 min.)

    05-03 - ArcGIS Maps (23 min.) Quiz

    Chapter 6 - Visual Design and User Interface

    06-01 - Visual Design Concepts (12 min.)

    06-02a - Incorporating Visual Design (5 min.)

    06-02b - Incorporating Visual Design (continued) (41 min.)

    06-03 - Interactivity and Navigation (21 min.)

    06-04 - The Kitchen Sink: Custom Tooltips, Net/Gross Buttons, and Drillthroughs (31 min.) Quiz