Design modern UX Dashboard with Microsoft Power BI

Name: Design modern UX Dashboard with Microsoft Power BI
Rating: 4.7 (87 reviews)

Take your dashboard design and reporting skills to the next level. Design modern reports and Dashboards with Power BI.

Highest Rated

Created byFestMan Learning Hub, Thomas Festus Cudjoe

Last updated 12/2023

English

English [Auto],

What you'll learn

Data Analysts
Power BI enthusiasts
Business Analysts
Accountants
Financial Analysts
Students

Course content

5 sections • 34 lectures • 4h 13m total length

Dataset and icons2:28
Overview of the dataset2:43
Import and profile datasets10:23
Data modeling9:22
Key performance indicators: Total Orders2:47
Other KPIs8:19
Time Intelligence calculations9:02
Year on Year Analysis6:38

Visualize Key performance indicators 17:36
Visualize Key performance indicators 24:09
Modern bar chart - Orders by Country6:06
Orders by year and quarter6:27
Top 3 customers and discount band7:38
Designing button slicer10:27
Design and format a button slicer in Power BI to filter by product and reveal sales, profit margin, year on year change, country orders, top customer types, and discount-band revenue.
Adding product image and description6:56
Create two Power BI cards showing the selected product's name, description, and image via a slicer. Format callouts and labels and set the image URL for dynamic product visuals.

Report overview3:46
explore the final Power BI dashboard for product performance, highlighting best-selling products, profitability by product, and orders by category with year slicers and tooltips.
Report Layout8:24
Duplicate and rename the report to product analysis, then transform the dashboard layout with a white header, rounded shapes, a four-column horizontal slicer, and visuals for best-selling and profitability analysis.
Best selling products7:04
Explore best selling products by total orders in Power BI using a bar chart, with data labels, thousands display units, and an average reference line to rank products.
Most profitable customers10:53
Visualize the top four most profitable customer types by total profit in Power BI, using a bar chart and a dynamic subtitle that reflects the selected product.
Orders by product category3:59
Create a donut chart showing total orders by product category in Power BI, format legend top left, adjust slice colors and inner radius to 75%, and add a separator line.
Profitability Trend5:36
Slicer button design4:34
Adding check mark icon to slicers12:04
Google link prefix: https://drive.google.com/uc?export=view&id=
Adding report page tooltip16:42
Design a Power BI report page tooltip with a custom size and visuals, then assign it to a slicer to show product details on hover.
Finalizing report 35:23

Requirements

Prior knowledge of Microsoft Power BI is required
At least November 2023 version of Power BI Desktop

Description

Course Overview

Welcome to this end-to-end Power BI dashboard design course. In this course, you'll step into the role of a business intelligence analyst for Festman Studio, a global company that provides premium recording equipment for content creators.

Throughout this course, you'll have the opportunity to develop your design and Power BI skills as you help Festman Studio management harness the power of Microsoft Power BI to transform their raw data into actionable insights.

Project Background

You have been employed as a Business Intelligence Developer at Festman Studio and your role is to harness the power of Microsoft Power BI to transform raw data into actionable insights. You will design compelling visualizations and comprehensive reports that guide decision-makers in steering Festman Studio toward sustained success.

Task

Import the two tables into Power BI.
Profile and transform the data to ensure the data is clean and accurate
Analyze the data using DAX to calculate some key metrics.
Visualize the data to bring your insights to life.
Design a dynamic and interactive dashboard to summarize your insights.

Learning Objectives

By the end of this course, you will be able to:

Import, clean, and transform data in Power BI
Analyze data using DAX to calculate key metrics
Create compelling visualizations using Power BI's visualization tools
Design and implement interactive Power BI dashboards

Who this course is for:

This course is designed for aspiring and existing Business Intelligence analysts who want to learn how to use Microsoft Power BI to transform raw data into modern and actionable insights.
Those who want to take their dashboard design and visualization skills to the next level.

Design modern UX Dashboard with Microsoft Power BI

What you'll learn

Explore related topics

Course content

Data transformation and modeling8 lectures • 52min

Report page Design3 lectures • 19min

Data visualization and reporting7 lectures • 49min

Report 2: Profitability Analysis6 lectures • 55min

Report 3:Product Analysis Dashboard10 lectures • 1hr 18min

Requirements

Description

Who this course is for: