Data Visualization with Microsoft PowerBI Course

Overview

Introduction

In this course, you will be introduced to the key concepts in business intelligence (Bl), data analysis, and data visualization. Discover the capabilities of a self-service Bl solution and learn to create Power Bl Desktop queries and beautiful dashboards.

Who Should attend?

Data analysts, Business analysts, Business intelligence developers, SQL professionals Databases administrators, Data scientists and related professionals.

What you will learn

Class Activity Blocks

Activity 1: Exploring an Enterprise Bl Solution

Activity 2: Importing data in Excel data model

Activity 3: Transforming data in Power Query

Activity 4: Using Power Pivot in excel

Activity 5: Import Data into Power Bl

Activity 6: Transforming data using Query Editor

Activity 7: Shaping and Combining Data

Activity 8: Modeling Data

Activity 9: Creating a Power Bl Report

Activity 10: Creating a Power Bl Dashboard

Activity 11: Direct Connectivity

Activity 12: Using the Developer API

What you’ll learn

1. Connect directly to data stores
2. Describe how to connect to Excel data
3. Perform Power Bl desktop data transformation
4. Describe Power Bl desktop modelling
5. Create Power Bl desktop visualizations
6. Implement the Power Bl service
7. Describe how to collaborate with Power Bl data
8. Setting up Gateways to automatically update Power Bl reports
9. Describe the Power Bl developer API
10. Describe the Power Bl mobile app

Course Modules

Module 1: Introduction to Self-Service Bl Solutions

Module 2: Introducing Excel Bl (Power Query & Power Pivot)

Module 3: Importing data in Power Pivot data model

Module 4: Shaping and Combining Data using Power Query

Module 5: Data Visualizations using Power Pivot

Module 6: Introducing Power Bl

Module 7: Power Bl Data connections

Module 8: Shaping and Combining Data in Query Editor

Module 9: Modeling Data

Module 10: Interactive Data Visualizations

Module 11: Introducing Power Bl service (SaaS)

Module 12: Creating Dashboards in Power Bl Service

Module 13: Sharing Power Bl report within and outside your teams

Module 14: Direct Connectivity

Module 15: Developer API

Module 16: Power Bl mobile app

What you require

Prerequisites

• Basic knowledge of the Microsoft Windows OS and its core functionality
• An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
• Familiarity with Microsoft Office applications (particularly Excel)