Microsoft Power BI Private

Microsoft Power BI Super User (55400)

2 days
Microsoft Business IntelligenceMicrosoft Power PlatformMicrosoft Power BI

Learn to harness Microsoft Power BI with our Super User course, designed for advanced data analysis and visualization. Elevate your BI skills.

Request Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal turnaround within 1–2 business days
Request Proposal

Course Overview

This 2-day course will take students who have little to no knowledge of Power BI to the point where they can create, publish and share rich reports and dashboards.

Audience

This course is for students that are looking to learn how to use the range of Microsoft Power BI tools to refine and model their data into a visual and interactive format. Students considering adopting this course are not required to have any prerequisite knowledge of Power BI or experience working on data modeling related tasks.

Course Benefits

  • You will know which Power BI tool to use for different projects.
  • You will be able to connect to and maintain connections to data sources.
  • You can query your data sources to refine the data you are pulling into your project.
  • You can optimize a data model to enhance the performance of your reports.
  • You will know how to use Data Analysis eXpression (DAX) language to create columns and measures.
  • You can create dimensional hierarchies and plot geographical data.
  • You can create engaging, visual reports from your data model.
  • You’ll be able to publish your project to a workspace and manage it from the Power BI web service.
  • You will be able to build dashboard to aggregate essential visuals from reports.
  • You well be able to share your reports to colleagues.

Delivery Methods

Private Class
Delivered for your team at your site or online.

Course Outline

  1. An introduction to Power BI
    1. What is business intelligence?
    2. Introducing Power BI
    3. Microsoft Power BI tools and services
    4. Case studies
    5. Support and information
    6. Data stories
  2. Requirements gathering
    1. Welcome to House Rules Board Games
    2. Discuss requirements
    3. Grain statements
    4. The Power BI build
    5. Data discovery
    6. Refine information
    7. Model data
    8. Build reports
    9. Create dashboards
    10. Choose workspaces
    11. Create and share a Power BI report
    12. Build a report in the Power BI service (Lab)
  3. Extract, transform, and load data
    1. Create a report with Power BI Desktop
    2. What is in a PBIX file?
    3. Connect to data sources
    4. Manage data connections
    5. Refine data with Power Query
    6. Use the Applied steps list
    7. Power Query M formula language
    8. Design a query
    9. Start a report in Power BI Desktop (Lab)
  4. Create a data model
    1. Understand relationships
    2. Format columns
    3. Introduction to DAX
    4. Design calculated columns
    5. Create measures
    6. Add lookup tables
    7. Structure data with dimensional hierarchies
    8. Roles and row-level security
    9. Design a data model (Lab)
  5. Design reports
    1. Add pages and navigation buttons
    2. Use shapes, text, and images
    3. Create a report theme
    4. Add visualizations
    5. Use filters and slicers
    6. Add drill throughs
    7. Add custom visualizations
    8. Configure a mobile layout
    9. Report tips
    10. Create a report (Lab)
  6. Use workspaces and dashboards
    1. Power BI licensing
    2. Workspaces
    3. Premium capacity workspaces
    4. Publish a report
    5. Parallels with Microsoft Excel
    6. Publishers and viewers
    7. Reconnect with data sources
    8. Schedule the frequency of data refresh
    9. Assign security roles
    10. Create and populate dashboards
    11. Customize dashboard tiles
    12. Create tiles using Q&A and quick insights
    13. Create a dashboard mobile layout
    14. Share reports and dashboards
    15. Publish apps in a workspace
    16. Publish content to websites
    17. Publish and share reports and dashboards (Lab)

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Power BI class:

  • Understanding core data concepts.
  • Knowledge of working with relational data in the cloud.
  • Knowledge of working with non-relational data in the cloud.
  • Knowledge of data analysis and visualization concepts.

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Contact us
}