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
Storytelling
know your audience
Section Introduction
Visual Importance
Tailor your message
Text, Tables and Heatmap
Bad vs Good visuals
The main idea
Storytelling
Visual Importance
Bad vs Good visuals
know your audience
Tailor your message
The main idea
Section Introduction
Text, Tables and Heatmap
Line Chart
Scatter Plot
Column and Bar Chart
Combo Chart
Waterfall
What not to do
Exercise
Section Introduction
Pre-attentive attributes
Examples
Exercise
Why Dashboards
Decision Making
How to build Dashboard
Section Introduction
Power BI Download
User Interface
Data Understanding
Importing Data
Power Query 1
Power Query 2
Power Query 3
Power Query 4
Power BI Reporting
Formatting Charts
Adding New Chart
Creating Top N report with bar chart
Sorting a visual
Filtering using Slicers
Filter Interactions
Visuals Background
Working with shapes
Report Themes
Reusing Report as a Template
Add Back button
Mobile view
Q&A
Introduction to Data Modeling
Importance of Data Model
Building up a data model
Preparing Data Model in Power Query
Manage Relationship
Resolving Relationship Error
Testing Data Model
Introduction
Calendar table
Format Function
Connecting Calendar to Orders Table
Sorting Month
SUM Measure
Filters Pane 1
Calculate function
Create Table for Measures
Time Intelligence Formula
MOM variance
Remove filters
SPLY
YTD
Quick measure
Report Theme
Creating template
Revenue and SPLY on a chart
Forecast on a line chart
Waterfall chart
Matrix with Data Bars
clustered Column Chart
Bar and Ribbon chart
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.
Mentor
Mohamed AbdelMegeed
Business Intelligence Consultant
6,732 Learners
3 Courses