Data Visualization With Power BI

categories: Technology, Science & Productivity

Data

Technology

SDG 4: Quality Education

SDG 8: Decent Work and Economic Growth

SDG 9: Industry, Innovation and Infrastructure

By the end of this course, you will be able to

Understanding the principles of transforming data into interactive dashboards, like visualizations, target audience, and important information within reports.
Using the most popular business intelligence tools used by professional analysts and data scientists, and then generating high-quality, professional reports from scratch.
Understanding Data Modeling and eliminating redundant data from a large data set by separating the tables into fact and dimension tables from scratch.

Course details

3 h 34 m/75 lessons
Last updated: 10/11/2022
Course completion certificate

Course Content

Free lessons

Storytelling

know your audience

2 Minutes

Section Introduction

Visual Importance

1 Minutes

Tailor your message

1 Minutes

Text, Tables and Heatmap

2 Minutes

Bad vs Good visuals

1 Minutes

The main idea

1 Minutes

1. Introduction

Storytelling

Visual Importance

1 Minutes

Bad vs Good visuals

1 Minutes

2. Context

know your audience

2 Minutes

Tailor your message

1 Minutes

The main idea

1 Minutes

3. Visuals

Section Introduction

Text, Tables and Heatmap

2 Minutes

Line Chart

Scatter Plot

Column and Bar Chart

1 Minutes

Combo Chart

1 Minutes

Waterfall

What not to do

1 Minutes

Exercise

2 Minutes

4. Focusing Attention

Section Introduction

Pre-attentive attributes

Examples

4 Minutes

Exercise

1 Minutes

5. Dashboards

Why Dashboards

1 Minutes

Decision Making

How to build Dashboard

1 Minutes

6. Power BI

Section Introduction

1 Minutes

Power BI Download

1 Minutes

User Interface

4 Minutes

Data Understanding

3 Minutes

Importing Data

2 Minutes

Power Query 1

6 Minutes

Power Query 2

2 Minutes

Power Query 3

3 Minutes

Power Query 4

3 Minutes

7. Visualizing Reports

Power BI Reporting

5 Minutes

Formatting Charts

4 Minutes

Adding New Chart

2 Minutes

Creating Top N report with bar chart

3 Minutes

Sorting a visual

3 Minutes

Filtering using Slicers

4 Minutes

Filter Interactions

2 Minutes

Visuals Background

1 Minutes

Working with shapes

1 Minutes

10.

Report Themes

2 Minutes

11.

Reusing Report as a Template

3 Minutes

12.

Add Back button

2 Minutes

13.

Mobile view

3 Minutes

14.

Q&A

3 Minutes

8. Data Modeling

Introduction to Data Modeling

4 Minutes

Importance of Data Model

11 Minutes

Building up a data model

3 Minutes

Preparing Data Model in Power Query

5 Minutes

Manage Relationship

2 Minutes

Resolving Relationship Error

5 Minutes

Testing Data Model

1 Minutes

9. Introduction to DAX

Introduction

2 Minutes

Calendar table

2 Minutes

Format Function

5 Minutes

Connecting Calendar to Orders Table

2 Minutes

Sorting Month

1 Minutes

SUM Measure

3 Minutes

Filters Pane 1

3 Minutes

Calculate function

4 Minutes

Create Table for Measures

1 Minutes

10.

Time Intelligence Formula

3 Minutes

11.

MOM variance

2 Minutes

12.

Remove filters

5 Minutes

13.

SPLY

3 Minutes

14.

YTD

3 Minutes

15.

Quick measure

2 Minutes

10. Visualizing Measures

Report Theme

1 Minutes

Creating template

4 Minutes

Revenue and SPLY on a chart

5 Minutes

Forecast on a line chart

4 Minutes

Waterfall chart

2 Minutes

Matrix with Data Bars

1 Minutes

clustered Column Chart

3 Minutes

Bar and Ribbon chart

4 Minutes

About this course

Data visualization is the process of converting raw data (text, numbers, or symbols) into visual representations. Those visualizations are in the form of charts and graphs. Its purpose is to make data easier and faster to understand. Power BI is a technology-driven business intelligence tool provided by Microsoft for the purpose of analyzing and visualizing this raw data to present actionable information and help an organization make data-driven decisions. In this course, you will learn about Data Visualization principles, BI tools, and how to use them in making data-driven decisions.

Course requirements and prerequisites

There are no requirements for this course. Your interest in the topic and your commitment to learning are all you need to achieve the utmost benefit from this course.