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!

01-00 – Introduction (6 min.) 
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.)

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.)

03-01 – How Do You Spell DAX? (23 min.)
03-02 – Some Basic Calculations for Revenue Analysis2 (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.)

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.)

05-01 – Map Visuals Overview (20 min.)
05-02 – Azure Maps (20 min.)
05-03 – ArcGIS Maps (23 min.)

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.)

Access All Saga Wisdom Training Content

Already a member? Sign in.