Logo

Maxtrain.com - [email protected] - 513-322-8888 - 866-595-6863

TLG-PBIDesktop1

Data Analysis using Power BI Desktop – Level 1 – Report Builder

Description

Data Analysis using Power BI Desktop - Level 1 - Report Builder

 

This Data Analysis using Power BI Desktop 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.

Outline

Lesson 1 : Introducing Power BI

What Is Power BI for the Cloud 
Power BI Key Features 
Self-Service BI Model 
Power BI Components

Lesson 2 : Defining a Report

What is a Power BI Report? 
Defining a Report 
Data-Driven Storytelling

Lesson 3 : Building Power BI Desktop Reports

Understanding the Design Interface 
Creating Reports 
Report Visualizations 
Formatting Visualizations 
Report Final Touches

Lesson 4 : Report Filtering

Highlighting, Drill-down & Data Actions 
Visual Interactions 
Visual Sorting and Slicers 
Visual, Report, & Page Filters

Lesson 5 : Understanding Power BI Data Models

Understanding Data Terminology 
Understanding Tables 
Understanding Relationships 
Diagnosing Data Models 
Data Model Schemas

Lesson 6 : Gathering Report Data

Data Queries vs Data Models 
Viewing & Refreshing a Data Source 
Modifying Report Data

Lesson 7 : Data Model Functions

Creating Calculated Columns 
What is DAX? 
Basic DAX Functions 
Date Hierarchies

Lesson 8 : Introducing the Power BI Service

Power BI Service Interface 
Connecting to Data Sources 
Uploading & Updating PBIX Reports 
Refreshing Power BI Data 
Power BI Service Report Interface Components

Lesson 9 : Building Power BI Service Dashboards

Dashboard Interface Components 
Building Dashboards 
Organizing Dashboard Elements

Lesson 10 : Using Q & A (Cortana)

Understanding Q & A 
Modifying Q & A Results 
Pinning Q & A results to a Dashboard

Lesson 11 : Sharing Reports & Dashboards

Sharing Content 
Managing Power BI Content 
Using App Workspaces 
Content Packs and Apps

Lesson 12 : Appendix A: Power BI Roles and Security

Power BI Roles

PreRequisites

General understanding of reporting requirements and a basic understanding of data base concepts is useful, but not required

 

Audience

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

$995.00 List Price

2 Days Course

Class Dates

Good To Go
$995.00
Remote Live

This class runs from 10:00 AM to 06:00 PM EDT
$995.00
Remote Live

This class runs from 10:00 AM to 06:00 PM EDT

MAX Educ. Savings
Categories: , ,
Loading ...