POWER BI data Analytics Course and DASHBOARDS creation 2022

Power BI Dashboard Advanced Example, Better ways to create Advanced Power BI Visualization and impress your Boss, Now.

What you will learn

Learn how to create a clean decision making dashboard in POWER BI

How to sign up for Power BI Service without a working email

You will learn how to Get and Transform multiple sources of data, including merging multiple files from a folder, pivoting and unpivotting.

Create designs from Power Point and import to Power BI to make your designs outstanding

Master data analysis expression (DAX) for Power BI Desktop and build better dashboards

How to join data challenges and win amazing prices

Description

LET ME TAKE YOU BY HAND TO CREATE STUNNING DASHBOARDS FOR YOUR ORGANIZATION OR CLIENTS

Today I’m going to share with you my whole journey as a POWER BI Data Visualization Engineer. All I do is help companies and organizations or clients create an outstanding and well-built interactive Power BI Dashboard to help them understand trends and other metrics.

CONTENT OVERVIEW.

I don’t care If you have any analytics background before now, this course dives deep down into every elementary you need to grow and get creative as a POWER BI Analyst and Data Visualization Engineer.

This course is 100% practical with real-life data to understand how to approach projects, and what to do to achieve the aims of your clients or your boss in the office.

Get Instant Notification of New Courses on our Telegram channel.

You might be good at writing DAX in POWER BI but not always cool with the end results of either your reports or dashboards, I am going to say that is why I am here. I am here to help you with DAX, data cleaning, and transformation using POWER QUERY.

My dashboards look stunning and outstanding because I use an external tool called POWERPOINT to create beautiful background temples. In this course, I am going to teach you how to use PowerPoint to create a background template for your dashboards and import it to POWER BI.

I went through some POWER BI dashboards challenges I had taken part in and won some.

As soon as you complete this course, you can apply for a Power BI job with no fear. Take part in data challenges and show them what you got.

Are you ready now? If you are, sign up for the course.

English

language

Content

What Me First

Course Tasks

About dashboard templates designs

How to handle Power Query error

Do this if you have errors in Power Query

Free Business Email for Power BI Service

Get free business email for Power BI service

Regional Sales Dashboard (Customer Retargeting)

Dashboard overview

Creating our beautiful custom templates 01

Creating dashboard template 02

Creating dashboard template 03

Creating dashboard template 04

Creating dashboard template 05

Creating dashboard template 06

Exporting custom dashboard template in JPEG format

Importing custom template the right way

Importing data to power query

Creating shipping and delivery intervals

Converting numbers to readable words in Power Query

Importing and cleaning dimensional tables

Adding label and animated circle dashboard home page

Creating our first DAX Measures

Formatting cards

Creating customer retargeting 01

Creating customer retargeting 02

Getting custom horizontal bar chart

Customers Retargeting custom template

Add Animated GIF and template

Formatting our dashboard

Regional Sales Dashboard (Order or Transation Analysis)

1 Adding template

2 KPI

Creating chart with custom legends

Getting and adding Icons

Filter quantity ordered for legends

Adding values to match legends

Adding more measures to tooltip

Creating dynamic caption

Adding percentages to caption 01

Adding percentages to caption 02

Adding filters

Regional Sales Dashboard (Products insights)

Measures for Simple aggregations

Top Selling products by transactions, sales & revenue

Visualizing top products

5 Creating least profitable products

Inserting and formatting table

Regional Sales Dashboard (Sales Team Analysis)

Exporting and importing template

Full sales details

Revenue by region and table formatting

Regional Sales Dashboard (Store locations analysis)

Custom template for store locations

No. states and store locations

Inserting location map

Formatting location map

Regional Sales Dashboard (Time range analysis)

Creating custom template

Custom Date table 01

Custom Date table 02

Restricting date table to a column with VAR

Creating switchable measures

Getting measure selected

Creating caption measure

Creating active measures

Quarterly view for switchable measures

Values on cards

Weekly and monthly trends

Adding required filters

More info on a card

Average sales per day

Measures for best selling days

Formatting Measures for best selling days

Adding year filter

Creating icons for page navigations

Hide and show Nav Icons or buttons

Publishing to web

Advanced Sales Analysis for Bakery Company

Data cleaning and transformation

Creating background using PowerPoint

3 Creating a custom date table

Extracting the right last transactional date

Total revenue for the last two years

Getting the current date

Revenue by pie types for the current 2 year

Calculating numbers of transaction with other metrics

Formatting Chart for organic revenue

calculating percentages for pie types

Dashboard formatting

Phase 2 Duplicating current page

Cumulative total revenue

Writing variable to compute yearly difference

Revenue comparison using Ribbon chart

Creating table to compare order types and Quarterly revenue

Adding page navigation

Adding slicers

19 How to get more dataset to practice

Employees Insight Dashboard (HR)

Dashboard overview

Importing dataset to Power Query

Making of our Dashboard Background

Active and Inactive Employees measures

Getting employees turnover, average salary and all employees salary

Creating side bar KPIs cards

Employees Attrition cards

Creating descriptive text for your dashboard

Cost center table analysis with colorful formatting

Formatting dropdown filters

Horizontal filter formatting

phase 2 Duplicating our dashboard

cumulative employees count overtime

Sick days and showcasing gender

Adding metrics table

Child Abuse Dashboard

Dashboard Overview

Importing data and cleaning

Loading data to Power BI

Creating template 01

Creating template 02

Creating template 03

Importing template to Power BI desktop

Important KPI’s

Top child care providers

Top child guidance states

KPI’s for other professions

Top 6 states with highest states

Highest perpetrator states

USA International Travel Dashboard

Loading data to power bi

Creating templates 01

Creating templates 02

Creating templates 03

Connecting the date table

Exporting template and importing to power bi

Creating our first measures

2020 most USA travel destinations

Percentage of 2021 Most travel destination

Quick 2021 most USA travel destinations

Top 10 over all most travel destinations

Percentage Top 10 over all most travel destinations

Weekly and monthly traveling trends

Formatting quarterly chart

Advanced Sales Analysis Dashboard

Creating template 01

Creating template 02

Creating template 03

Creating template 04

Loading datasets to Power Query engine

Data cleaning in Power Query

Checking data types and load

Exporting and importing templates to Power BI

Calendar table and relationships

Calculate important measures before branching out

Filling up and formatting our visual cards

Inserting dynamic kpi card for budge and sales variance

Formatting our custom KPI card

Creating quarters card labels

Filtering quarterly sales or revenue

Quarterly number formatting

Inserting and formatting filters

Editing filters interactions

Fixing filter values colors

Creating customer grouping

Pie Bakery Dashboard