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
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:
Get Instant Notification of New Courses on our
Telegram channel.
. Datasets for practice
. Downloadable Power BI project files
. Update of more new dashboard templates
. 1-on-1 expert support
. Course Q&A forum
As 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.
Watch me First
How to access the downloaded files
Build your Portfolio for free
Learn how to build your portfolio site for free with spending any money
Picking the Right charts for your project
Learn the functions of charts before you use them
Banex Cycles Sales Dashboard
Project brief
Dashboard overview
Loading and Transforming Data
Correcting Relationships in Model view
Creating a Date Table
How to change Folder Path and clear Errors in Power BI and Power Query
How to use Sumx Related and DateAdd for aggrigation
Creating KPI Cards
Formatting KPI Cards
How to create Power BI Custom Chart 01
How to create Power BI Custom Chart 02
How to create Power BI Custom Chart 03
Fix Error in the Custom BlankSpace
Custom chart Color formatting and Resizing
Custom Chart formatting and Titles
Custom Value formatting
How to insert up and down Arrow for conditional formatting
How to create a Folder inside a Measure Table
How to create Product Ranking 01
Using Whatif Parameter to control Top N
Dynamic Titles and chart formatting
Creating a Custom Template
Banex Cycles Sales Dashboard Part 2
Project Brief
Dashboard overview
Profit details
Creating a custom Template
Store Sales Detailed Dashboard
Project Brief
Dashboard overview
Importing data to Power Query for cleaning and transformation
Table arrangement for Relationships
Understanding Relationships
Creating a Date or Calendar Table
Creating Relationships between Dates and sorting
How to hide Tables in Power BI
Dashboard development process
Creating a measure Table
Custom visual Variance calculations
Daily Revenue vs Target
Gross Profit and % of Margin
Line chart for Gross profit & Margin
Top selling Products and Brands
How to use a Bullet Chart by OKVIZ
Dashboard Formatting
Creating a Custom Template 01
Creating a Custom Template 02
Dashboard colors formatting 01
Dashboard color Formatting 02
Employees Detailed Dashboard
Project Brief
Employees Dashboard overview
Step development
How to calculate Salary till date
Edit Relationships
How to use Variable to create a Dynamic Title
Top Paid Employees
Employees by Work Distance
Employees by Absence Reasons
Work Absence and Employees by Roles
Dashboard arrangement
Creating a custom Template 01
Creating a custom Template 02
Formatting and getting Icons
Store Sales Customer Dashboard
Project Brief
Project Overview
Total Customers & Average Revenue Per Customers
Importing a Sparkline from the market place
Sales by Age Range
Sales by weekdays
Customer Spending Range 01
Customer Spending Range 02
Customers by Temperature of the moment
Creating a custom Template
Dashboard Formatting
Bike Accident Dashboard
Project Brief
Dashboard Tasks
Loading and Cleaning data
How to split table in Dimension in Power Query
Linking FactTable to the Lookup Tables
Connecting Tables
Custom Date Table 01
Custom Date Table 02
Aggregation using Sum and Countrows
How to create a switchable measure
Creating visual with our Switchable measure
How to Split Column in Power Query
How to categorize column
Using VAR to create Percentages
Organizing Visual on the Dashboard
Dynamic Title 01
Dynamic Title 02
Dynamic Title 03
Custom Template 01
Formatting and Exporting custom Template
Final Formatting
