Published 12/2022

We will help you learn how to create Clean DASHOARDS (2023 Edition) Advanced Power BI analysis & data visualization

 

What you'll learn

Build professional-quality Dashboard and business intelligence reports from the ground up

I will show you free tool to build your Portfolio and showcase your Dashboard Project (skills) to prospective employers

Don't just create, learn how to make your dashboard very beautiful by creating custom templates

Understand the business intelligence workflow from end-to-end

Blend and transform raw data into beautiful interactive and dynamic dashboards

You will learn how to bring data to life for decision making ready

 

Requirements

Experience with Excel Power Query, Power Pivot & DAX is a plus, but not required

Microsoft Power BI Desktop (free download)

PC or Desktop with Power BI Desktop installed

 

Description

If you are new to Power BI or you have been using Power BI before now and you just want to increase your knowledge about effective, interactive, and dynamic clean dashboards you are at the right place.After learning with us we will teach you how to create your free portfolio to showcase your work to prospective employers across the world.This course is fully a project base course built to help you create an outstanding dashboard.After taking this course you will never create a basic Power BI dashboard again.ABOUT THE COURSE:Skills in data analysis, reporting and the creation of easy-to-use dashboards are HIGHLY valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of interactive and dynamic reports, data analysis, and effective dashboards.Join today and get immediate, lifetime access to the followings:. Datasets for practice. Downloadable Power BI project files. Update of more new dashboard templates. 1-on-1 expert support. Course Q&A forumAs earlier said this course is a project-based course and you are going to play the role of a Lead Business Intelligence Analyst. In the course, you are going to work with different companies like sales and non-financial companies.Get into the course and see how to play the role of an Analyst.

 

Overview

Section 1: Watch me First

 

Lecture 1 How to access the downloaded files

 

Section 2: Build your Portfolio for free

 

Lecture 2 Learn how to build your portfolio site for free with spending any money

 

Section 3: Picking the Right charts for your project

 

Lecture 3 Learn the functions of charts before you use them

 

Section 4: Banex Cycles Sales Dashboard

 

Lecture 4 Project brief

 

Lecture 5 Dashboard overview

 

Lecture 6 Loading and Transforming Data

 

Lecture 7 Correcting Relationships in Model view

 

Lecture 8 Creating a Date Table

 

Lecture 9 How to change Folder Path and clear Errors in Power BI and Power Query

 

Lecture 10 How to use Sumx Related and DateAdd for aggrigation

 

Lecture 11 Creating KPI Cards

 

Lecture 12 Formatting KPI Cards

 

Lecture 13 How to create Power BI Custom Chart 01

 

Lecture 14 How to create Power BI Custom Chart 02

 

Lecture 15 How to create Power BI Custom Chart 03

 

Lecture 16 Fix Error in the Custom BlankSpace

 

Lecture 17 Custom chart Color formatting and Resizing

 

Lecture 18 Custom Chart formatting and Titles

 

Lecture 19 Custom Value formatting

 

Lecture 20 How to insert up and down Arrow for conditional formatting

 

Lecture 21 How to create a Folder inside a Measure Table

 

Lecture 22 How to create Product Ranking 01

 

Lecture 23 Using Whatif Parameter to control Top N

 

Lecture 24 Dynamic Titles and chart formatting

 

Lecture 25 Creating a Custom Template

 

Section 5: Banex Cycles Sales Dashboard Part 2

 

Lecture 26 Project Brief

 

Lecture 27 Dashboard overview

 

Lecture 28 Profit details

 

Lecture 29 Creating a custom Template

 

Section 6: Store Sales Detailed Dashboard

 

Lecture 30 Project Brief

 

Lecture 31 Dashboard overview

 

Lecture 32 Importing data to Power Query for cleaning and transformation

 

Lecture 33 Table arrangement for Relationships

 

Lecture 34 Understanding Relationships

 

Lecture 35 Creating a Date or Calendar Table

 

Lecture 36 Creating Relationships between Dates and sorting

 

Lecture 37 How to hide Tables in Power BI

 

Lecture 38 Dashboard development process

 

Lecture 39 Creating a measure Table

 

Lecture 40 Custom visual Variance calculations

 

Lecture 41 Daily Revenue vs Target

 

Lecture 42 Gross Profit and % of Margin

 

Lecture 43 Line chart for Gross profit & Margin

 

Lecture 44 Top selling Products and Brands

 

Lecture 45 How to use a Bullet Chart by OKVIZ

 

Lecture 46 Dashboard Formatting

 

Lecture 47 Creating a Custom Template 01

 

Lecture 48 Creating a Custom Template 02

 

Lecture 49 Dashboard colors formatting 01

 

Lecture 50 Dashboard color Formatting 02

 

Section 7: Employees Detailed Dashboard

 

Lecture 51 Project Brief

 

Lecture 52 Employees Dashboard overview

 

Lecture 53 Step development

 

Lecture 54 How to calculate Salary till date

 

Lecture 55 Edit Relationships

 

Lecture 56 How to use Variable to create a Dynamic Title

 

Lecture 57 Top Paid Employees

 

Lecture 58 Employees by Work Distance

 

Lecture 59 Employees by Absence Reasons

 

Lecture 60 Work Absence and Employees by Roles

 

Lecture 61 Dashboard arrangement

 

Lecture 62 Creating a custom Template 01

 

Lecture 63 Creating a custom Template 02

 

Lecture 64 Formatting and getting Icons

 

Section 8: Store Sales Customer Dashboard

 

Lecture 65 Project Brief

 

Lecture 66 Project Overview

 

Lecture 67 Total Customers & Average Revenue Per Customers

 

Lecture 68 Importing a Sparkline from the market place

 

Lecture 69 Sales by Age Range

 

Lecture 70 Sales by weekdays

 

Lecture 71 Customer Spending Range 01

 

Lecture 72 Customer Spending Range 02

 

Lecture 73 Customers by Temperature of the moment

 

Lecture 74 Creating a custom Template

 

Lecture 75 Dashboard Formatting

 

Section 9: Bike Accident Dashboard

 

Lecture 76 Project Brief

 

Lecture 77 Dashboard Tasks

 

Lecture 78 Loading and Cleaning data

 

Lecture 79 How to split table in Dimension in Power Query

 

Lecture 80 Linking FactTable to the Lookup Tables

 

Lecture 81 Connecting Tables

 

Lecture 82 Custom Date Table 01

 

Lecture 83 Custom Date Table 02

 

Lecture 84 Aggregation using Sum and Countrows

 

Lecture 85 How to create a switchable measure

 

Lecture 86 Creating visual with our Switchable measure

 

Lecture 87 How to Split Column in Power Query

 

Lecture 88 How to categorize column

 

Lecture 89 Using VAR to create Percentages

 

Lecture 90 Organizing Visual on the Dashboard

 

Lecture 91 Dynamic Title 01

 

Lecture 92 Dynamic Title 02

 

Lecture 93 Dynamic Title 03

 

Lecture 94 Custom Template 01

 

Lecture 95 Formatting and Exporting custom Template

 

Lecture 96 Final Formatting

 

People with Analytics mindsetData analysts and Excel users at any levels hoping to develop advanced data modeling, dashboard design, and business intelligence skills,Anyone looking to pursue a career in data analysis or business intelligence,Student who wants to learn how to approach projects and solve clients problems using data