5 out of 5
5
20 reviews on Udemy

Design modern UX Dashboard with Microsoft Power BI

Take your dashboard design and reporting skills to the next level. Design modern reports and Dashboards with Power BI.
Instructor:
FestMan Learning Hub, Thomas Festus Cudjoe
1,052 students enrolled
English [Auto]
Data Analysts
Power BI enthusiasts
Business Analysts
Accountants
Financial Analysts
Students

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

  1. Import the two tables into Power BI.

  2. Profile and transform the data to ensure the data is clean and accurate

  3. Analyze the data using DAX to calculate some key metrics.

  4. Visualize the data to bring your insights to life.

  5. Design a dynamic and interactive dashboard to summarize your insights.

Learning Objectives

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

  1. Import, clean, and transform data in Power BI

  2. Analyze data using DAX to calculate key metrics

  3. Create compelling visualizations using Power BI’s visualization tools

  4. Design and implement interactive Power BI dashboards

Data transformation and modeling

1
Dataset and icons
2
Overview of the dataset
3
Import and profile datasets
4
Data modeling
5
Key performance indicators: Total Orders
6
Other KPIs
7
Time Intelligence calculations
8
Year on Year Analysis

Report page Design

1
Customize the color palette
2
Report page background
3
Adding Company profile

Data visualization and reporting

1
Visualize Key performance indicators 1
2
Visualize Key performance indicators 2
3
Modern bar chart - Orders by Country
4
Orders by year and quarter
5
Top 3 customers and discount band
6
Designing button slicer
7
Adding product image and description

Report 2: Profitability Analysis

1
Project 2 overview
2
Month on month calculations
3
Adding product button slicer
4
Profitability Trend
5
Adding card visual
6
Profit by customer types

Report 3:Product Analysis Dashboard

1
Report overview
2
Report Layout
3
Best selling products
4
Most profitable customers
5
Orders by product category
6
Profitability Trend
7
Slicer button design
8
Adding check mark icon to slicers

Google link prefix: https://drive.google.com/uc?export=view&id=

9
Adding report page tooltip
10
Finalizing report 3
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
5
5 out of 5
20 Ratings

Detailed Rating

Stars 5
20
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0