How to Create Your First Sales Dashboard

A sales dashboard turns transaction data into a visual report that helps a business understand revenue, products, customers and sales trends.

You do not need to begin with a complex system. A clear first dashboard can use a structured spreadsheet, a few useful calculations and simple charts. You can build it in Excel or Power BI, depending on your current level and learning goal.

This guide explains how to create your first sales dashboard using a realistic business example, including data preparation, key performance indicators, chart selection, layout and interpretation.

What Is a Sales Dashboard?

A sales dashboard is a visual summary of sales performance.

It may show:

• Total revenue.
• Number of orders.
• Units sold.
• Average order value.
• Top-performing products.
• Sales by location.
• Sales by salesperson.
• Monthly or weekly trends.
• Target versus actual performance.

A dashboard is not simply a collection of charts. It should help someone answer a business question quickly.

For example:

Which products generate the most revenue, and how has sales performance changed over the past six months?

Your dashboard should make that answer easier to find.

Define the Business Question

Before opening Excel or Power BI, define what the dashboard needs to explain.

Possible questions include:

• How much revenue did the business generate?
• Which products sell most often?
• Which products generate the highest revenue?
• Which months performed best?
• Which location contributes the most sales?
• Are sales increasing or declining?
• What is the average order value?
• Which products may require attention?

A beginner mistake is building visuals first and deciding what they mean later. Start with the decision the dashboard should support.

Example business brief

A small retail business in Port Harcourt wants to understand monthly sales performance, identify its best-selling products and compare revenue across locations.

This brief gives you a clear direction.

Prepare the Sales Data

A dashboard is only as reliable as the data behind it.

Your data should be organised in a consistent table with:

• One header row.
• One record per row.
• One field per column.
• No merged cells inside the data.
• No blank rows separating records.
• Consistent date formats.
• Consistent spelling.
• Numbers stored as numbers.
• Clear field names.

Microsoft recommends structuring the data properly before creating a dashboard and using PivotTables, charts, slicers and timelines to analyse it in Excel.support.microsoft

Example sales-data columns

Order ID	Order Date	Product	Category	Location	Salesperson	Units	Unit Price
ORD001	2026-01-04	Laptop Stand	Accessories	D-Line	Ada	2	25000
ORD002	2026-01-06	Wireless Mouse	Accessories	GRA	Chidi	5	12000
ORD003	2026-01-10	Keyboard	Accessories	Rumuola	Ada	3	18000
ORD004	2026-01-13	Monitor	Electronics	D-Line	Emeka	1	95000

Add a calculated Revenue column:

$$\text{Revenue}=\text{Units}\times \text{Unit Price}$$Revenue=Units×Unit Price

If your dataset contains discounts, returns or taxes, define how they will be handled before building the dashboard.

Clean the Data

Check for:

• Missing order IDs.
• Duplicate transactions.
• Blank product names.
• Incorrect dates.
• Negative or impossible quantities.
• Inconsistent location names.
• Different spellings for the same product.
• Currency symbols stored inside numeric fields.
• Extra spaces.
• Incorrect totals.

Example inconsistencies

These may represent the same location:

• Port Harcourt.
• port harcourt.
• PH.
• Port-Harcourt.

Standardise them before analysis.

These may represent the same product:

• Wireless Mouse.
• wireless mouse.
• Wireless mouse .

Clean spelling, spacing and capitalisation so your summaries do not split one item into several categories.

Create the Core Calculations

Your first dashboard does not need dozens of metrics. Start with a small set that answers the business question.

Total revenue

$$\text{Total Revenue}=\sum \text{Revenue}$$Total Revenue=∑Revenue

Total units sold

$$\text{Total Units}=\sum \text{Units}$$Total Units=∑Units

Number of orders

Count unique Order IDs rather than counting rows if one order can contain multiple products.

Average order value

$$\text{Average Order Value}=\frac{\text{Total Revenue}}{\text{Number of Orders}}$$Average Order Value=Number of OrdersTotal Revenue​

Revenue by product

Group revenue by product to identify which products contribute most.

Revenue by period

Group revenue by week, month or quarter to identify trends.

