Analyzing your data with Power BI

Introduction to Power BI

This module introduces the fundamental concepts of the Power BI platform. It provides a high level overview of Power BI Desktop and the Power BI Cloud Service. Participants will also setup a trial Office 365 subscription which will be used throughout the course when publishing and sharing Power BI artifacts.

• The need for Business Intelligence
• Self-Service BI versus Enterprise BI
• Core concepts of Power BI
• Introducing Power BI Desktop
• Introducing the Power BI Service
• Power BI Service Tiers and Features

Loading Data with Power BI Desktop

In this chapter you will learn how to create queries in Power BI Desktop to extract data from source systems like SQL Server, Oracle, Excel files, CSV files, and so on. Applying transformations that can filter, sort and clean the extracted data will also be covered.

• Core concepts of Power Query
• Creating Queries to load data
• Applying basic transformations
• Working with Direct Query
• LAB: Creating queries with Power BI Desktop

Designing Reports in Power BI Desktop

After the data model has been fine-tuned, we can use it to create our reports. Power BI allows you to create very impressive reports, and in this module we will explore many visualizations as well as the interaction between these visualizations.

• Overview of the Report Canvas
• Adding text boxes, shapes and images
• Using built-in visualizations
• Add style and branding through themes
• Printing a Power BI Report
• Creating Power BI Templates
• LAB: Designing Reports in Power BI Desktop

Introduction to the Power BI Service

If you want to share models and reports with you co-workers, you should upload them to the Power BI service. In this module you will learn about the general features of the Power BI service, the next modules dive into the details.

• What is the Power BI Service?
• Power BI Service pricing and features
• Working with Datasets and Reports
• Creating and using Workspaces
• LAB: Introduction to the Power BI Service