97023: Power BI High Performance Workshop for Enterprise & Government

Course 97023

97023: Power BI High Performance Workshop for Enterprise & Government

To customize this class, call 800-453-5961 or click here to contact us

“Start with a Power BI class and build your Government Management Dashboard.”

Description Power BI High Performance Workshop

Learn how easy it is to take your data analytics to a new level! Work with Excel, Power BI Desktop, and Power BI in the cloud and connect databases to create your own reports and interactive dashboards.

This course is an Instructor-led class. This instructor-led course provides students who work with Microsoft Excel or Power BI the skills to analyze data and create Power BI Tiles and Dashboards. You will understand how this powerful business intelligent platform can work for your organization.


The primary audience for this course is individuals who use Excel, Access, Power BI or SQL Server, business analysts, IT Professionals or deal with business intelligence. These individuals usually analyze data on a day-to-day basis and can benefit from the visualizations and the streamlined querying capabilities of Power BI.

In this accelerated class you will leverage your Excel skills, Power BI Desktop and then the Power BI Service and Azure to get deep insights into your data to drive intelligent business decisions that move your enterprise forward.

Course Outline Power BI High Performance Workshop

  • Introduction: The BI and Power BI Environment
  • Big Picture Demonstration
  • Excel Data Analysis
  • Power BI Desktop, Service (Cloud), Editions (what you need to know) and Licensing (Free, Professional and Premium)
  • The Power Platform: Power BI, Power Apps and Power Automate
  • Demonstration: (Excel – Power BI Desktop – PB Cloud Service)

Module 1: Classic BI Data Analysis with Excel

  • Classic Data Analysis with Excel
  • Excel PivotTables
  • Limitations of Classic Data Analysis
  • Lab: Building a Classic Excel Dashboard

Module 2: The Excel Data Model

  • Using an Excel Data Model
  • Joining Tables
  • DAX (Data Analysis Expressions)

Module 3: Power BI Desktop and Building Charts and Dashboards

  • Developing Charts, Dashboards and Reports in Power BI Desktop
    • Importing Data
    • From local files
    • Different file type
    • Different file formats
    • Power BI Desktop – Accessing Data and Data Preparation
    • Overview of getting data from databases
  • Power BI Desktop – Data Modeling and Exploration

Power BI;

    • Service – Publishing Report andĀ Building Dashboard
    • Desktop – Data Exploration Continued and Data Visualization
    • Service
  • Power BI Service – Collaboration and Distribution

Module 4: Importing Data from Files

  • Importing Data into Excel
  • Shaping and Transforming Data
  • Loading Data

Module 5: Importing Data from Databases

  • Available Data Sources
  • Previewing, Shaping, and Transforming Data
  • Loading Data
  • Table Relationships and Hierarchies
  • Importing Data from Multiple Sources

Module 6: Importing Data from Excel Reports

  • Importing Data from Excel Reports
  • Transforming Excel Report Data

Module 7: Creating and Formatting Measures

  • Data Analysis Expressions Lesson
  • Measures
  • Advanced DAX Functions

Module 8: Visualizing Data in Excel

  • Using PivotCharts
  • Using Cube Functions
  • Creating Charts for Cube Functions

Module 9: Using Excel with Power BI

  • Power BI
  • Using Excel As a Data Source in Power BI
  • Power BI Mobile App

Module 10: Mentored Workshop

Use your organizations data and connect to network or Azure databases for multiple data sources to develop Dashboards for different departments in your organization. Each department uses the Power BI Desktop and then uploads department level information into the Power BI Cloud Service top rovide Department and Organization managers a top-level dashboard and the ability to drill-down to the detail level of each department.

Additional information


05/10/2021 (Live Virtual) $2,495, 06/14/2021 (Live Virtual) $2,495, 07/19/2021 (Live Virtual) $2,495, 08/16/2021 (Live Virtual) $2,495, 09/13/2021 (Live Virtual) $2,495, 10/11/2021 (Live Virtual) $2,495, 11/15/2021 (Live Virtual) $2,495, 12/20/2021 (Live Virtual) $2,495

Train Your Team

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Request Group Quote

Register - Choose Date


Number of Seats: