Sales Dashboard with Data Studio

Turn raw spreadsheet data into an interactive sales dashboard.

Introduction

30 Second Summary

Every team has spreadsheets full of sales numbers. But nobody wants to scroll through 40 rows to figure out which region is performing best or whether revenue is trending up.

In this project, you will turn raw sales data in a Google Sheet into a polished, interactive dashboard using Data Studio. You will build scorecards, charts, and filter controls that let anyone explore the data at a glance.

What You'll Build

When you open your finished dashboard, you see total revenue as a headline number, a line chart showing how sales trend month over month, a bar chart comparing regions, and drop-down filters that slice everything instantly when a viewer picks a product category.

By the end of this project, you'll have:

Headline scorecards displaying Total Revenue, Total Units Sold, and Average Order Value that update automatically when new data lands in your spreadsheet.
A time series chart revealing revenue trends over time and a bar chart comparing performance across regions.
Interactive filter controls that let viewers pick a product category or date range and watch every chart on the page respond instantly.
Secret Mission: Add a calculated profit margin field and a pie chart breaking down revenue by product category.

Are there any prerequisites?

All you need is a Google account. Both Google Sheets and Data Studio are free browser-based tools. No downloads, no installs, no credit card required.

Before We Start

Before we dive in, let's lock in what you're about to build and why it matters. This is your moment to commit to the dashboard you'll create and the skills you'll walk away with.

Set Up Your Sales Data in Google Sheets

Every dashboard starts with data. Before Data Studio can build charts and scorecards, it needs a structured dataset with clearly defined columns it can interpret as dimensions and metrics.

In this step, you will create a Google Sheets spreadsheet with sample sales transactions. You will format it so Data Studio can correctly recognize dates, numbers, and text when you connect it later.

In this step, get ready to:

Create a Google Sheet with 30-40 rows of sample sales data.
Format columns with correct data types for Data Studio.
Verify the spreadsheet is structured and ready for a BI connection.

Create your sales data spreadsheet

Data Studio connects to Google Sheets as a data source. The data must be in tabular format with a single header row, and all cells in a column must share the same type.

Press Cmd+Space (macOS) or the Windows key (Windows) to open your search bar.
Type Google Sheets and press Enter to open it in your browser.
On the Google Sheets home page, click the Blank spreadsheet card (the large + icon) to create a new sheet.
Click Untitled spreadsheet in the top left corner and rename it to Sales Data 2024.

You now have an empty spreadsheet named Sales Data 2024. Next, you will add the header row that defines your columns.

Click cell A1 and type Date.
Press Tab to move to the next cell. Type Region.
Continue pressing Tab and entering the remaining headers: Product Category, Sales Rep, Units Sold, Unit Price, Revenue.

Your header row now has 7 columns spanning A1 through G1. Now you will populate the sheet with sample transactions.

Click cell A2 to start entering your first data row.
Enter the following sample rows to establish the pattern. Use Tab to move between cells and Enter to move to the next row:

01/15/2024  North   Electronics   Alex Kim      12   49.99   599.88
01/22/2024  South   Clothing      Maria Lopez    8   29.99   239.92
02/03/2024  East    Home          James Chen    15   19.99   299.85
02/14/2024  West    Food          Sarah Patel    5   89.99   449.95
03/01/2024  North   Clothing      Alex Kim      20   34.99   699.80
03/18/2024  South   Electronics   Maria Lopez    3  149.99   449.97
04/05/2024  East    Food          James Chen    25   12.99   324.75
04/20/2024  West    Home          Sarah Patel   10   59.99   599.90
05/09/2024  North   Electronics   Alex Kim       7   79.99   559.93
05/25/2024  South   Food          Maria Lopez   18   24.99   449.82

What pattern should I follow?

Each row is one sales transaction. Use dates spread across January through June 2024. Rotate through the four regions (North, South, East, West) and four product categories (Electronics, Clothing, Home, Food).

Vary the Sales Rep names, Units Sold (between 1 and 50), and Unit Price (between 9.99 and 199.99). The Revenue column should equal Units Sold multiplied by Unit Price.

Continue adding rows until you have 30-40 total data rows (not counting the header). Mix up the dates, regions, categories, reps, and amounts so your charts will have interesting variation.

Speed up data entry

You can type a formula in the Revenue column instead of calculating manually. In cell G2, type =E2*F2 and press Enter. Then select that cell, grab the small blue square in the bottom right corner, and drag it down to fill Revenue for all your rows.

Check your sheet now. You should see your header row in row 1 and 30-40 rows of transaction data below it.

Format the Date column for Data Studio

Data Studio relies on consistent column types to correctly interpret your data. If the Date column is stored as plain text instead of actual dates, Data Studio cannot use it as a time dimension for trend charts.

Click the column letter A at the top to select the entire Date column.
In the menu bar, click Format.
Hover over Number in the dropdown.
Select Date from the submenu.

Your dates now display in a consistent format. The cells are recognized as date values, not plain text strings.

Why does formatting matter?

When Data Studio connects to your sheet, it reads column types to decide what each field can do. A properly typed Date column becomes a time dimension you can chart by day, week, or month. A text column that happens to contain date strings would just be treated as a category label.

Confirm that your numeric columns (Units Sold, Unit Price, Revenue) contain only numbers. Click a few cells in each column and check that the value in the formula bar does not have quotation marks around it.
Confirm that your text columns (Region, Product Category, Sales Rep) do not have extra spaces or inconsistent capitalization. For example, North should always be North, not north or North with a leading space.

Dates showing as numbers like 45306?

This means the cell is formatted as a number instead of a date. Select the affected cells, go to Format > Number > Date again. If the dates still look wrong, delete the cell contents and retype them in MM/DD/YYYY format.

Help me fix date formatting issues in Google Sheets.

Verify your spreadsheet is dashboard-ready

Before connecting this sheet to Data Studio, confirm that everything meets the requirements for a clean data source.

Scroll through your entire sheet from top to bottom. Check these three things:

Row 1 is your only header row (no merged cells, no blank rows above it).
Every column has a consistent data type. Dates are dates, numbers are numbers, text is text.
You have at least 30 rows of data with dates spanning January through June 2024.

Your sheet should look like a clean table. Seven column headers in row 1. Thirty or more rows of transactions below. Dates formatted consistently. No empty rows or merged cells anywhere.

Why so strict about structure?

Data Studio expects a flat, tabular dataset. Merged cells confuse its column detection. Blank rows create gaps in charts. Mixed types in a single column (like a number and text in the same column) force Data Studio to guess, and it often guesses wrong.

Your raw data is ready. In the next step, you will connect this spreadsheet to Data Studio and see what a BI tool does with it out of the box.

Connect Your Data to Data Studio

Your spreadsheet is loaded with sales data. But right now it is just rows and columns sitting in Google Sheets. No visualization tool can see it until you create a connection.

In this step, you will connect your sheet to Data Studio, Google's free business intelligence tool. You will create a new report, link it to your spreadsheet, and see what Data Studio generates by default.

In this step, get ready to:

Connect your Google Sheet to a new Data Studio report.
Name the report "Sales Performance Dashboard".
Evaluate whether the default output is useful for a decision-maker.

Open Data Studio and connect your spreadsheet

Data Studio uses the same Google account you are already signed into. Navigating to its URL will log you in automatically.

Open a new browser tab and navigate to datastudio.google.com.
On the Data Studio home page, click Create in the top left.
Select Report.

The report editor opens with the Add data to report panel visible. This panel has two tabs: Connect to data and My data sources.

In the Connect to data tab, select the Google Sheets connector.
Find and select your Sales Data 2024 spreadsheet.
Select the worksheet containing your data (it is likely the first and only worksheet).
Leave the default options selected (Use first row as headers should be checked).
Click Add in the bottom right.

A table appears on the canvas with fields from your sales data. The Add data to report panel closes and you are now in the report editor.

What is a data source connector?

A connector is the bridge between your raw data (in this case, a Google Sheet) and Data Studio. Once connected, Data Studio can read your columns and rows and use them to build charts.

The connection is live. If you add new rows to your spreadsheet later, Data Studio will automatically pick them up the next time the report loads.

Don't see your spreadsheet in the list?

Make sure you are signed into the same Google account that owns the Sales Data 2024 sheet. If you have multiple Google accounts, check the account avatar in the top-right corner of the page.

help me find my Google Sheet in the Data Studio connector panel

Name your report

Data Studio gives every new report the default name "Untitled Report". Give yours a meaningful name so you can find it later.

Click Untitled Report in the top left of the editor.
Type Sales Performance Dashboard and press Enter.

Your report now has a proper name. Notice the Properties panel on the right side of the screen. It has two tabs: SETUP and STYLE. You will use these tabs in the next step to configure charts.

Evaluate what Data Studio created

Before you move on, take a moment to look critically at what is on your canvas right now.

If your boss asked for a "sales dashboard" and you sent them this, what would they think?

What you see is a basic data table. It looks almost identical to your spreadsheet. This is technically a "report" but it is not a dashboard. It shows no headline numbers, no trends, and no comparisons. A decision-maker scrolling through rows of data gets zero insights at a glance. You would never send this to someone and call it a dashboard.

Why isn't a table enough?

Tables force the viewer to read every row and do mental math. A dashboard should answer questions instantly: How much revenue this quarter? Which region is winning? Are sales trending up or down?

In the next step, you will replace this table with scorecards and a time series chart that answer those questions at a glance.

Your data is connected and your report has a name. Next up, you will delete that basic table and replace it with scorecards and a time series chart that tell the real story behind your numbers.

Build Scorecards and a Time Series Chart

Your report is connected to your sales data and displaying a basic table on the canvas. That table is no better than scrolling through the spreadsheet itself.

Decision-makers want headline numbers and trends at a glance, not rows of raw data. In this step, you'll replace that table with scorecards and a time series chart that surface the key metrics instantly.

In this step, get ready to:

Delete the default table and create three scorecards for headline metrics.
Add a time series chart showing revenue trends over time.
Preview the dashboard in View mode to see your work in action.

Delete the default table and create your first scorecard

A scorecard displays a summary of a single metric as a headline number. You'll create three of them to show Total Revenue, Total Units Sold, and Average Order Value.

Click the default table on the canvas to select it.
Press Delete on your keyboard to remove it.
In the toolbar, click Add a chart.
Select Scorecard.
Click the canvas to place the scorecard.
In the Properties panel SETUP tab, set the Metric to Revenue.
Confirm the aggregation is set to SUM.

A single large number appears on the canvas showing your total revenue. This is your first scorecard.

Now duplicate this scorecard to create the other two headline metrics.

Right-click the scorecard and select Duplicate (or press Cmd+D on macOS / Ctrl+D on Windows).
Click the duplicated scorecard to select it.
In the SETUP tab, change the Metric to Units Sold with SUM aggregation.
Duplicate the original scorecard again using the same method.
Click the new duplicate to select it.
In the SETUP tab, set the Metric to Revenue and change the aggregation to AVG.
Drag all three scorecards to arrange them in a row across the top of the canvas.

You now have three headline numbers across the top: Total Revenue, Total Units Sold, and Average Order Value.

What are metrics and aggregations?

A metric is a numeric field that Data Studio measures and summarizes. The aggregation controls how it summarizes: SUM adds up all values, while AVG calculates the average.

Your three scorecards use the same underlying data but show different stories. SUM on Revenue gives the grand total, SUM on Units Sold gives volume, and AVG on Revenue gives a per-transaction average (Average Order Value).

Scorecard showing the wrong number?

Make sure you clicked the correct scorecard before editing it in the SETUP tab. The Properties panel always shows settings for whichever element is currently selected.

Check that the aggregation matches what you need. The first and third scorecards both use Revenue as the metric, but the first uses SUM and the third uses AVG.

Help me figure out why my scorecard is showing the wrong value.

Add a time series chart

Scorecards give you the "what" but not the "when." A time series chart plots your data over time so you can spot trends, seasonal patterns, and growth.

In the toolbar, click Add a chart.
Select Time series.
Click the canvas below your scorecards to place the chart.
In the SETUP tab, confirm the Date range dimension is set to Date (Data Studio usually detects this automatically).
Set the Metric to Revenue with SUM aggregation.
Click the STYLE tab in the Properties panel.
Enable Show points to display individual data markers on the line.

A line chart appears on the canvas showing how revenue changes over time. Each dot represents a data point from your spreadsheet.

What is a dimension vs. a metric?

A dimension is a category you group data by (like Date, Region, or Product Category). A metric is a number you measure (like Revenue or Units Sold).

In your time series chart, Date is the dimension (the X-axis) and Revenue is the metric (the Y-axis). Data Studio uses this pairing to plot your trend line.

Seeing a flat line or missing data?

If the Date range dimension shows a field other than Date, click it and select the correct field from the list. Data Studio sometimes picks the wrong date field if multiple columns contain numbers.

If you see only one data point, your Date column in Google Sheets might not be formatted as a Date type. Switch back to your Google Sheet, select the Date column, and apply Format > Number > Date.

Help me troubleshoot my time series chart.

Preview your dashboard in View mode

You've been working in Edit mode, which shows selection handles and the Properties panel. View mode shows what your audience will actually see.

Before you switch, take a guess: what do you think a viewer will see when they open this dashboard?

Click the View button in the top-right toolbar.

You now see three scorecards at the top (Total Revenue, Total Units Sold, Average Order Value) and a time series chart below them showing revenue over time with data point markers. This already tells a story that your raw table never could.

What's missing from this dashboard?

You have headline KPIs and a trend line. But you cannot yet compare which regions are driving performance. There is no way for a viewer to filter the data by product category or date range.

A truly interactive dashboard lets viewers explore the data themselves. You'll add that capability in the next step.

Switch back to Edit mode

To continue editing your report, click the Edit button (pencil icon) in the top-right toolbar. You'll need to be in Edit mode at the start of the next step.

Your dashboard now surfaces key metrics at a glance. Next up, you'll add a regional comparison chart and interactive filters so viewers can explore the data themselves.

Add a Regional Bar Chart and Interactive Filters

Your dashboard now shows headline numbers and a revenue trend over time. That tells you how much the business earned and when peaks happened. But it hides a critical question: which regions are actually driving that performance?

In this step, you will add a bar chart that compares revenue across regions and two interactive filter controls. These controls turn a static report into a self-service exploration tool where viewers slice data themselves without ever touching the underlying spreadsheet.

In this step, get ready to:

Add a bar chart comparing revenue by region.
Add a Product Category drop-down filter and a Date range control.
Test full interactivity in View mode.

Add a bar chart comparing regions

A bar chart is the simplest way to answer "who is winning?" across categories. Each bar represents one region, making differences in performance obvious at a glance.

Switch back to Edit mode by clicking the pencil icon (or clicking Edit) in the top-right toolbar.
In the toolbar, click Add a chart.
Select Bar chart (the column chart variant).
Click the canvas next to your time series chart to place the bar chart.

A default bar chart appears on the canvas. Now configure it to show regional revenue.

In the Properties panel on the right, click the SETUP tab.
Set the Dimension to Region.
Set the Metric to Revenue with SUM aggregation.

You now see bars for North, South, East, and West, each showing that region's total revenue.

Click the STYLE tab in the Properties panel.
Enable Show data labels to display the revenue value on each bar.

What are dimensions vs. metrics?

A dimension is the category you group by (Region, Product Category, Date). A metric is the number being measured (Revenue, Units Sold).

In your bar chart, Region is the dimension (one bar per region) and Revenue SUM is the metric (how tall each bar is).

Your bar chart now shows labelled revenue amounts on each bar. You can instantly see which region leads.

Bars all look the same height?

If your sample data has similar revenue values across regions, the bars will appear close in height. That is expected. The chart still works correctly. You can verify by checking that the data labels show different numbers.

If you see only one bar, make sure the Dimension is set to Region (not Date or another field).

Why isn't my bar chart showing separate bars per region?

Add interactive filter controls

Charts alone show a fixed picture. Filter controls let viewers ask their own questions by slicing the data however they want, without editing the report or the spreadsheet.

In the toolbar, click Add a control.
Select Drop-down list.
Click the canvas above your charts to place the drop-down control.
In the SETUP tab of the Properties panel, set the Control field to Product Category.

A drop-down filter now appears on your canvas. When a viewer selects a category from this drop-down, every chart on the page updates to show only data for that category.

How do filter controls work?

When you set the Control field to a dimension (like Product Category), Data Studio automatically filters all charts on the report page by the selected value. You do not need to wire up each chart individually.

Now add a second control so viewers can also filter by date.

In the toolbar, click Add a control again.
Select Date range control.
Click the canvas next to your drop-down to place the date range control.

You now have two filter controls above your charts: a Product Category drop-down and a Date range picker.

Don't see the control on the canvas?

Controls can be small and easy to miss. Look for a small rectangle near where you clicked. You can drag it to reposition and resize it to make it more visible.

If you do not see the Add a control option in the toolbar, make sure you are in Edit mode (not View mode).

Why can't I see the filter control I just added to my Data Studio report?

Test your interactive dashboard

The real test of a dashboard is whether a viewer can ask a question and get an answer without editing anything. Time to switch to View mode and try it.

Click View in the top-right toolbar to switch to View mode.

Before you interact with the filters, take a look at the dashboard and predict what will happen. If you select "Electronics" from the Product Category drop-down, which charts do you think will change?

Click the Product Category drop-down and select Electronics.

All three scorecards and both charts update instantly to show only Electronics data. The Total Revenue scorecard drops to reflect just Electronics transactions. The bar chart shows only Electronics revenue per region. The time series shows only the Electronics trend line.

Now click the Date range control and set it to a single month (for example, January 2024 to January 2024).

The time series and bar chart narrow to show only that month's data. The scorecards recalculate to reflect only transactions within your chosen window.

Why is this better than a spreadsheet?

In a spreadsheet, answering "How did Electronics perform in the North region in March?" requires manually sorting, filtering columns, and reading raw numbers. Here, a viewer clicks two controls and the answer appears visually in under a second.

This is the power of an interactive BI dashboard. Viewers explore data themselves without needing to understand formulas or touch the source.

Reset the Product Category drop-down back to showing all categories (clear the selection).
Reset the Date range control to the full date range.

Filters not updating the charts?

Make sure you are in View mode (not Edit mode). Filters only work interactively in View mode.

If the drop-down shows no options, switch back to Edit mode and confirm the Control field is set to Product Category in the SETUP tab.

My Data Studio filter controls are not updating the charts. How do I fix this?

Your dashboard is now fully interactive. You have headline scorecards, a trend chart, a regional comparison, and self-service filters. Next up, you will take on the Secret Mission and push this dashboard even further with a calculated field and a new chart type.

Secret mission

Add a Calculated Field and Pie Chart

Your dashboard shows revenue, but what about profitability? Real dashboards go beyond raw columns. In this mission, you'll create a calculated field that derives profit margin from existing data and add a pie chart showing how revenue splits across product categories.

Clean Up Your Resources

Decide whether to keep your resources running, pause them to come back later, or delete them entirely. This project runs entirely on free Google tools, so there are no ongoing costs regardless of your choice.

Resources you used:

A Google Sheet ("Sales Data 2024") in your Google Drive: free, no ongoing cost.
A Data Studio report ("Sales Performance Dashboard"): free, no ongoing cost.

Keep everything running

No action needed. Choose this if you want your dashboard to stay live and keep updating as you add data.

Your dashboard will automatically reflect any new rows you add to the Google Sheet.
Share your dashboard with others by clicking the Share button in the top-right corner of the report editor.
Both resources persist in your Google account indefinitely at no cost.

Pause - I'll come back to this later

No action needed. Both resources are free and persist indefinitely in your Google account.

Your Google Sheet remains in Google Drive exactly as you left it.
Your Data Studio report remains at datastudio.google.com and can be reopened anytime.
Nothing is running in the background. There are no processes to stop or resources consuming credits.

Delete - I don't want to use this again

Remove all project resources to start fresh.

To remove the Data Studio report, go to datastudio.google.com. Right-click the "Sales Performance Dashboard" report and select Remove.
To remove the Google Sheet, open Google Drive. Right-click the "Sales Data 2024" spreadsheet and select Move to trash.
Empty your Google Drive trash if you want to permanently delete both files.

Nice Work!

You just built a live, interactive sales dashboard using Data Studio and Google Sheets. You took raw spreadsheet data and turned it into an executive-ready report that updates automatically and lets viewers explore the numbers themselves.

You've learned how to:

Connect a Google Sheets data source to Data Studio and build a live dashboard with scorecards, a time series chart, and a bar chart that updates automatically when new data is added.
Transform raw transaction rows into visual insights by configuring dimensions and metrics in the Properties panel.
Add interactive filter controls (a Product Category drop-down and a Date range control) so viewers can slice the dashboard without touching the underlying data.
Secret Mission: Create a calculated field for Profit Margin using the formula editor and add a pie chart showing revenue distribution by product category.

Ready to quiz yourself?