Power BI Desktop

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

COURSE CONTENT

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 & Service

• Data Structure for Q&A

• Direct Query vs Import Data

MODELING WITH POWER BI

• Introduction to Modeling

• Using Dax Expressions

• Setup and Manage Relationships

• Cardinality and Cross Filtering

• Default Summarization & Sort by

• Creating Calculated Columns

• Creating Measures

POWER BI VISUALIZATIONS

• Creating Visualizations

• Color Formatting

• 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 & Conditional Formatting

• KPI's, Cards & Gauges

• Map Visualizations

• Custom Visuals

• Managing and Arranging

POWER BI VISUALIZATION TOOLS

• Introduction

• Standalone Tiles

• Data Driven Alerts

• Quick and Related Insights

PUBLISHING AND SHARING 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