WSQ Data Visualization Techniques Using Power BI ( Intermediate)

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

Funding

Additional Info