Course Objectives

• Create data visualizations using Power BI Desktop
• Understand key concepts and techniques on creating data visualization
• Understand data relationships and how linkages are formed
• Understand and generate data for forecasting and trends

Course Outline

• What is Data Visualization?
• Navigating through Power BI Desktop and Data Models
• Setup and Data Visualization Techniques with Visual Filters and Power Query
• Creating Scorecards, KPIs and Gauge Charts and DAX Formulas
• Publishing Dashboards on Analysis Services
• Techniques to Provide Context and Details to Data and Using Predictive Analytics

Target Audience

• Executives, Senior Executives and Data Analyst, Managers
• Those keen to learn how to fully utilise Power BI Desktop as a BI tools
• Those keen to explore data analytics as a job role

Methodology

• Interactive lecture, hands-on demonstration and hands-on practical exercises

Course Content

Importing Data into Power BI Desktop

• Using Get Data feature
• Get Data from text files
• Get Data from spreadsheet files
• Get Data from database files
• Get Data from websites

Shape and Clean Data using Power Query

• Navigating Power Query Editor
• Removing rows and columns within Power Query
• Changing Data Types
• Entering data via Power Query
• Creating headers in Power Query
• Find and replacing values in columns
• Splitting and merging columns
• Using Unpivot feature
• Understanding Applied Steps in Query Editor

Building Data Models

• What is a Data Model?
• Types of Relationships
• Creating Relationships between Tables
• Creating a Link Table
• Creating a New Calculated Columns

Creating Basic Data Visualization

• Conditional Formating using background colours and data bars
• Using Bar, Column, Pie and other standard visualization
• Using KPI visualization and other visualization types

Introduction to Measures

• What is a measure?
• Creating measures
• Using measures for Gauge chart and KPI visualization
• Creating measures table

Introduction to DAX

• What is DAX?
• Basic DAX functions and formulas like SUM, AVERAGE, CALCULATE
• Difference between Iterator and Aggregator functions i.e. SUM vs SUMX
• Creating DAX with multiple tables
• Other DAX functions like COUNT, COUNTROWS, MAX, MIN, DIVIDE functions

Additional Data Visualization

• Creating Drillthroughs
• Creating Tooltips

Using Predictive Analytics and other Reference Lines

• Using Constant Line
• Using Min and MAX Line
• Using Average Line
• Using Median Line
• Using Percentile Line
• Creating Forecasting values