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.

What you'll learn

Data Analysts

Power BI enthusiasts

Business Analysts

Accountants

Financial Analysts

Students

Requirements

Prior knowledge of Microsoft Power BI is required

At least November 2023 version of Power BI Desktop

Description

Course OverviewWelcome 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 BackgroundYou 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.TaskImport the two tables into Power BI.Profile and transform the data to ensure the data is clean and accurateAnalyze 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 ObjectivesBy the end of this course, you will be able to:Import, clean, and transform data in Power BIAnalyze data using DAX to calculate key metricsCreate compelling visualizations using Power BI's visualization toolsDesign and implement interactive Power BI dashboards

Overview

Section 1: Data transformation and modeling

Lecture 1 Dataset and icons

Lecture 2 Overview of the dataset

Lecture 3 Import and profile datasets

Lecture 4 Data modeling

Lecture 5 Key performance indicators: Total Orders

Lecture 6 Other KPIs

Lecture 7 Time Intelligence calculations

Lecture 8 Year on Year Analysis

Section 2: Report page Design

Lecture 9 Customize the color palette

Lecture 10 Report page background

Lecture 11 Adding Company profile

Section 3: Data visualization and reporting

Lecture 12 Visualize Key performance indicators 1

Lecture 13 Visualize Key performance indicators 2

Lecture 14 Modern bar chart - Orders by Country

Lecture 15 Orders by year and quarter

Lecture 16 Top 3 customers and discount band

Lecture 17 Designing button slicer

Lecture 18 Adding product image and description

Section 4: Report 2: Profitability Analysis

Lecture 19 Project 2 overview

Lecture 20 Month on month calculations

Lecture 21 Adding product button slicer

Lecture 22 Profitability Trend

Lecture 23 Adding card visual

Lecture 24 Profit by customer types

Section 5: Report 3:Product Analysis Dashboard

Lecture 25 Report overview

Lecture 26 Report Layout

Lecture 27 Best selling products

Lecture 28 Most profitable customers

Lecture 29 Orders by product category

Lecture 30 Profitability Trend

Lecture 31 Slicer button design

Lecture 32 Adding check mark icon to slicers

Lecture 33 Adding report page tooltip

Lecture 34 Finalizing report 3

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.