Microsoft Power Bi Advanced Dashboard Full Practical Course

[LeeAndro]

Published 12/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 6.85 GB | Duration: 10h 27m

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 )
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, life access to the followings:. Datasets for practice. able 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 ed 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 Transfog 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 Ma

Lecture 43 Line chart for Gross profit & Ma

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

HomePage:

https://www.udemy.com/course/microsoft-power-bi-advanced-dashboard-full-practical-course/

DOWNLOAD

https://1dl.net/y0umf5izwx7o/tKJC6dN6__MicrosoftP.part1.rar
https://1dl.net/zg6b167c47og/tKJC6dN6__MicrosoftP.part2.rar
https://1dl.net/ch2c0ava3c81/tKJC6dN6__MicrosoftP.part3.rar
https://1dl.net/59fxo2mlmzxj/tKJC6dN6__MicrosoftP.part4.rar
https://1dl.net/7nwwij7gzxt5/tKJC6dN6__MicrosoftP.part5.rar
https://1dl.net/bk3p1iw9gnij/tKJC6dN6__MicrosoftP.part6.rar
https://1dl.net/49guoe42pe3a/tKJC6dN6__MicrosoftP.part7.rar