Power BI Dashboard Training (Sales & HR Analytics, Financial, Banking)

Power BI Dashboard Training

Overview:

Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals.

Who Should Attend:

This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.

At Course Completion:

Upon completing this course, students will have a basic understanding of the topics below, as well as an ability to utilize and implement the concepts learned.

Power BI

Power BI Desktop

Working with CSV, TXT, and Excel Worksheets

Connecting to Databases

Merging, Grouping, Summarizing, and Calculating Data

Reporting

Power BI Online

Course Outline:

Lesson 1: Course Overview

Lesson 2: Power BI

What is Power BI?

Examining Power BI Suite of Products

Identifying Differences Between Products

Understanding Power BI Updates

Lesson 3: Power BI Desktop

Installing Power BI Desktop

Exploring the Power BI Desktop Interface

Utilizing File Types; PBIX vs PBIT

Examining Data Sources

Discussing Data Refresh

Understanding Data Types

Lesson 4: Working With CSV, TXT and Excel Worksheets

Importing, Transforming, and Loading Data

Appending Operations

Working with Folders and Files

Using Pivot Tables

Lesson 5: Connecting to Databases

Working with Relational Data

Understanding Relationships

Importing from SQL Server Analysis Services Multidimensional and Tabular

Lesson 6: Merging, Grouping, Summarizing, And Calculating Data

Understanding the Issues with Merges

Performing Merges

Grouping Options

Summarizing

Calculating

Lesson 7: Reporting

Creating Reports

Utilizing the Matrix Visualization

Utilizing the Map Visualization

Utilizing the Card Visualization

Utilizing the Chart Visualization

Utilizing Slicers

Publishing to Power BI Online

Lesson 8: Power BI Online

Introduction to Power BI Online

Importing Data

Creating Reports

Configuring Dashboards

Sharing Reports and Dashboards

Exploring Power BI Mobile