LOOKING FOR RATES AND SCHEDULES
​TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY?
EMAIL [email protected]

Intermediate to Advanced PowerBI

This training includes a review of the basics of MS Power BI visuals.  The module will then proceed with creating complex charts and using DAX functions to perform efficient and better visuals.

Part 1. Review of Basic PowerBI

• Setting up PowerBI
• Connecting Data using PowerQuery
• Creating Basic Visuals
• Publishing Reports
  • Hiding Elements from Published View
  • Publishing in Mobile View

Part 2. Advanced Data Modeling using Table Relationships​

• Merging and Appending Queries
• Types of Joins (Merging)
• Editing Table Relationships
• Fixing Data Relationship Problems
  • Fixing Invalid Relationships using Bridges
  • Creating Sort Tables
  • Unpivoting
    

Part 3. Level Up Data Visualization Features

• Creating Conditional Formatting
• Creating Drill Through Filters
• Using and Creating Hierarchies
• Adding Analytics in Visuals
• Using Bookmarks, Buttons, and Actions
• AI Charts
  • Q&A Charts
  • Creating Synonyms for AI Charts

Part 4. Using DAX Formulas

• Understanding Implicit and Explicit Measures
• Creating Calculated Columns and Calculated Measures
• Using Calculated Measures in Visuals
• Using the DAX Query View Overview
• Using DAX Formulas in Creating Visuals
  • Common DAX Functions
  • Iterator X Functions
  • RELATED Function
  • CALCULATE Function
  • ALL Function

Join a public class