Course Overview
TOPScheduled Classes
TOPWhat You'll Learn
TOPAfter completing this course, students will be able to:
- Understand the basics of the SMARTerBI™ Dashboard & Data Analysis System for Microsoft Power BI
- Understand how to build dashboards using the basic capabilities of Microsoft Power BI
- Understand the fundamentals of data analysis concepts and methodologies
- Understand how to use the Power BI Data Table to produce an itemize list of data
- Understand how to use the Power BI Matrix to produce a summarize list of data
- Understand how to use the Power BI Chart to product visualize data
- Understand the data analysis structure and components of the Power BI Report environment
Outline
TOPModule 1 - Exploring Business Dashboards built using Microsoft Power BI Components
a) Understanding the Dashboard Components
b) Using the Dashboard to answer business questions
c) Reviewing business requirements for a dashboard
d) Exploring how the Microsoft Power BI can be used to build Business Dashboards
Module 2 - Getting Started with Data Analysis Structures of the Microsoft Power BI Report
a) Power BI Report
b) Power BI Data Model
c) Power BI Data Tables
d) Power BI Data Columns
e) Power BI Data Rows
f) Power BI Data Cells
g) Power BI Data Measures
Module 3 - Getting Started with Data Analysis Capabilities of the Microsoft Power BI Report
a) Data Transformation
b) Data Modeling
c) Data Visualization
Module 4 - Getting Started with Data Reporting Components of the Microsoft Power BI Report
a) Data Table
b) Data Matrix
c) Data Chart
d) Data Slicer
Hands-On Labs Outline
After completing this course, students will have performed the following labs:
Exercise 1 - How to build a Business Tracking Dashboard to itemize data using the Power BI Table component
a) Review business requirements for business tracking
b) Importing single data table in Power BI Data Model
c) Building the report interface using Data Table component
Exercise 2 - How to build a Business Metric Dashboard to summarize data using the Power BI Matrix component
a) Review business requirements for business metrics
b) Importing two data tables in Power BI Data Model
c) Create relationship within the Data Model
d) Creating simple measure using DAX functions to summarize data
e) Building the report interface using Data Matrix component
Exercise 3 - How to build a Business Sales Dashboard to visualize data using the Power BI Chart Component
a) Review business requirements for business metrics
b) Importing multiple data tables in Power BI Data Model
c) Create relationship within the Data Model
d) Creating advance measure using DAX functions to summarize data
e) Building the report interface using Data Table, Data Matrix and Data Chart components
