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.

Homepage

https://www.udemy.com/course/modernpowerbidash/