The Power BI – Intermediate course is designed for users with over 40 hours of hands-on experience who want to deepen their skills in Power BI, specifically using industrial datasets from the upstream oil and gas sector. The course goes beyond basic button-clicking, offering a blend of conceptual learning and practical exercises focused on advanced topics such as DAX, Power Query, data modeling, and geospatial analysis. It emphasizes real-world application using anonymized client datasets and covers essential BI adoption strategies to help users maximize organizational impact. With a mix of storytelling, technical insights, and humor, the course aims to equip analysts and report authors to be more productive and knowledgeable in data analytics. It also touches on migration from Excel to Power BI and the future landscape of Microsoft’s data tools.

Who Should Take This Course
• Data analysts and report authors
• Those migrating from Excel or Spotfire
• Users with 40+ hours Power BI experience
• Professionals with industrial backgrounds

What You Will Learn
• Mapping and geospatial analysis
• Data modeling fundamentals for BI
• Managing BI adoption and consistency
• Advanced DAX and Power Query techniques

Why This Course Works
• Solve real industrial data problems
• Ensure data consistency and currency
• Maintain secure, governed data access
• Fit BI solutions to diverse user needs

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

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.