🔹 Introduction
In this tutorial, you will learn how to create a simple dashboard using Power BI.
We will use the Superstore dataset and the measures created earlier to build meaningful visuals.
This guide is beginner-friendly and easy to follow.
🔹 What You Will Build
In this tutorial, you will build a professional Power BI dashboard that includes:
🔹 Key Metrics (Cards):
- Total Sales
- Total Profit
- Total Quantity Sold
- Total Discount
🔹 Visualizations:
- Sales by Category (Bar Chart)
- Sales by Sub-Category (Bar Chart)
- Sales Trend Over Time (Line Chart)
- Profit by Region (Column Chart)
🔹 Filters (Slicers):
- Region
- Category
- Order Date
This dashboard will help you understand performance, trends, and key business insights and allows users to interact with the data and explore insights by applying filters and analyzing trends.
🔹 Step 1: Prepare Your Data
Open Power BI Desktop and ensure your dataset is loaded.
Make sure you have already created the following measures:
- Total Sales
- Total Profit
- Total Quantity
- Total Discount
🔹 Step 2: Create Cards (Key Metrics)
Cards are used to display important summary values.
- Click on "Card" in the Visualizations panel
- Drag "Total Sales" into the card
Repeat the same steps to create cards for:
- Total Profit
- Total Quantity
- Total Discount
🔹 Step 3: Create Bar Chart (Sales by Category)
- Click on "Clustered Column Chart"
- Drag "Category" into Axis
- Drag "Total Sales" into Values
This shows how each category performs.
🔹 Step 4: Create Bar Chart (Sales by Sub-Category)
- Add another column chart
- Drag "Sub-Category" into Axis
- Drag "Total Sales" into Values
This provides a more detailed breakdown of sales.
🔹 Step 5: Create Line Chart (Sales Trend)
- Click on "Line Chart"
- Drag "Order Date" into Axis
- Drag "Total Sales" into Values
This shows how sales change over time.
🔹 Step 6: Create Chart (Profit by Region)
- Click on "Clustered Column Chart"
- Drag "Region" into Axis
- Drag "Total Profit" into Values
This shows which regions are more profitable.
🔹 Step 7: Add Slicers (Filters)
Slicers allow users to filter the dashboard.
- Click on "Slicer"
- Drag "Region" into the slicer
Repeat for:
- Category
- Order Date
Now users can interact with the dashboard.
🔹 Step 8: Arrange Your Dashboard
Arrange all visuals neatly on the canvas.
- Place cards at the top
- Charts in the middle
- Slicers at the side
Ensure your layout is clean and easy to understand.
🔹 Step 9: Add Titles and Labels
Rename each visual to make it clear:
- Sales by Sub-Category
- Sales by Category
- Sales Trend
- Profit by Region
Clear labelling improves understanding.
🔹 Step 10: Apply Colours and Design
A good dashboard is not just about data—it is also about design.
Use colours carefully:
- Use one main colour (e.g., blue) for consistency
- Use different shades to show differences in values
- Avoid too many colours (this can confuse users)
- Use red carefully to indicate negative values (e.g., loss)
- Use green to indicate positive values (e.g., profit)
Keep your design simple, clean, and easy to read.
Ensure:
- Text is readable
- Charts are not crowded
- Important metrics stand out
🔹 Step 11: Tell a Story with Your Dashboard
A dashboard should not just show data—it should tell a story.
Ask questions like:
- Which category has the highest sales?
- Which region is the most profitable?
- Are sales increasing or decreasing over time?
- Is discount affecting profit?
Your goal is to turn data into insights that people can understand and act on.
Good dashboards answer questions clearly and quickly.
🔹 Step 11: Interpret Your Results
After building your dashboard, take time to interpret your results.
For example:
- If sales are high but profit is low, discounts may be too high
- If one category dominates, the business may depend heavily on it
- If sales trend is declining, action may be needed
Understanding your data is more important than just visualizing it.
🔹 Final Task
Create your own dashboard using:
- Key metrics (cards)
- Charts (category, sub-category, trend, region)
- Slicers (filters)
Then write down your insights.
Made with Bullet