How to Build an Operations Dashboard in Looker Studio

Looker Studio (formerly Google Data Studio) is free, runs entirely in your browser, and connects to a spreadsheet in three clicks. You do not need to know SQL or Python to build a live operations dashboard. The core steps are: prepare your data in Google Sheets or upload a CSV, connect it to Looker Studio, lay out your KPIs as scorecards, and add the charts your team will actually use. Power BI, the closest paid alternative, starts at $14 per user per month for the Pro tier, making Looker Studio's free offering a meaningful cost advantage for small teams.

What You Need Before You Start

Before opening Looker Studio, your source data needs to be in one of two places: a Google Sheet or a CSV file uploaded to Google Drive.

Rules for your source data: column headers go in row 1 with no merged cells; one table per sheet rather than data split across multiple tabs; dates formatted as YYYY-MM-DD or MM/DD/YYYY; and numbers stored as numbers, not text strings.

If you are working from an existing spreadsheet, spend five minutes cleaning it first. Looker Studio pulls in whatever structure you give it, and mixed data types in a column will break aggregations later.

The platform is free at lookerstudio.google.com with any Google account.

Step 1: Connect Your Data Source

Go to lookerstudio.google.com and click Create, then Report. You will be prompted to add a data source.

For Google Sheets: search for "Google Sheets" in the connector list, select it, choose your spreadsheet and the specific sheet tab, then click Add to Report.

For CSV: upload the file to Google Drive first, open it in Google Sheets using right-click in Drive and selecting Open with Sheets, then follow the Google Sheets connection steps above.

Looker Studio reads your column headers and assigns each field as either a dimension (text, categories, dates) or a metric (numbers). It assigns types automatically, but verify them in the data source editor. Change any column that was misclassified. A numeric customer ID field flagged as a metric should be changed to a dimension.

Once connected, click Add to Report and your blank canvas opens.

Step 2: Plan Your Layout Before Adding Charts

The dashboards that get used longest follow a three-tier layout. The top strip holds scorecards: four to six single-number summaries of the metrics that matter most. The middle section holds one or two trend charts showing how those metrics change over time. The bottom section holds a breakdown table for investigation.

Avoid the common mistake of adding every chart your data supports. Dashboards used in operations reviews work best when they answer one question per page: is the business running on track this week?

Rename the report to something specific before proceeding, such as "Weekly Operations - April 2026." This prevents confusion when the report is shared with a team.

Step 3: Add Scorecards for Key Metrics

Scorecards are the rectangular boxes that display a single aggregated number. They are the fastest way for any reader to get a status check without reading a table.

Click Add a chart in the toolbar, then select Scorecard. Drag it to the top of the canvas. In the right panel, set the Metric to the field you want to total or average, for example Total Revenue, Orders Placed, or Tickets Closed. Turn on Comparison date range to automatically show percentage change from the prior period. Enable Compact numbers if figures are large so that 1,200,000 displays as 1.2M.

Add three to five scorecards in a horizontal row. A well-configured scorecard shows the current value and the delta from last week or last month in a single glance.

Label each scorecard clearly with a custom title in the Style panel. Default labels like SUM(Revenue) confuse readers who did not build the report.

Step 4: Build Trend Charts

Below the scorecards, add a time series chart. Click Add a chart and select Time series.

Set your date dimension as the X-axis. Looker Studio will group by day, week, or month based on the data range in scope. For an operations dashboard covering the last 90 days, weekly grouping is usually the right granularity.

Add one or two metrics to the chart. Avoid stacking five or six lines on a single chart. If you need to show multiple KPIs, add a second chart rather than layering lines that will overlap and become unreadable in a meeting.

A bar chart works better than a line chart when comparing volumes across discrete periods, for example weekly order counts. Use line charts for trends that need to show continuity, for example a rolling average delivery time.

Step 5: Add a Data Table for Drilldown

Below the trend section, add a Table chart. This is where readers investigate anomalies they spotted in the scorecards or trend lines.

For an operations dashboard, the table typically shows one row per product, region, or team with several metric columns. Sort by the most important metric descending by default so the highest-volume rows appear first.

Enable Pagination in the Style panel if you have more than 15 to 20 rows. A table with 200 rows and no pagination is difficult to use during a review meeting.

Add a drop-down filter so readers can filter the table by a category such as region or product line without leaving the report. Click Add a control, select Drop-down list, and set the Dimension to the field you want to filter on.

Step 6: Add a Date Range Control

Click Add a control, then Date range control. Place it near the top of the dashboard. This gives every reader the ability to adjust the time window without editing the report itself.

Set a Default date range in the right panel. For most operations dashboards, Last 28 days or Last 30 days is the right default. Avoid "This month" as the default because it creates a sparse dashboard in the first few days of a new month when there is little data to display.

The date range control affects every chart on the page that uses the same data source.

Step 7: Share and Schedule Email Delivery

Click Share in the top right. You can share with specific Google accounts or generate a view-only link. Choose Viewer access for most recipients so they cannot accidentally edit the report structure.

Looker Studio supports scheduled email delivery. Open the three-dot menu in the top right of a finished report, then select Schedule email delivery. You can send the dashboard as a PDF attachment to a distribution list on a daily or weekly schedule.

This feature is useful for teams that do not want to remember to open a link. The report arrives in their inbox automatically at the start of each week.

Where Looker Studio Falls Short

Looker Studio has two practical limitations worth knowing before you commit to it. First, it does not run calculations or transformations on raw data. If your Google Sheet needs formulas cleaned up or columns restructured, that work happens in the Sheet, not in Looker Studio. Second, its AI features as of 2026 are limited to natural language questions about existing visualizations through the Visualization Assistant and do not extend to data-level analysis or automatic insight generation.

If your data arrives messy and you need to go straight from a file upload to statistical analysis and charts in one prompt, a tool like VSLZ handles that end-to-end without requiring you to clean and structure the data manually first.

Summary

A working Looker Studio operations dashboard takes four components: a clean data source in Google Sheets, scorecards for your top KPIs, a trend chart showing change over time, and a date range control so the team can filter by period. The build takes under an hour. Share the finished report to your team and schedule weekly email delivery so the dashboard lands in inboxes without anyone needing to remember a link.