Power BI - Intermediate Course
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...
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
2.01 - Power Query & ETL (21 min.)
2.02 - Unstructured Data (10 min.)
2.03 - Visualizing Log Data (15 min.)
2.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
