Power BI - Intermediate Course

Zack Warren and Michael Hirsch

Subscribe View Sample Lesson 9:33 hours

Power BI is built to be both powerful and accessible, but there are a few things that are challenging to pick up. We'll pick up where we left off in our Power BI for Oil & Gas class (aka Intro), with deeper dives into DAX, Power Query, Mapping, Data Modeling, and more.
This course is designed for users with 40+ hours of experience, so we'll move quickly and cover a lot of ground. We use real industrial datasets (Upstream Oil & Gas, specifically) and show you how to solve real problems that we encounter on a regular basis in our consulting work. Come for the Power BI wisdom, and stay for the memes and dad jokes!Read more...

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