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. Data Modeling using Table Relationships​

• Editing Table Relationships
• Fixing Data Relationship Problems

Part 3. Advanced Data Visualizations

• Report Filtering Options
• Creating Advanced Charts
  • Forecasting using PowerBI
  • Gauge Charts
  • Other Charts
  • Using Hierarchy
  • Creating Drill Down Reports
  • Organizing the Data Pane
  • Applying Report Themes
• 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 DAX Formulas
  • Common DAX Functions
  • Iterator X Functions
  • RELATED Function
  • CALCULATE Function
  • ALL Function
  
  
  

Join a public class