Power BI Training

POWER BI : Course Content

Getting Started

Guided Learning for Power BI
Using Power BI
Building Blocks of Power BI
A quick look at the Power BI Service
Review this First section of Guided Learning

Getting Data

Getting Data
Getting started with Power BI Desktop
Connect to data sources in Power BI desktop
Clean and Transform you data with the query Editor
More Advanced Data sources and transformation
Cleansing Irregularly Formatted Data Data
Additional features paid non paid features/comparision with other visualization tools

Modeling

Modeling
How to manage your data relationships
Create calculated columns
Optimizing Data Models for Better visuals
Create measures and work with time-based functions
Create Calculated Tables
Explore Time-Based Data

DAX

Introduction to DAX
DAX Calculation types
DAX Functions
Using variables in DAX Expressions
Table Relationships and DAX
DAX Tables and Filtering

Working with Date Table

Create a dynamic Date Table: Preview
Create a Dynamic Date Table in the Query Editor
Create a Custom Date Table
Create Year to Date, Month to Date and Week to Date Functions
Compare Data between Custom Quarter Periods

Visualizations

Visualizations
Create and customize simple visualizations
How to use Combination Charts
Create and format slicers
How to use map visualizations
How to use tables and Matrixes
How to used scatter charts
How to use water fall and funnel charts
How to use gauges and single number cards
How to modify colors in charts and visuals
Style your Reports with Shapes, Text boxes and Images
Style your reports with page layout and formatting
Create Complex Interaction between Visualizations
Duplicate a Report Page
Show categories with No Data
Customize visuals with Summarization and Category Options
Arrange the z-order of report elements
Visual hierarchies and drill down behaviour
R visuals in Power BI

Exploring Data

Exploring data
Use quick insights in the Power BI Service
Create and configure a dashboard
Ask questions of your data with Natural language
Create custom Q & A suggestions
Share dashboards with your organization
Display visuals and tiles full-screen
Edit Title details
Get more space on your dashboard

Power BI Service & Power BI Mobile

Module Introduction
Continuing our Work and why we need Power BI Service
Comparing Power BI Free, Pro and Premium
Logging in to Power BI Service
Understanding the Interface
Publishing and sharing
Publish Reports from Power bi desktop
Print and Export Power bi dashboard
Importing our Data from Power BI Desktop to Power BI Service
Understanding the Dataset Menu
Working on Reports
Introducing Dashboards
Exploring our Workspace
Data Refresh
Understanding Gateways
Comparing Personal and On-Premise Gateway and Installing a Gateway
Creating a Scheduled Refresh
Integrate OneDrive for business with Power BI
Publish a Report to the web from Power BI
Working alone or Collaborating with Colleagues
Collaborating in App Workspaces
Sharing the Results
Publishing the App
Create a content pack in power bi
Connect to a content pack from a group in Power bi
Edit content pack in power bi
Content Packs from Online Services
Power BI Mobile: Installing and Understanding the Mobile App
One Last Thing: Excluding Datasets from Sharing
Module Summary

Power BI Financial Dashboard

Power BI Finance Dashboard: Add Current Accounts, Income / Expense, Etc.
Activity: Data Structure and Profitability Ratio's
Power BI Finance Dashboards: Add Liquidity Ratios to Power BI Finance Dashboard
Activity: Add Liquidity Ratio's to the Finance Dashboard
Power BI Finance Dashboard: Add Activity Ratios to Power BI Finance Dashboard
Activity: Add Activity Ratio's to your Finance Dashboard
Power BI Finance Dashboard: Debt Ratio's
Activity: Add Debt Ratio's to your Power BI Desktop.
List of Financial Ratio's
Publish your dashboard to the Power BI Service and Share with your teams.
Activity: Publish and share your Power BI Report