How to Create a Manufacturing Dashboard in Looker

A manufacturing dashboard in Looker acts as a real-time command center for your entire production floor and supply chain operations. From monitoring equipment effectiveness to tracking output against quotas, it transforms raw data into actionable insights. This article will guide you through the key metrics to track and the step-by-step process of building a powerful manufacturing dashboard yourself.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why a Manufacturing Dashboard is a Game-Changer

Before jumping into the “how,” it’s helpful to understand the “why.” The core benefit of a centralized manufacturing dashboard is visibility. Instead of digging through separate reports from your Enterprise Resource Planning (ERP), Manufacturing Execution Systems (MES), or IoT sensors, you get one unified view. This immediately helps you:

• Spot Bottlenecks: Easily identify which machines or processes are slowing down the entire production line.
• Reduce Downtime: Track machine health and unscheduled stops in real-time to proactively address issues before they cause major delays.
• Improve Quality Control: Monitor defect rates and first pass yield to catch quality issues early and maintain high standards.
• Increase Efficiency: Optimize resource allocation, manage inventory, and make data-driven decisions to boost overall productivity.

In short, it moves your team from being reactive to proactive, turning mountains of data into clear signals that drive better performance.

Key Metrics for Your Manufacturing Dashboard

A great dashboard tells a story. To tell the right story, you need the right characters - your key performance indicators (KPIs). While the exact metrics will depend on your specific operations, here are the most critical ones for any manufacturing environment.

Overall Equipment Effectiveness (OEE)

OEE is the gold standard for measuring manufacturing productivity. It combines three separate factors into a single score that shows you how efficiently your equipment is running.

• Availability: Measures losses due to downtime. What percentage of the planned production time was the machine actually running? (Formula: Run Time / Planned Production Time)
• Performance: Measures losses due to slow cycles. Is the machine running at its optimal speed? (Formula: (Ideal Cycle Time × Total Count) / Run Time)
• Quality: Measures losses due to defects. How many good units were produced out of the total units started? (Formula: Good Count / Total Count)

Your OEE score is a powerful headline number for your dashboard, instantly conveying the health of your production line.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Production and Throughput Metrics

These metrics focus on output and speed, telling you what you're producing and how fast you're producing it.

• Production Volume: The total number of units produced over a specific period (e.g., per hour, shift, day). Comparing this to your target volume is essential.
• Throughput: The average rate of production over a specific period. This helps you understand your actual capacity.
• Cycle Time: The total time it takes to produce one unit from start to finish. Pinpointing cycle times by machine or product line can highlight inefficiencies.

Quality and Waste Metrics

Quality metrics help you understand the effectiveness of your production processes and minimize waste.

• First Pass Yield (FPY): The percentage of units that are manufactured correctly and meet quality standards the first time through, without any rework or additional materials.
• Defect Rate: The percentage of units produced that do not meet quality specifications. Monitoring this trend helps you identify production problems quickly.
• Scrap Rate: The amount of raw material wasted during the production process. High scrap rates can significantly impact your bottom line.

Downtime and Maintenance Metrics

Understanding why your machines stop is critical for improving OEE Availability.

• Asset Downtime: Tracking total downtime is a start, but breaking it down by reason (e.g., unscheduled maintenance, planned setups, material shortage) gives you actionable information.
• Mean Time Between Failures (MTBF): The average time that a piece of equipment operates between breakdowns. A rising MTBF indicates increasing reliability.

Preparing Your Data for Looker

Before you can start building visualizations, your data needs to be accessible and properly modeled in Looker. This often involves two main steps:

1. Connect Your Data Sources

Your manufacturing data likely lives in several places - an ERP like SAP, an MES, historians, or even spreadsheets. The first step, which typically involves your data team, is to connect these sources to your data warehouse (like BigQuery, Snowflake, or Redshift) and then connect that warehouse to Looker.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Create a LookML Model

This is where Looker’s magic happens. LookML is Looker’s modeling layer where you define your business logic. Instead of writing complex SQL queries every time you want to build a chart, your analysts create a reusable data model.

In this model, you define your dimensions (the attributes you group by, like ‘Machine Name’ or ‘Shift Date’) and your measures (the numbers you aggregate, like ‘Total Units Produced’ or ‘Average Cycle Time’). This creates a user-friendly, self-service environment where anyone on your team can explore data without having to know SQL. For a manufacturing dashboard, your LookML model would define how metrics like OEE are calculated, ensuring everyone in the company uses the exact same definition.

