logo
ABD
LiveZilla Live Chat Software



Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey

Power BI Dashboard Building Level 1: SMART DATAAnalysis Strategies using Power Query & Power Pivot

SS Course: 9000368

Course Overview

TOP

This 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

TOP

What 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

TOP
Viewing outline for:

Module 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

TOP

Who Should Attend

TOP

Business professionals interested in learning to use the basic capabilities of Microsoft Power BI to build basic business dashboards and data analysis solutions.

Next Step Courses

TOP