Menu
Insights Training
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools

MS PowerBI (Intermediate to Advanced)

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

Home

Courses

Public Classes

Contact

Copyright © 2022