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
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
Chapter 2 - Putting the Power in Power Query
2.01 - Power Query & ETL
2.02 - Unstructured Data
2.03 - Visualizing Log Data
2.04 - Extracting .pdf Data & Append Queries
Chapter 3 - Deeper Dive on DAX
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
Chapter 4 - Data Modeling for Dummies (Like Engineers)
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
Chapter 5 - Mapping and Geospatial Analysis
05-01 - Map Visuals Overview
05-02 - Azure Maps
05-03 - ArcGIS Maps
Chapter 6 - Visual Design and User Interface
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
