How to Build a Sales Dashboard Without Hiring a Data Analyst

A sales dashboard that shows the six numbers that actually drive decisions takes one afternoon to build in Google Looker Studio, and it is free. Most small businesses never build one because they assume it requires a data analyst, expensive software, or weeks of setup. None of that is true. What it requires is knowing which metrics to track and where your data currently lives.

What a Sales Dashboard Should Tell You

Before choosing a tool or connecting a data source, define the decisions your dashboard needs to support. The best dashboards answer a small number of high-stakes questions, not every possible question.

For most service businesses, the six metrics that change behaviour are:

New qualified leads this period. Not total enquiries, but enquiries that meet your minimum criteria: right company size, right industry, right budget range. If you are not tracking lead qualification in your CRM, start there before building the dashboard.

Proposals sent. How many qualified leads converted to a proposal or quote request? This number tells you whether your discovery process is converting.

Proposal acceptance rate. Proposals closed divided by proposals sent, expressed as a percentage. Industry averages vary, but for most B2B service businesses a healthy rate is 25 to 50 percent. Below 20 percent is a signal that either pricing or proposal quality needs attention.

Average deal size. Total revenue closed divided by number of deals closed. Watch this number monthly. If it is declining, you are winning smaller clients. If it is growing, your positioning or pricing is improving.

Revenue closed vs target. This is the primary performance metric. Set a monthly or quarterly revenue target and track actual closed revenue against it. Display it as both a number and a percentage of target.

Pipeline value. The total value of open proposals and active opportunities. Divide by your acceptance rate to estimate expected revenue from the current pipeline. This is your early warning system: if pipeline value drops, revenue follows four to eight weeks later.

For e-commerce businesses, replace the service-business metrics with: orders, average order value, conversion rate, revenue vs target, customer acquisition cost, and repeat purchase rate.

Choosing the Right Dashboard Tool

The tool you need depends on where your data currently lives.

Google Looker Studio (free) is the best starting point for businesses already using Google tools: GA4, Google Ads, Google Sheets, and YouTube. It connects natively to all of these sources, requires no code, produces live dashboards that update automatically, and is completely free. The interface is similar to Google Slides with data connections.

Metabase (free, self-hosted) is the best free option for businesses that need to query a database directly. It works with PostgreSQL, MySQL, MongoDB, and most SQL databases. You install it on a server (or run it in Docker), connect to your database, and build dashboards using a point-and-click query builder. No SQL required for most queries.

Power BI (Microsoft) is $10 per user per month for Pro. If your business already runs on Microsoft 365 and stores data in SQL Server, SharePoint, or Excel, Power BI connects natively and offers more advanced visualisation options than Looker Studio.

Tableau starts at $15 per user per month for Creator. It offers the most powerful visualisation capabilities of any commercial tool, but it has a steep learning curve and is overkill for most small business use cases.

Start with Looker Studio. If you outgrow its capabilities (typically when you need to join multiple complex data sources or run advanced statistical analysis), Metabase or Power BI are the next step.

Step-by-Step: Building Your Dashboard in Looker Studio

Step 1: Set Up Your Data Sources

Open Looker Studio (lookerstudio.google.com), click Create > Report, and connect your first data source. For a sales dashboard, your primary sources will likely be:

• Google Sheets for CRM data you are tracking manually or exporting from your CRM. Export a clean spreadsheet with columns for Lead Date, Lead Source, Lead Status, Proposal Date, Proposal Value, Close Date, Deal Size, and Client Name.
• GA4 for website traffic data connecting to pipeline.
• Google Ads for paid traffic cost data if you are running paid campaigns.

For Shopify, the cleanest route is to use the Shopify Export to Google Sheets: schedule a monthly or weekly export of orders, customers, and marketing performance to a Google Sheet, then connect that sheet to Looker Studio. Alternatively, paid connectors like SuperMetrics ($50 to $99 per month) or Porter Metrics ($49 to $149 per month) provide real-time Shopify integration into Looker Studio or Power BI.

Step 2: Design the Layout

Create one page per reporting period or business unit. For a single-team service business:

• Top row: four scorecards (New Leads, Proposals Sent, Revenue Closed, Pipeline Value)
• Middle row: time series charts for Leads and Revenue over the past 12 months
• Bottom section: a table showing individual deals in the current period by Lead Source, Proposal Value, and Status

Keep the layout clean. A dashboard that requires explanation to use is not a dashboard, it is a report. Every element should answer a question your team actually asks.

Step 3: Add Date Range Controls

Add a Date Range Control to the top of the dashboard so you can switch between current month, previous month, and year-to-date without rebuilding the report. In Looker Studio, use Insert > Date Range Control and connect it to all charts on the page.

Step 4: Set Up Comparison Periods

The most useful dashboard metric is not the number itself but the change relative to the prior period. Add a comparison to every scorecard: this month vs last month, or this quarter vs last quarter. Looker Studio supports this natively in scorecard settings.

Step 5: Share and Schedule

Share the report with your team via the Share button (Looker Studio reports are shareable via link). Set up a scheduled email delivery (File > Schedule email delivery) to send the dashboard as a PDF to yourself and your key team members every Monday morning.

What the Review Process Should Look Like

A dashboard only produces value if someone reviews it and acts on it. Build a review routine:

Weekly review (15 minutes): Check new leads, proposals sent, and any deal status changes from the previous week. Flag any pipeline items that have been stalled for more than two weeks.

Monthly review (45 minutes): Review all six core metrics against the prior month and year-to-date target. Identify the lead source producing the highest-value clients and consider reallocating marketing effort toward it. Check whether average deal size is trending up or down.

Set a recurring calendar block for both reviews. Without a scheduled time, the dashboard becomes something you check sporadically rather than systematically.

For more on what to do with the data your dashboard surfaces, read how to track marketing ROI and customer lifetime value guide. The dashboard gives you the numbers; those guides help you interpret what they mean.

Our business dashboards service builds custom dashboards connecting your CRM, accounting software, website analytics, and ad platforms into a single live view. If you want a dashboard that connects to your actual data sources rather than a manual spreadsheet, a data analyst can build and automate it in two to four days. Get in touch to discuss what your reporting should actually look like.