
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.
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 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.
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.
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.
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.
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.
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.
Design and customize the report color palette in Power BI using hex codes, then apply a cohesive theme to visualizations and the sample dashboard.
Customize the report page background by adjusting the canvas color and transparency, and build header and card-shaped backdrops using rounded shapes with shadows and accent bars.
Insert a card in Power BI, add the company logo and name, and customize with image and text boxes to create a cohesive company profile card.
Visualize key performance indicators by building a multi-element KPI visualization in Power BI, including total orders, total revenue, and profit margin, with customized formatting and callouts.
Visualize total profit and profit year on year with a card visualization, format the callout in thousands, set year on year decimals, and customize labels, colors, and the accent bar.
Create a clustered bar chart of total orders by country in Power BI. Display country labels on top and data labels inside bars, with axis and legend formatting.
Build a total orders by year and quarter visualization in Power BI using a date table, format the axes, and apply conditional formatting with colors to distinguish 2021 from 2022.
Analyze top three customers by revenue and revenue by discount band using Power BI, duplicating visuals, adding a revenue two measure, filtering for top customers, and formatting labels and titles.
Design and format a button slicer in Power BI to filter by product and reveal sales, profit margin, year on year change, country orders, top customer types, and discount-band revenue.
Create two Power BI cards showing the selected product's name, description, and image via a slicer. Format callouts and labels and set the image URL for dynamic product visuals.
Preview the sample Power BI profitability report and analyze metrics across 12 months, including profit, margins, year on year and month on month changes by product, customer type, and category.
Design a modern ux dashboard in Power BI by creating measures for year-over-year and month-over-month profit changes, including both amount and percentage insights.
Duplicate the report page to create a profitability analysis view. Add and configure a product button slicer in Power BI, format callouts, images, and hover states to enhance data slicing.
Explore profitability by month across two years in Power BI, duplicating a visualization, using year and month name, and shortening month names while setting total profit on the y axis.
Learn to create a Power BI card visual that displays year-on-year and month-on-month profit changes, and customize formatting, labels, colors, and reference data for clear profit analysis.
Explore profitability by customer type and product in Power BI, analyzing profit, profit margin, and year on year profit with a matrix and a donut chart showing distribution by category.
explore the final Power BI dashboard for product performance, highlighting best-selling products, profitability by product, and orders by category with year slicers and tooltips.
Duplicate and rename the report to product analysis, then transform the dashboard layout with a white header, rounded shapes, a four-column horizontal slicer, and visuals for best-selling and profitability analysis.
Explore best selling products by total orders in Power BI using a bar chart, with data labels, thousands display units, and an average reference line to rank products.
Visualize the top four most profitable customer types by total profit in Power BI, using a bar chart and a dynamic subtitle that reflects the selected product.
Create a donut chart showing total orders by product category in Power BI, format legend top left, adjust slice colors and inner radius to 75%, and add a separator line.
Create a monthly profitability trend using a combo chart (line for previous year, columns for total profit), then format the title, subtitle, colors, and axes to highlight the product subtitle.
Design a Power BI button slicer to filter the report, then format its layout, background, borders, and states from default gray to white when selected.
Google link prefix: https://drive.google.com/uc?export=view&id=
Design a Power BI report page tooltip with a custom size and visuals, then assign it to a slicer to show product details on hover.
Edit slicer interactions and visual filters in Power BI to present product insights, profitability trends, and year-over-year comparisons with tooltips showing revenue, orders, and profit.
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
Import the two tables into Power BI.
Profile and transform the data to ensure the data is clean and accurate
Analyze 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 Objectives
By the end of this course, you will be able to:
Import, clean, and transform data in Power BI
Analyze data using DAX to calculate key metrics
Create compelling visualizations using Power BI's visualization tools
Design and implement interactive Power BI dashboards