Revenue by location

Group revenue by location to compare business performance across branches or areas.

Choose Your Tool

Excel

Excel is a practical starting point for beginners because it can handle:

• Structured tables.
• Formulas.
• PivotTables.
• PivotCharts.
• Slicers.
• Timelines.
• Basic dashboards.

Microsoft’s documented workflow includes creating a PivotTable, adding PivotCharts and using slicers or timelines to filter the report.support.microsoft

Power BI

Power BI may be suitable when you need:

• Multiple related tables.
• Reusable data models.
• Interactive reports.
• More advanced filtering.
• Data from different sources.
• A dashboard that can be refreshed regularly.

Power BI commonly involves connecting to data, cleaning it with Power Query, creating relationships, defining calculations and designing visuals. Skillworks’ beginner Power BI guidance also emphasises cleaning and shaping data before building complex visuals.skillworks

If you are completely new, create your first dashboard in Excel before moving to Power BI. The underlying analytical thinking is more important than the software.

Build the Dashboard in Excel

Step 1: Convert the data into a table

Select your dataset and use Insert > Table.

Give the table a meaningful name, such as:

SalesData

This helps formulas, PivotTables and future updates remain organised.

Step 2: Add a Revenue column

Create a calculated column using:

text=Units*Unit Price

The exact formula depends on your column names and spreadsheet structure.

Check a few rows manually to confirm the calculation.

Step 3: Create a PivotTable

Select a cell in the sales table and choose:

Insert > PivotTable

Create summaries such as:

• Revenue by month.
• Revenue by product.
• Revenue by location.
• Units by category.
• Orders by salesperson.

Microsoft documents PivotTables as a way to summarise totals, averages and counts before adding charts.support.microsoft

Step 4: Create PivotCharts

Select the relevant PivotTable and choose:

Insert > PivotChart

Useful chart choices include:

• Line chart for monthly revenue trends.
• Bar chart for revenue by product.
• Column chart for revenue by location.
• Stacked column chart for category comparisons.
• Donut chart only when showing a small number of simple proportions.

Microsoft recommends PivotCharts for visualising PivotTable data and allowing the report to be reconfigured by moving fields.support.microsoft

Step 5: Add filters

Add slicers for fields such as:

• Product.
• Category.
• Location.
• Salesperson.

Add a timeline for Order Date if your data contains consistent dates.

Connect the slicers to the relevant PivotTables so the charts respond together. Microsoft’s dashboard guidance describes using slicers and timelines to filter dashboard results.support.microsoft

Step 6: Arrange the dashboard

Place the most important information at the top.

A simple layout may be:

• Top row: Total Revenue, Orders, Units Sold and Average Order Value.
• Middle row: Monthly Revenue Trend and Revenue by Product.
• Bottom row: Revenue by Location and filters.

Keep enough spacing between elements. Avoid filling every available area with charts.

Build the Dashboard in Power BI

The exact menu names may vary by Power BI version, but the general process is similar.

Step 1: Import the data

Load the Excel or CSV file into Power BI.

Check:

• Column data types.
• Date fields.
• Numeric fields.
• Text fields.
• Missing values.
• Duplicate records.

Step 2: Clean the data

Use Power Query to:

• Remove blank rows.
• Correct data types.
• Standardise text.
• Split columns where necessary.
• Remove duplicates.
• Create calculated columns.
• Handle missing values.

Do not build visuals on unverified data.

Step 3: Create a date table

For time-based analysis, a proper date table can make monthly, quarterly and yearly analysis more consistent.

Include fields such as:

• Date.
• Year.
• Month number.
• Month name.
• Quarter.

Sort month names by month number so charts display January through December rather than alphabetically.

Step 4: Create measures

Measures allow you to calculate key metrics dynamically.

Examples:

textTotal Revenue = SUM(Sales[Revenue])

textTotal Units = SUM(Sales[Units])

textAverage Order Value = DIVIDE([Total Revenue], DISTINCTCOUNT(Sales[Order ID]))

Use the correct table and column names for your dataset.

Step 5: Add visuals

Start with:

• Card for Total Revenue.
• Card for Number of Orders.
• Card for Units Sold.
• Card for Average Order Value.
• Line chart for revenue over time.
• Bar chart for revenue by product.
• Column chart for revenue by location.
• Slicers for time period, category and location.

Step 6: Check interactions

Select a product or location and verify whether the other visuals respond correctly.

If a filter produces an impossible result, inspect:

• Relationships.
• Data types.
• Duplicate keys.
• Date fields.
• Measure definitions.
• Visual interactions.

Choose Effective Visuals

Use the chart that matches the question.

Question	Suitable visual
How is revenue changing over time?	Line chart
Which products generate the most revenue?	Horizontal bar chart
Which location performs best?	Column chart
What percentage comes from each category?	Donut chart with few categories
How does actual compare with target?	Column or bullet-style visual
Which day or month is strongest?	Column chart or heatmap
What are the key totals?	KPI cards

Avoid choosing a chart only because it looks attractive.

Recommended First Dashboard KPIs

Use four or five KPIs at most.

Total revenue

Shows the overall value of recorded sales.

Total orders

Shows transaction volume.

Units sold

Shows product volume.

Average order value

Shows the average amount generated per order.

Revenue growth

Shows whether revenue is increasing or declining compared with a previous period.

Do not add profit unless you have reliable cost data. Revenue is not the same as profit.

Design the Dashboard Clearly

A good dashboard should be readable within a few seconds.

Use:

• A clear title.
• Consistent colours.
• Descriptive chart titles.
• Logical ordering.
• Adequate white space.
• Meaningful labels.
• Limited decoration.
• Accessible contrast.
• Consistent number formats.

Example title

Monthly Sales Performance Dashboard: January–June 2026

This is clearer than:

Sales Dashboard

Use consistent number formats

Choose one format for currency:

• ₦1,250,000.
• ₦1.25m.

Do not switch between formats without a reason.

Show percentages consistently:

• 25%.
• 25.0%.

Avoid overcrowding the dashboard with excessive decimals.

Interpret the Results

A dashboard is useful only when it leads to a better understanding or decision.

Do not stop at:

Revenue was ₦X.

Add interpretation:

• Revenue increased steadily from February to May.
• Accessories generated more orders than electronics.
• The D-Line location produced the highest revenue.
• One product sold frequently but generated less revenue because of its lower price.
• Sales declined in June and may require further investigation.

Separate observation from recommendation.

Example

Observation: Revenue declined by 18% in June compared with May.

Possible explanation: The dataset shows fewer orders, but it does not explain why.

Recommendation: Review stock availability, marketing activity, pricing and customer demand before taking action.

Do not claim that a dashboard proves causation when it only shows a pattern.

Test the Dashboard

Before sharing it, check:

• Do the totals match the source data?
• Are there duplicate orders?
• Do filters work?
• Are dates grouped correctly?
• Are currency values formatted correctly?
• Are product names consistent?
• Does the dashboard remain readable at normal screen size?
• Are charts labelled clearly?
• Can another person understand it without a long explanation?
• Are confidential fields removed?

Compare dashboard totals with manual calculations or a simple summary table.

A visually attractive dashboard with incorrect totals is worse than a plain but accurate report.

Common Beginner Mistakes

Starting with charts

Define the question and clean the data first.

Using too many visuals

A dashboard is not a poster. Include only visuals that support a decision.

Mixing revenue and profit

You need cost information to calculate profit.

Counting rows as orders

If an order contains multiple product lines, row count may overstate order volume. Use unique Order IDs.

Ignoring returns

Returned products may distort revenue and units sold. Define how returns are handled.

Using pie charts for many categories

A crowded pie chart is difficult to interpret. Use a sorted bar chart instead.

Using inconsistent dates

Dates stored as text may not group correctly by month or quarter.

Building on unclean data

Duplicate records, inconsistent spelling and missing values can produce misleading results.

Adding unnecessary 3D effects

Three-dimensional charts often make comparisons harder. Use simple two-dimensional visuals.

Reporting observations as causes

A sales decline is an observation. The reason requires additional evidence.

Build a Portfolio Case Study

Your first sales dashboard can become a portfolio project.

Document:

• Project title.
• Business problem.
• Dataset description.
• Data-cleaning steps.
• KPIs selected.
• Dashboard screenshots.
• Main findings.
• Recommendations.
• Limitations.
• Tools used.
• What you learned.

Example portfolio description

Created a sales-performance dashboard for a simulated Port Harcourt retail business using Excel and Power BI. Cleaned transaction data, calculated revenue and order metrics, analysed monthly trends and compared product and location performance. The dashboard was designed to help a business owner identify high-performing products and investigate changes in sales.

Label the project as simulated if it was not commissioned by a real business.

Do not publish private customer information or confidential business records.

A Simple Practice Dataset

To practise, create a spreadsheet with at least:

• 50–100 transactions.
• Six months of dates.
• Five or more products.
• Two or more categories.
• Three or more locations.
• Several salespeople.
• Varying quantities and prices.

For a local practice scenario, use fictional locations or business branches rather than claiming that the data belongs to a real Port Harcourt business.

Include a few realistic issues to clean:

• Inconsistent capitalisation.
• Blank salesperson entries.
• Duplicate rows.
• Different date formats.
• Extra spaces in product names.

Then document how you corrected them.

A Seven-Day Dashboard Plan

Day 1: Define the question

Write the business brief and select the decisions the dashboard should support.

Day 2: Prepare the dataset

Organise columns, standardise formats and identify missing information.

Day 3: Clean the data

Remove duplicates, correct errors and verify data types.

Day 4: Calculate KPIs

Create revenue, order, unit and average-order-value calculations.

Day 5: Build the visuals

Create PivotTables, PivotCharts or Power BI visuals.

Day 6: Arrange and test

Improve the layout, add filters and verify all totals.

Day 7: Write the findings

Document observations, recommendations, limitations and lessons learned.

How Skillworks Can Help You Learn Dashboard Building

Skillworks’ Data Analytics training in Port Harcourt covers tools including Excel, SQL and Power BI, with project-based learning and dashboard work described as part of the programme.skillworks

The Data Analytics course can provide a structured environment for learning data cleaning, analysis, visualisation and reporting. Before enrolling, confirm the current curriculum, project requirements, class schedule, software access and portfolio support.

Explore Data Analytics training in Port Harcourt.

Frequently Asked Questions

Can I create a sales dashboard with Excel?

Yes. Excel supports structured tables, formulas, PivotTables, PivotCharts, slicers and timelines for building sales dashboards.support.microsoft

Should I use Excel or Power BI first?

Excel may be a simpler starting point for a first dashboard. Power BI becomes useful as your data model, sources and reporting requirements become more complex.

What data do I need for a sales dashboard?

At minimum, you need transaction dates, products, quantities and prices. Additional fields such as location, category, salesperson, discounts and costs allow deeper analysis.

What is the most important sales KPI?

There is no single best KPI. Total revenue, orders, units sold, average order value and revenue growth answer different questions.

Can I create a dashboard without real business data?

Yes. Use a simulated or public dataset and clearly label the project. Do not present fictional findings as real business results.

How many charts should a dashboard have?

Use as few as necessary to answer the defined questions. A beginner dashboard may work well with three or four charts plus KPI cards and filters.

Is revenue the same as profit?

No. Revenue is the amount generated from sales. Profit requires reliable cost information and may also account for expenses, discounts, returns and taxes.

Can a sales dashboard prove why sales increased?

Not by itself. It can show patterns and relationships in the recorded data, but explaining causes usually requires additional information.

Can I add my dashboard to my portfolio?

Yes. Explain the business problem, your process, tools, findings and limitations. Remove confidential information and label simulated work honestly.

Start with a Business Question

Your first sales dashboard does not need to be complex. Start with clean data, a clear question and a small set of useful metrics.

Organise the sales table, calculate revenue, summarise performance, choose suitable charts, add filters and test the results. Then explain what the dashboard shows and what a business could investigate next.

The goal is not to decorate a spreadsheet. The goal is to help someone understand sales performance and make a better decision.

Build practical Data Analytics skills with Skillworks in Port Harcourt.