This is the first course in the Data Analysis using Power BI Desktop series. This course lays the foundation for Power BI Report Builders. Report Builders will learn everything they need to create highly effective stand-alone and multi-page narrative reports using data sources that are created using Power BI Desktop. This course covers the use of both the Power BI Desktop application as well as the Power BI Service.

What is Power BI 

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want.

Power BI consists of:

• A Windows desktop application called Power BI Desktop.
• An online SaaS (Software as a Service) service called the Power BI service.
• Power BI mobile apps for Windows, iOS, and Android devices.

Power BI Desktop is a complete data analysis and report creation tool that you install for free application on your local computer. It includes the Query Editor, in which you can connect to many different sources of data, and combine them (often called modeling) into a data model. Then you design a report based on that data model.

Lesson 1: Introducing Power BI

• Power BI as Part of Power Apps
• What is Power BI
• Power BI Overview

Lesson 2: Understanding Power BI Data Models

• Understanding Data Terminology
• Data Normalization
• Understanding Tables & Relationships
• Diagnosing Data Models, Data Model Schemas

Lesson 3: Defining a Report

• Power BI Reports
• Report Objectives
• Data-Driven Narrative

Lesson 4: Building Power BI Desktop Reports

• Working with managed data
• Creating Visuals
• Formatting and Organizing Visuals
• Sharing

Lesson 5: Report Actions & Filtering

• Drill-Down, Drill-Through and other Data Actions
• Filters
• Visual Interactions
• Bookmarks and Buttons

Lesson 6: Report Data

• Data Queries vs Data Models
• Modifying Report Data

Lesson 7: Data Model Functions

• Calculated Columns
• What is DAX?
• Row Level Security

Lesson 8: Connecting to Power BI Service

• Power BI Service Interface
• Publish PBIX Reports and Get Data
• Creating your own Workspace
• Connecting to Data Sources
• Refreshing Power BI Data
• Power BI service Report Interface Components

Lesson 9: Building Power BI Service Dashboards

• Building Dashboards
• Organizing Dashboard Elements

Lesson 10: Service Analytics Features

• Dashboard Q & A
• Quick Insights

Lesson 11: Sharing Reports & Dashboards

• Sharing Content
• Managing App Workspaces & Adding Content

Lesson 12: Bonus Activity – Putting it all Together

• Power BI Roles

Basic experience with Microsoft Office, Microsoft Excel, and using Web Browsers. General understanding of basic database concepts is useful, but not required.

The Data Analysis using Power BI Desktop Level 1 are for Business Analysis/User - responsible for creating Reports using Power BI Desktop.