microsoft partner logo color
8249  Reviews star_rate star_rate star_rate star_rate star_half

Advanced Power BI: Features and Techniques

Skills Gained Edit existing reports, update data sources, and set up the Quick Access Toolbar in Power Query Extract and transform report data to tell a story Prepare data for analysis Model data and...

Read More
Course Code PBI-122-HF
Duration 1 day
Available Formats Classroom

Skills Gained

  • Edit existing reports, update data sources, and set up the Quick Access Toolbar in Power Query
  • Extract and transform report data to tell a story
  • Prepare data for analysis
  • Model data and relationships effectively, including managing many-to-many relationships
  • Create interactive reports with visuals that explore the data, top N filters, data hierarchy buttons, and measures tables
  • Publish and share reports
  • Create dashboards
  • Use Q&A in Power BI Service

Prerequisites

Attendees must have completed Accelebrate's Intermediate Power BI: From Data to Insights course or have equivalent knowledge.

Course Details

Training Materials

All Power BI training students receive a Power BI quick reference guide.

Software Requirements

  • The current version of Power BI Desktop installed
  • Attendees will not need to install any other software on their computers for this class. The class will be conducted in a remote environment that Accelebrate will provide.

Outline

  • Introduction to Advanced Features
    • Editing existing Power BI Reports
    • Updating the Data Sources
    • Setting up Quick Access Toolbar in Power Query
  • Extracting and Transforming the Report Data
    • Extracting the Data that tells the Story
    • Transforming the Data Quickly and Efficiently
  • Data Modeling and Relationships
    • Managing Relationships
    • Handling Many-to-Many Relationships
  • Preparing the Report Pages
    • Setting Page Information
    • Inserting a Page Background
  • Creating Interactive Reports
    • Creating Visuals that Explore the Data
    • Creating Top N Filters
    • Using Data Hierarchy Buttons
    • Creating a Measures table
    • Creating Measures & Quick Measures
    • Adding Custom Visuals
    • Applying Themes
    • Adding Report Titles, Logos, and Images
    • Creating Button Slicers
    • Adding Buttons and Shapes
    • Creating Multiple Pages
    • Using Edit Interactions
    • Using Q & A
  • Publishing and Sharing Reports
    • Publishing Reports
    • Creating Dashboards
    • Using Q&A in Power BI Service
  • Conclusion