Microsoft Power Bi Advanced Dashboard Full Practical Course
Last updated 6/2024
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.83 GB | Duration: 14h 45m
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: Personal Financial Dashboard
Lecture 4 Dashboard overview
Lecture 5 Getting Data
Lecture 6 DAX for KPI Measures
Lecture 7 Formatting Cards and adding Sparkline
Lecture 8 Creating custom Template 01
Lecture 9 Creating Custom Template 02
Lecture 10 Creating a Guage Chart
Lecture 11 Adding Caption using Variable
Lecture 12 Income monthly trend and Slicer formatting
Lecture 13 Filtering income from Expenses
Lecture 14 Creating Alert icon in Power Point
Lecture 15 Writing DAX to create Alert
Lecture 16 General Dashboard formattings
Section 5: Assignment
Lecture 17 Assignment instruction
Section 6: Banex Cycles Sales Dashboard
Lecture 18 Project brief
Lecture 19 Dashboard overview
Lecture 20 Loading and Transforming Data
Lecture 21 Correcting Relationships in Model view
Lecture 22 Creating a Date Table
Lecture 23 How to change Folder Path and clear Errors in Power BI and Power Query
Lecture 24 How to use Sumx Related and DateAdd for aggrigation
Lecture 25 Creating KPI Cards
Lecture 26 Formatting KPI Cards
Lecture 27 How to create Power BI Custom Chart 01
Lecture 28 How to create Power BI Custom Chart 02
Lecture 29 How to create Power BI Custom Chart 03
Lecture 30 Fix Error in the Custom BlankSpace
Lecture 31 Custom chart Color formatting and Resizing
Lecture 32 Custom Chart formatting and Titles
Lecture 33 Custom Value formatting
Lecture 34 How to insert up and down Arrow for conditional formatting
Lecture 35 How to create a Folder inside a Measure Table
Lecture 36 How to create Product Ranking 01
Lecture 37 Using Whatif Parameter to control Top N
Lecture 38 Dynamic Titles and chart formatting
Lecture 39 Creating a Custom Template
Section 7: Banex Cycles Sales Dashboard Part 2
Lecture 40 Project Brief
Lecture 41 Dashboard overview
Lecture 42 Profit details
Lecture 43 Creating a custom Template
Section 8: Resume/CV Power BI Dashboard
Lecture 44 Resume Dashboard Task
Lecture 45 Dashboard overview
Lecture 46 Load Data to Power Query
Lecture 47 Tools and Skills rating 01
Lecture 48 Tools and Skills rating 02
Lecture 49 Creating a progress bar for Tools learned
Lecture 50 How to recycle through Creating a progress bar for Tools learned
Lecture 51 Filling the other bars
Lecture 52 Adding descriptor
Lecture 53 Creating chart for Skills Interest and Language
Lecture 54 Creating a custom Template 01
Lecture 55 Creating a custom Template 02
Lecture 56 Formatting and Exporting custom Template to Power BI
Lecture 57 Adding Portfolio Images to custom Template
Lecture 58 Formatting and designs for work experience
Lecture 59 Change custom Template and add Animated Icons
Lecture 60 Adding Company worked for
Lecture 61 Changing dashboard colors
Lecture 62 How to add Tooltips Images and Icons
Lecture 63 How to add web link or URL in Power BI
Lecture 64 Inserting Tooltips
Section 9: Store Sales Detailed Dashboard
Lecture 65 Project Brief
Lecture 66 Dashboard overview
Lecture 67 How to have all imported charts display in this Section
Lecture 68 Importing data to Power Query for cleaning and transformation
Lecture 69 Table arrangement for Relationships
Lecture 70 Understanding Relationships
Lecture 71 Creating a Date or Calendar Table
Lecture 72 Creating Relationships between Dates and sorting
Lecture 73 How to hide Tables in Power BI
Lecture 74 Dashboard development process
Lecture 75 Creating a measure Table
Lecture 76 Custom visual Variance calculations
Lecture 77 Daily Revenue vs Target
Lecture 78 Gross Profit and % of Margin
Lecture 79 Line chart for Gross profit & Margin
Lecture 80 Top selling Products and Brands
Lecture 81 How to use a Bullet Chart by OKVIZ
Lecture 82 Dashboard Formatting
Lecture 83 Creating a Custom Template 01
Lecture 84 Creating a Custom Template 02
Lecture 85 Dashboard colors formatting 01
Lecture 86 Dashboard color Formatting 02
Section 10: Employees Detailed Dashboard
Lecture 87 Project Brief
Lecture 88 Employees Dashboard overview
Lecture 89 Step development
Lecture 90 How to calculate Salary till date
Lecture 91 Edit Relationships
Lecture 92 How to use Variable to create a Dynamic Title
Lecture 93 Top Paid Employees
Lecture 94 Employees by Work Distance
Lecture 95 Employees by Absence Reasons
Lecture 96 Work Absence and Employees by Roles
Lecture 97 Dashboard arrangement
Lecture 98 Creating a custom Template 01
Lecture 99 Creating a custom Template 02
Lecture 100 Formatting and getting Icons
Section 11: Store Sales Customer Dashboard
Lecture 101 Project Brief
Lecture 102 Project Overview
Lecture 103 Total Customers & Average Revenue Per Customers
Lecture 104 Importing a Sparkline from the market place
Lecture 105 Sales by Age Range
Lecture 106 Sales by weekdays
Lecture 107 Customer Spending Range 01
Lecture 108 Customer Spending Range 02
Lecture 109 Customers by Temperature of the moment
Lecture 110 Creating a custom Template
Lecture 111 Dashboard Formatting
Section 12: Bike Accident Dashboard
Lecture 112 Project Brief
Lecture 113 Dashboard Tasks
Lecture 114 Loading and Cleaning data
Lecture 115 How to split table in Dimension in Power Query
Lecture 116 Linking FactTable to the Lookup Tables
Lecture 117 Connecting Tables
Lecture 118 Custom Date Table 01
Lecture 119 Custom Date Table 02
Lecture 120 Aggregation using Sum and Countrows
Lecture 121 How to create a switchable measure
Lecture 122 Creating visual with our Switchable measure
Lecture 123 How to Split Column in Power Query
Lecture 124 How to categorize column
Lecture 125 Using VAR to create Percentages
Lecture 126 Organizing Visual on the Dashboard
Lecture 127 Dynamic Title 01
Lecture 128 Dynamic Title 02
Lecture 129 Dynamic Title 03
Lecture 130 Custom Template 01
Lecture 131 Formatting and Exporting custom Template
Lecture 132 Final Formatting
Section 13: Bonus Dashboard
Lecture 133 Hr Attrition Dashboard and other Resources
Lecture 134 Other free Dashboard Bonus
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
MREOSOFTEGRPODTREFRADEVNCEFRDASHEBOERTR
you must be registered member to see linkes Register Now