Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Design modern UX Dashboard with Microsoft Power BI
Highest Rated
Rating: 4.7 out of 5(87 ratings)
1,489 students

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.
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

    Import and clean datasets in Power BI, profile data, calculate key metrics with DAX time intelligence, and create interactive visuals and dashboards to drive data-driven decisions for First Man Studio.

  • 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

    Import and profile datasets in Power BI by loading an Excel workbook, inspecting product and source tables, transforming with Power Query, and validating data types and quality before modeling.

  • 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

    Build a dedicated measures table in Power BI, create your first measure to sum the unit sold from the source table, and organize the data model for total orders.

  • 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

    Learn to calculate year-on-year growth for orders, revenue, cost, and profit in Power BI using DAX measures and the divide function to express percentage changes.

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

  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

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.