How to Build a Simple Business Dashboard
A good dashboard answers the question "How are we doing?" in under a minute. You do not need a data team or an expensive tool to build one. Here is how to choose the right metrics, pick between Looker Studio, Google Sheets and Power BI, and design a single page your team will actually open.
Key takeaways
- Start with the decisions you make each week, then pick the few metrics that inform them.
- Google Sheets is the fastest start, Looker Studio is a strong free option for web and marketing data, and Power BI suits businesses already on Microsoft tools.
- Automate the data feed first. A dashboard that needs manual copy and paste will be abandoned within weeks.
- One page, a clear date range and a comparison to a previous period make a dashboard readable at a glance.
Most small business owners already have the data they need. It sits in the accounting software, the online store, the point of sale system, the email platform and Google Analytics. The problem is that it lives in five different places, each with its own login and its own definition of "this month." A dashboard pulls the important numbers into one view so you can spot problems early and stop arguing about which figure is right.
This guide is about building the dashboard itself. If you are still deciding which numbers matter most, our separate articles on financial KPIs and marketing metrics cover that in depth. Here we focus on the practical steps: planning, choosing a tool, connecting data, designing the page and keeping it alive.
Step zero: decide what the dashboard is for
Most failed dashboards fail before anyone opens a tool. They try to show everything, so they show nothing clearly. Before you build, answer three questions on paper:
- Who will use it? The owner, a sales lead, the whole team or an investor all need different views.
- How often will they look? A daily operations dashboard and a monthly business review dashboard look very different.
- What decision will it change? If a number going up or down would not change anything you do, it does not belong on the dashboard.
If you have more than that, consider splitting the dashboard by audience: one page for sales, one for operations, one for finance.
Choose your tool: Sheets, Looker Studio or Power BI
All three tools can produce a useful dashboard for a small business. The right choice depends on where your data lives and which software your team already uses. Features and pricing change, so check each vendor's website for current plans before committing.
| Tool | Best for | Strengths | Watch out for |
|---|---|---|---|
| Google Sheets (or Excel) | Very small teams and first dashboards | Familiar, flexible, quick to start, easy to share | Gets slow with large data and relies on manual imports unless you add connectors |
| Looker Studio | Marketing, website and Google-based data | A no-cost version is available, plus native connectors to Google Analytics, Google Ads, Search Console and Sheets | Third-party connectors for other platforms are often paid, and complex data blending has limits |
| Power BI | Businesses on Microsoft 365 or with Excel-heavy finance data | Powerful data modeling, many connectors, strong Excel integration | Steeper learning curve, and sharing reports with colleagues generally requires paid licenses |
Pro tip
If you are unsure, start in a spreadsheet. Build the summary table you wish you had, use it for a month, and only then move it into Looker Studio or Power BI. You will know exactly which metrics earned their place before you invest time in a more advanced tool.
How to build your dashboard step by step
- List your metrics and their sources. Write each metric, its exact definition and the system it comes from. For example: "Revenue, total invoiced excluding tax, from accounting software."
- Get the data flowing automatically. Use native connectors where they exist. Many accounting, ecommerce and email tools can export to Google Sheets on a schedule or connect directly to Looker Studio or Power BI.
- Create one clean data table per source. Keep raw data in its own tab or dataset, with one row per record and consistent date formats. The dashboard reads from these tables, never from hand-typed numbers.
- Build the summary layer. Calculate the headline numbers, such as monthly revenue or new customers, in a summary table or as calculated fields in your tool.
- Lay out the page. Put headline numbers across the top, trends in the middle and detail tables at the bottom.
- Add date controls and comparisons. Include a date range selector and show each headline number against the previous period or the same period last year.
- Test with the real audience. Ask the people who will use it what they think each number means. If their answer differs from your definition, fix the label.
- Schedule a review. Put a recurring meeting or reminder on the calendar to look at it, otherwise it will drift into irrelevance.
Building in Google Sheets
Create a data tab for each source, a summary tab using SUMIFS, COUNTIFS or pivot tables, and a dashboard tab with large number cells and a few charts. Sparklines, the SPARKLINE function in Google Sheets or the Sparklines feature in Excel, add tiny trend lines next to each number without cluttering the page. Our separate list of spreadsheet tips covers the formulas that make this easy.
Building in Looker Studio
Create a new report, add data sources such as Google Analytics or a Google Sheet, then drag scorecards, time series charts and tables onto the canvas. Scorecards can show a comparison to a previous period automatically. Add a date range control so viewers can change the period themselves. Many owners connect Looker Studio to a Google Sheet that collects data from other tools, which keeps things simple.
Building in Power BI
Power BI Desktop lets you import data from Excel, SharePoint lists, databases and many online services. You shape the data in Power Query, define relationships between tables and then build visuals on report pages. Microsoft's documentation and free learning paths are the best place to start, because the tool is powerful but has more concepts to learn than a spreadsheet.
Design rules that make a dashboard readable
A dashboard is a communication tool. A few design habits make a big difference:
- Lead with the most important number. People read from the top left. Put your most important metric there.
- Always show context. "Revenue: 42,000" means little. "Revenue: 42,000, up 8% on last month" tells a story.
- Use the right chart. Lines for trends over time, bars for comparing categories, a simple table for exact values. Avoid pie charts with many slices and 3D effects.
- Use color with purpose. Keep most of the page neutral and use one highlight color, or red and green sparingly, for things that need attention. Remember that some readers cannot easily tell red from green, so add arrows or labels too.
- Label definitions. Add a short note under any metric that could be misunderstood, such as whether revenue includes tax or refunds.
- Show when the data was last updated. A stale dashboard that looks current is worse than no dashboard.
Common mistake
Mixing definitions from different systems without saying so. Your online store, payment processor and accounting software may each report a slightly different "revenue" for the same month because of refunds, fees and timing. Pick one source of truth for each metric and stick to it.
Hypothetical example
Suppose a two-location coffee shop owner wants one weekly view. She connects point of sale exports to a Google Sheet, then builds a Looker Studio page with five scorecards: sales, transactions, average ticket, labor cost as a share of sales and top-selling item. Each scorecard compares to the same week last year. Within a month she notices that average ticket is falling at one location on weekday mornings, which leads to a simple fix: a breakfast pairing offer at the counter.
Keep your dashboard alive
Dashboards decay. A connector breaks, a new product line is not included, or the person who built it leaves. Assign an owner, document where each number comes from on a notes page and review the metrics every quarter. Remove anything nobody has looked at, and add new metrics only when they support a current decision.
Also think about access. Share dashboards with view-only permissions by default, and be careful when a dashboard includes customer names, salaries or other sensitive data. Tools such as Looker Studio and Power BI let you share reports without giving edit access to the underlying data source, so check those settings before you send a link.
Signs your dashboard works
- People open it without being reminded
- Meetings start with it instead of with arguments about numbers
- It updates without anyone copying and pasting
Signs it needs a rebuild
- Nobody can explain what half the charts mean
- The numbers are often out of date
- Decisions are still made from separate exports
Your dashboard action plan
- Write down the audience, the review frequency and three decisions the dashboard should support
- Pick five to nine metrics and define each one in a single sentence
- List the source system for each metric and check whether a connector exists
- Build a first version in Google Sheets or Excel and use it for four weeks
- Move it to Looker Studio or Power BI only if you need more automation or interactivity
- Add a date control, period comparisons and a "last updated" note
- Assign an owner and book a quarterly metric review
Frequently asked questions
Is Looker Studio really free?
Google offers a no-cost version of Looker Studio, alongside a paid Looker Studio Pro edition that adds team and administration features. Check Google's site for current terms. Some third-party connectors that pull data from non-Google platforms charge their own fees, so check current details before you rely on them.
Do I need to know SQL or coding?
No. All three tools covered here can produce a useful dashboard without code. Formulas in Sheets, calculated fields in Looker Studio and basic Power Query steps in Power BI are enough for most small business needs.
How often should a dashboard update?
Match the update frequency to the decision. Daily is right for sales or stock levels in a busy shop, while weekly or monthly is enough for most strategic metrics. Faster updates are only useful if someone acts on them.
Can I use AI to build a dashboard?
Many tools now include AI features that suggest charts or answer questions about your data. They can speed up the first draft, but you still need to choose the metrics, check the definitions and confirm that the numbers match your source systems.
Related reading
The bottom line
A simple business dashboard is a short list of well-defined numbers, fed automatically and shown on one clear page. Start with the decisions you make, build a first version in a spreadsheet, and move to Looker Studio or Power BI only when you need more. A small dashboard you check every week is worth far more than an impressive one nobody opens.
