Power BI

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations and publishing the visualizations

Introducing Power BI

• Get Power BI Tools

• Introduction to Tools and Terminology

• Dashboard in Minutes

• Refreshing Power BI Service Data

• Interacting with your Dashboards

• Sharing Dashboards and Reports

Getting And Transforming Data With Power BI

• Introduction to Power BI Desktop

• Getting Data: Excel vs Power BI Desktop and Service

• Data Structure for Q&A

• Direct Query vs Import Data

Modeling With PowerBI;

• Introduction to Modeling

• Using Dax Expressions;

• Setup and Management of Relationships

• Cardinality and cross-filtering;

• Default Summarization and Sort by Creating Calculated Columns;

• Creating Measures PowerBI Visualizations:

• Creating Visualizations

• Color-formatting Services Supply Arrangement

• E60ZH?2100LS 125 ZH SO and E60ZH?2100LS 059 ZH SA 2

• Setting Sort Order

• Scatter & Bubble Charts & Play Axis

• Tooltips

• Slicers & Timeline Slicers

• Cross Filtering and Highlighting

• Visual, Page and Report Level Filters

• Drill Down/Up • Hierarchies

• Reference/Constant Lines

• Tables, Matrices and Conditional Formatting

• KPI's, Cards and Gauges

• Map Visualizations

• Custom Visuals

• Managing and Arranging PowerBI Visualization Tools

• Introduction;

• Standalone Tiles;

• Data-Driven Alerts

• Quick and Related Insights

Introduction

• Sharing Options Overview

• Publish from Power BI Desktop;

• Publish to Web;

• Print or Save as PDF

Refreshing Datasets

• Understanding Data Refresh:

• Replacing a Dataset