Power BI Desktop
Time & Location
About the Course
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
- 4 or more Course Participants$598+$77.74 HST$598+$77.74 HST0$0
- 2 - 3 Course Participants$798+$103.74 HST$798+$103.74 HST0$0
- Course Calendar Date Pricing$598+$77.74 HST$598+$77.74 HST0$0
- 1 on 1 Training$998+$129.74 HST$998+$129.74 HST0$0