Mô tả

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

Bạn sẽ học được gì

Data Analysts

Power BI enthusiasts

Business Analysts

Accountants

Financial Analysts

Students

Yêu cầu

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

Nội dung khoá học

5 sections

Data transformation and modeling

8 lectures
Dataset and icons
02:28
Overview of the dataset
02:43
Import and profile datasets
10:23
Data modeling
09:22
Key performance indicators: Total Orders
02:47
Other KPIs
08:19
Time Intelligence calculations
09:02
Year on Year Analysis
06:38

Report page Design

3 lectures
Customize the color palette
06:24
Report page background
08:00
Adding Company profile
04:42

Data visualization and reporting

7 lectures
Visualize Key performance indicators 1
07:36
Visualize Key performance indicators 2
04:09
Modern bar chart - Orders by Country
06:06
Orders by year and quarter
06:27
Top 3 customers and discount band
07:38
Designing button slicer
10:27
Adding product image and description
06:56

Report 2: Profitability Analysis

6 lectures
Project 2 overview
03:13
Month on month calculations
06:14
Adding product button slicer
13:02
Profitability Trend
04:08
Adding card visual
17:07
Profit by customer types
10:54

Report 3:Product Analysis Dashboard

10 lectures
Report overview
03:46
Report Layout
08:24
Best selling products
07:04
Most profitable customers
10:53
Orders by product category
03:59
Profitability Trend
05:36
Slicer button design
04:34
Adding check mark icon to slicers
12:04
Adding report page tooltip
16:42
Finalizing report 3
05:23

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.