Step-by-Step: Building Your Dashboard in Looker

Once your data is modeled, building the dashboard becomes a creative and intuitive process of exploration and visualization.

Step 1: Start a New Dashboard

Navigate to the folder where you want your dashboard to live, click the ‘New’ button, and select ‘Dashboard.’ Give it a clear name like "Plant 1 - Production Overview." You’ll now have a blank canvas to work with.

Step 2: Create a Tile from an Explore

Every visualization on a Looker dashboard is called a ‘Tile.’ You create tiles using ‘Explores,’ which are the starting points for your analysis defined in your LookML model.

1. Go to an Explore relevant to your manufacturing data (e.g., "Production Log" or "Machine Events").
2. From the field picker on the left, select your desired dimensions and measures.
3. To visualize Production Volume Over Time, you might select ‘Production Date’ as a dimension and ‘Sum of Units Produced’ as a measure.
4. Looker will automatically run the query and display the data in a table.

Step 3: Choose Visualizations and Customize

This is where you bring your data to life. Looker offers a wide range of visualization options.

• For the Production Volume Trend, click the ‘Visualization’ tab and select a Line Chart. This allows you to easily spot trends over time.
• To show your daily production target, add a measure for ‘Target Units’ to your query. In the Visualization settings, you can customize the chart, turning the target into a reference line for easy comparison.

Once you’re happy with the chart, click the gear icon in the top right and select ‘Save to Dashboard.’ Find your new dashboard, give the tile a name, and save. Repeat this process to build out all your key visualizations.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Example Visualizations for Key Metrics:

• OEE Score: Use a Single Value visualization to display the overall OEE score prominently at the top of the dashboard. Consider adding color-coding to show if the number is good, middling, or poor.
• Downtime Analysis: To understand a machine's top downtime reasons, use a Pie Chart or Bar Chart. Use the ‘Downtime Reason’ dimension and ‘Sum of Downtime Minutes’ measure.
• Cycle Time per Machine: A Bar Chart is perfect for comparing performances. Select ‘Machine Name’ as your dimension and ‘Average Cycle Time’ as your measure to quickly identify your slowest and fastest machines.
• First Pass Yield Trend: A Line Chart tracking the ‘FPY Percentage’ over time can help you monitor if your quality initiatives are working.

Step 4: Add Interactive Filters

A static dashboard has limited utility. To make your dashboard truly powerful, you need to add filters that allow users to slice and dice the data.

1. In dashboard edit mode, click ‘Filters’ in the top toolbar and select ‘Add Filter.’
2. Popular filters for manufacturing include Date Range, Production Line, Product SKU, or Shift.
3. Link each filter to the relevant field in each dashboard tile. For a ‘Date’ filter, you’ll link it to the date field used in all your charts. This ensures that when a user selects a date range, every tile on the dashboard updates automatically.

These interactive filters empower plant managers and supervisors to drill down into specific areas without needing an analyst to run a new report.

Step 5: Organize Your Layout

The final step is to arrange your dashboard for maximum clarity. Think like a newspaper editor - put the most important headlines at the top.

• Place high-level KPIs like OEE and overall Production Volume in large, easy-to-read Single Value visualizations at the top.
• Group related visualizations together. Your quality metrics (FPY, Defect Rate) can sit next to each other. Your machine performance metrics can form another group.
• Use Text Tiles to add headings, descriptions, or explanations, guiding users through the data story you are telling. A clean, logical layout makes your dashboard not just informative, but enjoyable to use.

Final Thoughts

Building a manufacturing dashboard in Looker organizes vital production data, transforming complex information into clear, actionable visuals for improving efficiency and output. By focusing on key metrics like OEE, cycle time, and FPY, you give your team the tools they need to make faster, smarter decisions on the shop floor.

While powerful, building dashboards in business intelligence tools like Looker involves a learning curve and manual setup. With Graphed, we handle all the heavy lifting. You can connect your manufacturing data sources, and then simply ask for the reports you need in plain English. Rather than configuring tiles and filters, you can say, "Create a dashboard showing our OEE trend, production volume, and machine downtime for the last 30 days," and we build the real-time visualization for you in seconds.