Microsoft (MS) Power BI

A Quick Introduction

What is MSPBI and its scope

Learn the common work flow in MSPBI

Building blocks of MSPBI and its relations

Quick demo how to create a business dashboard in MSPBI

MSPBI components

Old vs. new technologies

Power BI Desktop/Service/Mobile

Getting Business Data

Get data in shape for use with MSPBI

Combining two or more data sets (source data) for reporting

Tackling messy data in MSPBI

Clean and transform data

Modelling in Power BI

How to connect many different data sources

Manage data source (database) relationships

Unique keys

Calculated columns and more

Custom calculations to evaluate time-based functions

Build calculated tables based on DAX formulas and expressions

Creating and viewing visuals easier with optimized models

Discover hierarchal drill-down tools for date fields

Data Visualization

Create and customize visualization in MSPBI and its power

Use combination charts

Create and format slicers with it

Map visualizations and its utilization

Use tables and matrixes

Long live bubbles

scatter charts in action

Advanced funnel and waterfall charts

Drive fast dashboard insights with gauges and numbers

Color your visualization world with colors

shapes and scales

Adding personal touch

logo etc. to reports and dashboards

Display and present your dashboard in a way you want with summarize data

Control how your report elements overlap with each other

Learn to drill into hierarchies

Manage how levels are shared (Z-order in reports)

How to use R visuals in MSPBI

Data Exploring & Sharing

Quick insights in Power BI Service

Create and configure a dashboard

Share dashboard with your organization

Display and edit visuals- tiles

full screen

Get more space on your dashboard

Install and configure a personal gateway

Excel and MSPBI

Import and excel table into Power BI

Import excel files with data models and power view sheets

Connect One Drive for business to MSPBI

Excel data in Power BI summary

DAX (Data Analysis Expression) Application

DAX and its basic building blocks

Create calculated columns (fields) and measures in MSPBI using DAX formulas

Breadth of functions available in DAX

User variables in DAX

Create expressions across multiple tables with relational functions;

Filter and evaluate tables using advanced table functions