Course Overview
TOPThis hands-on, 1-day course is designed for business professionals and individuals interested in learning a SMARTer way to use the basic capabilities of Microsoft Power BI to build basic business dashboards and data analysis solutions.
Scheduled Classes
TOPWhat You'll Learn
TOP- 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 01) 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 02) 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 03) Getting Started with Data Analysis Capabilities of the Microsoft Power BI Report
a) Data Transformation
b) Data Modeling
c) Data Visualization
Module 04) 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 01) 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 02) 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 03) 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
Prerequisites
TOPWe recommend the following courses or equivalent experience:
Who Should Attend
TOPBusiness professionals interested in learning to use the basic capabilities of Microsoft Power BI to build basic business dashboards and data analysis solutions.