Microsoft Power BI Interactive Data Visualizations

Length: 2 days

Course Description

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. This course covers both Power BI Online and Power BI desktop.

Audience

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

Course Objectives

Upon completing this course, students will have a good understanding of the following topics, as well as the 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

Power BI Introduction

    What is Power BI?

    Examining Power BI Suite of Products

    Identifying Differences Between Products

    Understanding Power BI Updates

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

Working with CSV, TXT and Excel Worksheets

    Importing Data

    Transforming Data

    Loading Data

    Appending Operations

    Working with Folders and Files

    Using Pivot Tables

Connecting to Databases

    Working with Relational Data

    Understanding Relationships

    Importing from SQL Server Analysis Services Multidimensional and Tabular

Merging, Grouping, Summarizing and Calculating Data

    Understanding the Issues with Merges

    Performing Merges

    Grouping Options

    Summarizing

    Calculating

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

Power BI Online

    Introduction to Power BI Online

    Importing Data

    Creating Reports

    Configuring Dashboards

    Sharing Reports and Dashboards

    Exploring Power BI Mobile