Microsoft Power BI Super User

Microsoft Power BI Super User (55400)

Course Length: 2 days
Delivery Methods: Multiple delivery options
Course Overview

Empower your team or yourself with the capabilities of Microsoft Power BI in our Microsoft Power BI Super User course. Dive into the world of Business Intelligence and harness the power of visual data representations to enhance decision-making processes within your organization. This course is tailored to guide you through the essential facets of Power BI, from foundational concepts to the creation of insightful dashboards and reports.

We begin with An Introduction to Power BI, familiarizing you with the core tools and features of Power BI, including the Power BI Report Server and Power BI Desktop. This module offers a comprehensive overview of Business Intelligence concepts and shows you where to access ongoing support and information.

Next, you'll explore Requirements Gathering, focusing on the initial stages of a BI project. Grasp the importance of grain statements and data modeling as you navigate through the project lifecycle, using the Power BI web service to produce compelling reports and dashboards.

In the Extract, Transform, and Load Data module, engage with Power BI Desktop to manipulate and format data effectively. Learn to extract, transform, and load data as part of your queries, setting the foundation for robust data analysis and visualization.

Creating a Data Model will guide you in optimizing data relationships within your projects. Understanding and managing these connections are key to building efficient models, along with mastering Data Analysis Expressions (DAX) to craft new columns and measures for enriched reporting.

The Designing Reports segment emphasizes crafting visually engaging and interactive reports. Discover how to customize themes and integrate various visualizations, along with filters and slicers to refine the user experience. Enhance your reports with custom visuals and intuitive navigation features.

Conclude your learning journey with Using Workspaces and Dashboards, where you'll publish your work and learn about the different licensing and workspace options. You'll also explore creating and sharing dashboards, engaging with mobile platforms, and utilizing the on-premises data gateway for secure data access.

By the end of this course, you or your organization will be proficient in utilizing Power BI to transform raw data into meaningful insights. You'll be equipped to design and share impactful data stories that drive informed business decisions, utilizing the full suite of Power BI capabilities efficiently.

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.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Course Outline
  1. An Introduction to Power BI
    1. What is business intelligence?
    2. Introducing Power BI
    3. Power BI tools and services
    4. Power BI Report Server
    5. Power BI (Online)
    6. Power BI Desktop
    7. Case studies
    8. Support and information
    9. Data stories
    10. Lab: Getting Ready
      1. Sign in to Office 365
      2. Download course files
      3. Place data sources into OneDrive
      4. Create further user accounts
  2. Requirements Gathering
    1. Welcome to House Rules Board Games
    2. Beginning a BI project
    3. Grain statements
    4. Data discovery
    5. Refining information
    6. Modeling data
    7. Building reports
    8. Roles
    9. Publishing
    10. Creating dashboards
    11. Choosing workspaces
    12. Create and share a report in Power BI
    13. Lab: Build a report in Power BI web
      1. Connect to an Excel spreadsheet
      2. Build visualizations
      3. Create a dashboard for desktop and mobile users
      4. Share your report and dashboard
  3. Extract, transform and load data
    1. Creating a project with Power BI desktop
    2. Pinning an active project
    3. What is in a PBIX file?
    4. Connecting to data sources
    5. Managing data connections
    6. Refine data with Power Query
    7. Applied steps
    8. M code language
    9. Designing your query
    10. Choose columns
    11. Rename columns
    12. Moving columns
    13. Formatting columns
    14. Replacing values
    15. Expanding related columns
    16. Star schemas
    17. Merge columns
    18. Split columns
    19. Custom and conditional columns
    20. Lab: Starting a project in Power BI desktop
      1. Creating a new PBIX project file
      2. Connecting to data sources
      3. Use the query editor to refine data
      4. Review the table relationships
      5. Optional – Connect to an Azure SQL database
  4. Creating a data model
    1. Understanding relationships
    2. Cardinality
    3. Cross filter direction
    4. Hiding tables and columns
    5. Formatting columns
    6. Introducing DAX
    7. Designing calculated columns
    8. Creating measures
    9. Adding lookup tables
    10. Structuring data with dimensional hierarchies
    11. Roles and row level security
    12. Lab: Designing a data model
      1. Hide and format table columns
      2. Create calculated columns
      3. Create measures
      4. Using geographical data and lookup tables
      5. Create a dimensional hierarchy
  5. Designing Reports
    1. Adding pages and navigation buttons
    2. Using shapes, text and images
    3. Creating a theme
    4. Adding visualizations
    5. Using filters and slicers
    6. Controlling filters
    7. Adding drill throughs
    8. Adding custom visualizations
    9. Configure phone layouts
    10. Report tips
    11. Lab: Creating a report
      1. Creating new pages and adding basic content
      2. Adding and configuring visualizations
      3. Design slicers
      4. Create bookmarks and navigational buttons
  6. Using workspaces and dashboards
    1. Power BI licensing
    2. My workspaces
    3. App workspaces
    4. Premium capacity workspaces
    5. Creating a new workspace
    6. Publishing a project
    7. Parallels with Microsoft Excel
    8. Publishers and viewers
    9. Reconnecting with data sources
    10. Introducing the on-premises data gateway
    11. Scheduling the data refresh frequency
    12. Assigning security roles
    13. Creating and populating dashboards
    14. Customizing dashboard tiles
    15. Creating tiles using Q&A and quick insights
    16. Creating a mobile dashboard
    17. Sharing reports and dashboards
    18. Publishing apps in a workspace
    19. Publishing content to websites
    20. Lab: Publish and share reports and dashboards
      1. Publish your project to Power BI
      2. Create a dashboard
      3. Use quick insights and pin visuals
      4. Use Q&A to query your data source
      5. Share your dashboard with marketing
Class Materials

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

Class Prerequisites

Experience in the following is required for this Microsoft Business Intelligence 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.
Live Public Class
$1,190.00 / student
Please select a class.
Live Private Class
  • Private Class for your Team
  • Live training
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Proposal