Microsoft Power Bi Advanced Dashboard Full Practical Course (updated 1/2023)

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: Resume/CV Power BI Dashboard

Lecture 30 Resume Dashboard Task

Lecture 31 Dashboard overview

Lecture 32 Load Data to Power Query

Lecture 33 Tools and Skills rating 01

Lecture 34 Tools and Skills rating 02

Lecture 35 Creating a progress bar for Tools learned

Lecture 36 How to recycle through Creating a progress bar for Tools learned

Lecture 37 Filling the other bars

Lecture 38 Adding descriptor

Lecture 39 Creating chart for Skills Interest and Language

Lecture 40 Creating a custom Template 01

Lecture 41 Creating a custom Template 02

Lecture 42 Formatting and Exporting custom Template to Power BI

Lecture 43 Adding Portfolio Images to custom Template

Lecture 44 Formatting and designs for work experience

Lecture 45 Change custom Template and add Animated Icons

Lecture 46 Adding Company worked for

Lecture 47 Changing dashboard colors

Lecture 48 How to add Tooltips Images and Icons

Lecture 49 How to add web link or URL in Power BI

Lecture 50 Inserting Tooltips

Section 7: Store Sales Detailed Dashboard

Lecture 51 Project Brief

Lecture 52 Dashboard overview

Lecture 53 How to have all imported charts display in this Section

Lecture 54 Importing data to Power Query for cleaning and transformation

Lecture 55 Table arrangement for Relationships

Lecture 56 Understanding Relationships

Lecture 57 Creating a Date or Calendar Table

Lecture 58 Creating Relationships between Dates and sorting

Lecture 59 How to hide Tables in Power BI

Lecture 60 Dashboard development process

Lecture 61 Creating a measure Table

Lecture 62 Custom visual Variance calculations

Lecture 63 Daily Revenue vs Target

Lecture 64 Gross Profit and % of Margin

Lecture 65 Line chart for Gross profit & Margin

Lecture 66 Top selling Products and Brands

Lecture 67 How to use a Bullet Chart by OKVIZ

Lecture 68 Dashboard Formatting

Lecture 69 Creating a Custom Template 01

Lecture 70 Creating a Custom Template 02

Lecture 71 Dashboard colors formatting 01

Lecture 72 Dashboard color Formatting 02

Section 8: Employees Detailed Dashboard

Lecture 73 Project Brief

Lecture 74 Employees Dashboard overview

Lecture 75 Step development

Lecture 76 How to calculate Salary till date

Lecture 77 Edit Relationships

Lecture 78 How to use Variable to create a Dynamic Title

Lecture 79 Top Paid Employees

Lecture 80 Employees by Work Distance

Lecture 81 Employees by Absence Reasons

Lecture 82 Work Absence and Employees by Roles

Lecture 83 Dashboard arrangement

Lecture 84 Creating a custom Template 01

Lecture 85 Creating a custom Template 02

Lecture 86 Formatting and getting Icons

Section 9: Store Sales Customer Dashboard

Lecture 87 Project Brief

Lecture 88 Project Overview

Lecture 89 Total Customers & Average Revenue Per Customers

Lecture 90 Importing a Sparkline from the market place

Lecture 91 Sales by Age Range

Lecture 92 Sales by weekdays

Lecture 93 Customer Spending Range 01

Lecture 94 Customer Spending Range 02

Lecture 95 Customers by Temperature of the moment

Lecture 96 Creating a custom Template

Lecture 97 Dashboard Formatting

Section 10: Bike Accident Dashboard

Lecture 98 Project Brief

Lecture 99 Dashboard Tasks

Lecture 100 Loading and Cleaning data

Lecture 101 How to split table in Dimension in Power Query

Lecture 102 Linking FactTable to the Lookup Tables

Lecture 103 Connecting Tables

Lecture 104 Custom Date Table 01

Lecture 105 Custom Date Table 02

Lecture 106 Aggregation using Sum and Countrows

Lecture 107 How to create a switchable measure

Lecture 108 Creating visual with our Switchable measure

Lecture 109 How to Split Column in Power Query

Lecture 110 How to categorize column

Lecture 111 Using VAR to create Percentages

Lecture 112 Organizing Visual on the Dashboard

Lecture 113 Dynamic Title 01

Lecture 114 Dynamic Title 02

Lecture 115 Dynamic Title 03

Lecture 116 Custom Template 01

Lecture 117 Formatting and Exporting custom Template

Lecture 118 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