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.

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
Explore two tables—the source sales data and product details—covering date, country, customer type, discount band, units sold, cost and sale price, to import and transform in Power BI.
Import and profile datasets10:23
Data modeling9:22
Model data by linking the product dimension to the source fact with a one-to-many relationship, relate the date table to the source table, and enable time intelligence with calendar auto.
Key performance indicators: Total Orders2:47
Other KPIs8:19
Learn to compute total revenue, cost, profit, and profit margin in Power BI using related and sumx to multiply unit sold by sale price across tables, and create measures.
Time Intelligence calculations9:02
Master time intelligence calculations in Power BI by creating measures that compare last year to year over year using calculate and dateadd, covering orders, revenue, cost, profit, and margin.
Year on Year Analysis6:38

Customize the color palette6:24
Design and customize the report color palette in Power BI using hex codes, then apply a cohesive theme to visualizations and the sample dashboard.
Report page background8:00
Customize the report page background by adjusting the canvas color and transparency, and build header and card-shaped backdrops using rounded shapes with shadows and accent bars.
Adding Company profile4:42
Insert a card in Power BI, add the company logo and name, and customize with image and text boxes to create a cohesive company profile card.

Visualize Key performance indicators 17:36
Visualize key performance indicators by building a multi-element KPI visualization in Power BI, including total orders, total revenue, and profit margin, with customized formatting and callouts.
Visualize Key performance indicators 24:09
Modern bar chart - Orders by Country6:06
Orders by year and quarter6:27
Build a total orders by year and quarter visualization in Power BI using a date table, format the axes, and apply conditional formatting with colors to distinguish 2021 from 2022.
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.

Project 2 overview3:13
Preview the sample Power BI profitability report and analyze metrics across 12 months, including profit, margins, year on year and month on month changes by product, customer type, and category.
Month on month calculations6:14
Adding product button slicer13:02
Duplicate the report page to create a profitability analysis view. Add and configure a product button slicer in Power BI, format callouts, images, and hover states to enhance data slicing.
Profitability Trend4:08
Adding card visual17:07
Learn to create a Power BI card visual that displays year-on-year and month-on-month profit changes, and customize formatting, labels, colors, and reference data for clear profit analysis.
Profit by customer types10:54
Explore profitability by customer type and product in Power BI, analyzing profit, profit margin, and year on year profit with a matrix and a donut chart showing distribution by category.

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
Edit slicer interactions and visual filters in Power BI to present product insights, profitability trends, and year-over-year comparisons with tooltips showing revenue, orders, and profit.

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: