How to Build Your First Looker Studio Dashboard: Step-by-Step Guide

Building your first Looker Studio dashboard can seem overwhelming, but with the right approach, you’ll have a professional dashboard running in under an hour. In this guide, I’ll walk you through creating your first dashboard from scratch, sharing practical tips I’ve learned from building 100+ dashboards over the past 8 years.

Why Looker Studio?

Before we dive in, let’s understand why Looker Studio is an excellent choice for your first dashboard:

• Free to use - No licensing costs or subscriptions
• Easy to learn - Intuitive drag-and-drop interface
• Powerful integrations - Connects to 100+ data sources
• Real-time updates - Automatic data refreshes
• Shareable - Collaborate with your team easily

Prerequisites

For this tutorial, you’ll need:

• A Google account (free)
• Access to a data source (we’ll use Google Sheets for this example)
• Basic understanding of spreadsheets

Step 1: Prepare Your Data

First, let’s set up a sample dataset. I’ll use a simple sales dataset as an example, but you can adapt this to your own data.

Create a Google Sheet

1. Open Google Sheets and create a new spreadsheet
2. Name it “Sales Data”
3. Add the following columns and sample data:

Date	Product	Category	Sales	Units	Region
2024-01-01	Widget A	Electronics	1500	10	North
2024-01-02	Widget B	Electronics	2300	15	South
2024-01-03	Widget A	Electronics	1800	12	East
2024-01-04	Widget C	Accessories	900	20	West
2024-01-05	Widget B	Electronics	2100	14	North

Add at least 20-30 rows of data for better visualization. Make sure your first row contains headers.

Pro Tip: Ensure your data is clean - no empty rows, consistent date formats, and proper column names. This will save you time later.

Step 2: Create a New Looker Studio Report

1. Go to lookerstudio.google.com
2. Click the “Create” button in the top left
3. Select “Report” from the dropdown
4. You’ll be prompted to add a data source - we’ll do this in the next step

Step 3: Connect Your Data Source

1. In the data source selection screen, search for “Google Sheets”
2. Click on “Google Sheets”
3. Select your “Sales Data” spreadsheet
4. Choose the specific sheet (if you have multiple sheets)
5. Click “Add” in the top right

Understanding the Data Source Panel

Once connected, you’ll see:

• Fields panel on the right - All your columns
• Field types - Dimensions (text, dates) and Metrics (numbers)
• Field properties - You can rename, change types, and create calculated fields

Important: Looker Studio automatically detects field types, but you may need to adjust them:

• Dimensions = Categories (Product, Region, Date)
• Metrics = Numbers you can sum/average (Sales, Units)

Step 4: Add Your First Chart

Now the fun begins! Let’s create a simple bar chart showing sales by product.

1. Click “Add a chart” in the toolbar (or press A)
2. Select “Bar chart”
3. The chart will appear on your canvas

Configure the Chart

1. In the Data panel on the right:
   • Dimension: Drag “Product” to the Dimension field
   • Metric: Drag “Sales” to the Metric field
2. Your chart should now show bars for each product

Pro Tip: If your chart looks empty, check:

• Are your metrics showing as numbers (not text)?
• Do you have data in your source?
• Try clicking “Refresh data” in the toolbar

Step 5: Add More Visualizations

Let’s add a few more charts to make a complete dashboard:

Time Series Chart (Sales Over Time)

1. Add a new Time series chart
2. Set:
   • Dimension: Date
   • Metric: Sales
3. This shows your sales trend over time

Pie Chart (Sales by Category)

1. Add a Pie chart
2. Set:
   • Dimension: Category
   • Metric: Sales
3. This shows the distribution of sales across categories

Scorecard (Total Sales)

1. Add a Scorecard
2. Set:
   • Metric: Sales
   • Aggregation: Sum
3. This displays your total sales as a large number

Step 6: Style and Format Your Dashboard

Adjust Chart Sizes

• Click on any chart
• Drag the corners to resize
• Arrange charts by dragging them around

Apply Consistent Styling

1. Select a chart
2. In the Style panel:
   • Choose colors that match your brand
   • Adjust fonts and sizes
   • Add borders if needed

Best Practice: Use a consistent color palette across all charts. I recommend:

• Primary color for main metrics
• Neutral colors for secondary data
• One accent color for highlights

Add a Title

1. Click “Insert” → “Text”
2. Type “Sales Dashboard”
3. Style it with a large, bold font

Step 7: Add Filters (Make It Interactive)

Filters let users explore the data themselves:

1. Click “Add a control” → “Dropdown list”
2. Set:
   • Control field: Region
   • Title: “Filter by Region”
3. Place it at the top of your dashboard
4. Users can now filter all charts by region

Pro Tip: Add filters for dimensions users care about most - date ranges, categories, regions, etc.

Step 8: Set Up Automatic Data Refresh

1. Click on your data source (in the left panel)
2. Click the three dots (⋮) next to your data source
3. Select “Edit”
4. Scroll to “Data freshness”
5. Choose how often to refresh:
   • 15 minutes for frequently changing data
   • 1 hour for daily updates
   • Daily for static or slowly changing data

Step 9: Share Your Dashboard

1. Click the “Share” button in the top right
2. Choose sharing options:
   • “Viewer” - Can only view
   • “Editor” - Can make changes
3. Copy the link or add specific people

Security Tip: Be careful with “Anyone with the link” - only use this for non-sensitive data.

Common Mistakes to Avoid

Based on my experience, here are the most common mistakes beginners make:

1. Overcrowding the Dashboard

Mistake: Trying to show everything on one page Solution: Focus on 5-7 key metrics. Create multiple pages if needed.

2. Inconsistent Date Formats

Mistake: Mixing date formats in your source data Solution: Standardize dates to YYYY-MM-DD format before connecting

3. Not Using Filters

Mistake: Creating static dashboards Solution: Always add relevant filters - users want to explore data

4. Poor Color Choices

Mistake: Using too many colors or low-contrast combinations Solution: Stick to 3-4 colors maximum, ensure good contrast

5. Ignoring Mobile View

Mistake: Only designing for desktop Solution: Check mobile view (View → Mobile layout) and adjust as needed

Advanced Tips for Better Dashboards

Once you’re comfortable with the basics, try these:

Calculated Fields

Create custom metrics using formulas:

1. In your data source, click “Add a field”
2. Use formulas like:

   Sales / Units  // Average sale price

   IF(Region = "North", Sales, 0)  // Conditional logic

Blended Data Sources

Combine data from multiple sources:

1. Click “Add a data source”
2. Add your second source
3. Click “Blend data”
4. Select common dimensions to join on

Custom Date Ranges

Add a date range control:

1. Add a control → “Date range control”
2. Users can select custom date ranges
3. All time-based charts will automatically filter

Next Steps

Congratulations! You’ve built your first Looker Studio dashboard. Here’s what to do next:

1. Practice with real data - Connect your actual business data
2. Explore more chart types - Try tables, maps, and gauges
3. Learn calculated fields - Create custom metrics
4. Connect to BigQuery - For larger, more complex datasets

Need Help?

Building dashboards gets easier with practice, but sometimes you need expert help. If you’re struggling with:

• Complex data connections
• Performance issues
• Custom calculations
• Multi-source integrations

Schedule a free consultation and I’ll help you build dashboards that drive real business value.

Conclusion

Looker Studio is a powerful tool that doesn’t require coding knowledge, making it accessible for anyone. Start simple, practice regularly, and don’t be afraid to experiment. The best dashboards are built iteratively - start with basic charts and refine based on user feedback.

Ready to build your first dashboard? Contact me if you have questions or need personalized help.

---

This guide is based on 8+ years of hands-on experience building Looker Studio dashboards for businesses across industries. Want to see more advanced techniques? Check out our guides on Connecting BigQuery to Looker Studio and BigQuery Cost Optimization.