Dynamics 365
Power BI & Apps
Microsoft 365 (Office)
Cyber Security
Government Solutions

Upcoming Microsoft Power BI Training January 2021

Power BI High Performance Workshop for Enterprise & Government Training

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


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

This three-day workshop is three (3) days of Instructor-led class. This instructor-led course provides students who work with Microsoft Excel or Power BI the valuable skills to analyze data and create Power BI Dashboards, Tiles, and Reports. 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:

Introduction: The BI and Power BI Environment

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

Power BI Desktop – Accessing Data
Importing Data
From local files
Different file type
Different file formats
Overview of getting data from databases
Power BI Desktop – Data Preparation
· Power BI Desktop – Data Modeling and Exploration

Power BI Desktop – Data Exploration Continued
Power BI Desktop – Data Visualization
Power BI Service
Power BI Service – Publishing Report
Power BI Service – Building Dashboard
· 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
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.

We look forward to working with your organization to take you data analysis to the next level!

202 S.E. Church Street, Suite 203 Leesburg, VA 20175
800-453-5961 (Toll Free)
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram