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.)  Sample Lesson
01-01 – Okay so I know how to click some buttons. Now what?!
01-02 – Escaping from Excel
01-03 – Sliding Over from Spotfire
01-04 – Our Favorite Aphorisms

2.01 – Power Query & ETL
2.02 – Unstructured Data
2.03 – Visualizing Log Data
2.04 – Extracting .pdf Data & Append Queries

03-01 – How Do You Spell DAX?
03-02 – Some Basic Calculations for Revenue Analysis
03-03 – The Queen of DAX: CALCULATE()
03-04 – DAX for Date Tables
03-05 – Get Parameterized

04-01 – What the Heck is a Data Model?
04-02 – A Basic Multi-Fact Data Model
04-03 – Common Patterns
04-04 – Using Power BI Data Models
04-05 – Troubleshooting

05-01 – Map Visuals Overview
05-02 – Azure Maps
05-03 – ArcGIS Maps

06-01 – Visual Design Concepts
06-02a – Incorporating Visual Design
06-02b – Incorporating Visual Design (continued)
06-03 – Interactivity and Navigation
06-04 – The Kitchen Sink: Custom Tooltips, Net/Gross Buttons, and Drillthroughs

Access All Saga Wisdom Training Content

Already a member? Sign in.