Looker Studio Tutorial — Free Google Analytics Dashboards

Looker Studio (formerly Google Data Studio) is Google's free, web-based data visualization tool. It's designed for creating shareable dashboards with Google ecosystem data.

Why Looker Studio?

1. Completely Free

• No installation, no licensing costs
• Unlimited reports and dashboards
• Unlimited viewers (share with anyone)
• Part of Google Workspace (no separate account)

2. Native Google Integrations

• Google Analytics 4 (website/app analytics)
• Google Sheets (spreadsheet data)
• BigQuery (data warehouse)
• Google Ads (ad campaign performance)
• YouTube Analytics (video metrics)
• Search Console (SEO data)

3. Real-Time and Collaborative

• Dashboards update automatically when data changes
• Share via link (like Google Docs)
• Collaborative editing (multiple people edit simultaneously)
• Embed in websites/portals

Looker Studio vs Power BI vs Tableau

| Feature | Looker Studio | Power BI | Tableau | |---------|---------------|----------|---------| | Price | Free | ₹800/month | ₹5,800/month | | Installation | Web-only (no install) | Desktop app (Windows) | Desktop app | | Best for | Google data (GA4, Sheets) | Microsoft ecosystem | Any data, best viz | | Data connectors | 800+ (community) | 100+ (built-in) | 100+ (built-in) | | Learning curve | Easy (drag-drop) | Moderate (DAX) | Moderate (calcs) | | Calculations | Limited (basic formulas) | Powerful (DAX) | Powerful (LOD) | | Sharing | Link (like Google Docs) | Workspace (license) | Server (license) |

When to Use Looker Studio

Perfect for:

• Google Analytics 4 dashboards (website traffic, conversions)
• Google Ads reporting (campaign performance, ROI)
• Google Sheets data (surveys, manual tracking)
• Small businesses (zero budget)
• Quick dashboards (build in 30 minutes)

Not ideal for:

• Complex DAX/calculated measures (use Power BI)
• Offline work (Looker Studio is cloud-only)
• Large enterprise governance (Power BI/Tableau better)
• Advanced statistical visuals (use Tableau)

Real Example: Marketing Dashboard

Scenario: You run an e-commerce site. You want a weekly marketing dashboard showing:

• Website traffic (from Google Analytics 4)
• Ad spend and ROI (from Google Ads)
• Top products (from Google Sheets export)
• Conversion funnel (from GA4)

Solution: Looker Studio connects all three sources in one dashboard. Updates automatically. Share link with stakeholders. All free.

Access Looker Studio

No installation needed — it's a web app.

1. Go to: https://lookerstudio.google.com
2. Sign in with your Google account (Gmail, Workspace, etc.)
3. Home screen appears with templates and blank reports

That's it. No download, no credit card.

Create a Blank Report

1. Click Create (top-left) → Report
2. Connect to data screen appears
3. For this tutorial, we'll use Google Sheets (easiest to follow along)

Set Up Sample Data

Option 1: Use Pre-Built Sample

• In "Connect to data" screen → Search "Sample Data"
• Select Sample Ecommerce Data (Google's sample dataset)
• Click Add → Dashboard editor opens with data connected

Option 2: Use Your Own Google Sheet

1. Create a Google Sheet with this structure:

1. In Looker Studio: Click Create → Report
2. Search connectors: Type "Google Sheets"
3. Select Google Sheets connector → Authorize (allow Looker Studio to access Sheets)
4. Select your spreadsheet → Click Add
5. Dashboard editor opens with your data

Interface Overview

Key Areas:

1. Canvas (center) — Your report page (drag-drop charts here)
2. Toolbar (top) — Add charts, controls (filters), text, images
3. Data panel (right) — Shows fields (dimensions, metrics) from connected data
4. Properties panel (right) — Format selected chart (appears when chart is selected)

Looker Studio's power is combining data from multiple sources in one dashboard.

Google Analytics 4 (Website Traffic)

Setup:

1. Add a chart → In data source dropdown → Create New Data Source
2. Search: "Google Analytics"
3. Select: Google Analytics (GA4)
4. Authorize: Allow access to your GA4 properties
5. Select your property (website) → Select account → Connect
6. Add to Report

Fields Available:

• Dimensions: Date, Page Path, City, Device Category, Traffic Source
• Metrics: Sessions, Users, Page Views, Bounce Rate, Conversions

Use Cases:

• Daily website traffic trend
• Top pages by views
• Traffic by city/device
• Conversion funnel

Google Sheets (Manual Data)

Already covered above — great for:

• Product catalogs
• Survey results
• Manual KPI tracking
• Budget vs actual comparisons

BigQuery (Data Warehouse)

For companies with large datasets:

1. Create New Data Source → Search "BigQuery"
2. Authorize BigQuery access
3. Select: Project → Dataset → Table
4. Connect → Fields appear (all table columns)
5. Add to Report

Use Cases:

• E-commerce transaction data (millions of orders)
• App event data (user behavior logs)
• Aggregated reports from data pipelines

Google Ads (Ad Campaign Performance)

1. Create New Data Source → "Google Ads"
2. Authorize → Select ad account
3. Choose report type: Campaign, Ad Group, or Keyword
4. Connect

Fields Available:

• Dimensions: Campaign, Ad Group, Keyword, Date
• Metrics: Impressions, Clicks, Cost, Conversions, CPC, ROAS

Blend Data (Join Multiple Sources)

Combine data from two sources (like SQL JOIN):

Example: Google Sheets (product details) + BigQuery (sales transactions)

1. Data menu → Blend Data
2. Select first source: BigQuery sales table
3. Select second source: Google Sheets product catalog
4. Join key: Product_ID (must exist in both sources)
5. Join type: Left, Right, Inner, or Outer
6. Select fields to include from each source
7. Save blend → Use as data source in charts

Result: Charts show sales data with product category/descriptions from Sheets.

Let's build 5 core charts for an e-commerce dashboard.

Chart 1: Sales Over Time (Time Series)

1. Toolbar → Click Add a chart → Select Time Series Chart
2. Click canvas to place chart
3. Properties panel (right) appears:
   • Dimension: Date (auto-populated if date field exists)
   • Metric: Sales (drag from data panel or select from dropdown)
   • Date range: Default (last 28 days) — change if needed
4. Style tab: Customize colors, line thickness, data labels

Result: Line chart showing daily sales trend.

Add comparison (this year vs last year):

• Properties → Comparison date range → Toggle ON
• Select: Previous year
• Chart shows two lines: This year (solid) vs Last year (dashed)

Chart 2: Sales by Category (Bar Chart)

1. Add a chart → Bar Chart
2. Dimension: Category (e.g., Electronics, Fashion, Home)
3. Metric: Sales
4. Sort: Descending (highest sales first)
5. Bar count: Limit to 10 (if many categories)

Result: Horizontal bars showing which category sold most.

Add drill-down:

• Properties → Interactions → Apply filter on click
• When user clicks "Electronics" bar → Entire dashboard filters to Electronics

Chart 3: KPI Scorecard (Total Sales)

1. Add a chart → Scorecard
2. Metric: Sales (SUM aggregation by default)
3. Style: Large font, add ₹ prefix
4. Add comparison: Previous period (shows growth %)

Result: Single large number showing total sales with "+15% vs last month" below.

Create multiple scorecards for:

• Total Orders (COUNT)
• Average Order Value (Sales / Orders)
• Conversion Rate (Orders / Sessions)

Chart 4: Geographic Map (Sales by Region)

1. Add a chart → Geo Chart → India (or world map)
2. Location dimension: Region (Mumbai, Delhi, Bangalore, etc.)
3. Metric: Sales (bubble size) or Orders (color intensity)
4. Style: Bubble map (shows circles) or Filled map (colors regions)

Result: Map of India with colored regions or bubbles showing sales density.

Chart 5: Table (Top Products)

1. Add a chart → Table
2. Dimensions: Product_Name
3. Metrics: Sales, Orders, Avg_Order_Value
4. Sort: Sales descending
5. Rows displayed: 10 (top 10 products)

Format:

• Style → Table colors → Alternate row shading (easier to read)
• Add heatmap: Select Sales column → Conditional formatting → Color scale (light to dark based on value)

Result: Top 10 products table with colored cells showing performance.

Create Calculated Fields (Custom Metrics)

Looker Studio supports formulas (like Excel, but limited compared to DAX).

Example 1: Average Order Value

1. Data panel → Click Add a Field (bottom)
2. Field name: Avg Order Value
3. Formula: Sales / Orders
4. Save → New green metric appears

Example 2: Growth % (This Period vs Last Period)

Looker Studio doesn't have built-in "last period" function, so you need to:

1. Add Comparison date range to chart (easier method)
2. OR blend data with date-shifted version (advanced)

Example 3: Revenue Band (Categorize)

Example 4: Extract Month from Date

OR for month name:

Functions Available:

• Math: SUM, AVG, COUNT, MAX, MIN, ROUND
• Text: CONCAT, LOWER, UPPER, SUBSTR, REPLACE
• Date: YEAR, MONTH, DAY, DATE_DIFF, TODAY
• Logic: IF, CASE, COALESCE (handles nulls)
• Regex: REGEXP_MATCH, REGEXP_REPLACE

Add Filters and Controls

Date Range Control (Slicer):

1. Toolbar → Add a control → Date range control
2. Place at top of dashboard
3. Properties → Default date range: Last 30 days
4. Users can select custom date range → Dashboard updates

Dropdown Filter (Category):

1. Add a control → Drop-down list
2. Dimension: Category
3. Allow multiple selections: ON
4. Default: All categories

Checkbox Filter (Region):

1. Add a control → Checkbox
2. Dimension: Region
3. Users check/uncheck regions to filter

Layout Best Practices

Grid System:

• Looker Studio uses pixel-based grid (not auto-resize like Power BI)
• Tip: Enable View → Show grid → Snap components to grid

Recommended Layout:

Styling and Branding

Theme (colors, fonts):

1. Theme and layout menu (top) → Current theme → Customize
2. Brand colors: Set 4-5 brand colors (charts use these automatically)
3. Font style: Choose primary font (e.g., Roboto, Lato, Google Sans)
4. Apply → All charts adopt theme

Add Logo:

1. Insert → Image → Upload logo
2. Place in header (top-left corner)
3. Link (optional): Add URL to company website

Background:

• Page menu → Current page settings → Background: Light gray (#F5F5F5) or white
• Canvas size: Fixed (1280×720 for presentations) or Fit-to-width (responsive)

Sharing and Permissions

Share Link (like Google Docs):

1. Share button (top-right) → Get shareable link
2. Permissions:
   • Viewer: Can view, can't edit (most common for stakeholders)
   • Editor: Can edit dashboard (for team members)
3. Copy link → Send to stakeholders

Embed in Website:

1. File → Embed report
2. Copy embed code (iframe)
3. Paste into website HTML

Example:

<iframe width="800" height="600"
  src="https://lookerstudio.google.com/embed/reporting/abc123/page/xyz"
  frameborder="0" allowfullscreen>
</iframe>

Schedule Email Delivery:

1. File → Schedule email delivery
2. Recipients: Add email addresses
3. Frequency: Daily, weekly, monthly
4. Time: Select time and timezone
5. Save → Dashboard PDF auto-emails to recipients

Download as PDF:

• File → Download → PDF (static snapshot for presentations)

Refresh Settings

Data Freshness:

• Google Analytics: Updates every ~24 hours (not real-time)
• Google Sheets: Updates every 15-60 minutes (auto-refresh)
• BigQuery: Real-time (queries on dashboard view)

Force refresh:

• Data menu → Refresh data (re-fetches from source)

1. Dynamic Dates (Relative Date Ranges)

Instead of hardcoding "Jan 1 - Mar 31", use dynamic ranges:

In Date Range Control:

• Default date range → Auto date range:
  • Last 7 days
  • Last 28 days
  • Last 90 days
  • Month to date (MTD)
  • Quarter to date (QTD)
  • Year to date (YTD)

Use case: Dashboard always shows "last 30 days" without manual updates.

2. Parameters (User-Defined Variables)

Create variables that users can change (like Excel cell references):

Example: User selects target revenue (₹50L vs ₹1Cr) → Charts compare actual vs selected target.

Create Parameter:

1. Data → Add a parameter
2. Name: Revenue_Target
3. Data type: Number
4. Default value: 5000000
5. Create control: ON (adds dropdown to dashboard)
6. Save

Use in Calculated Field:

Shows variance from user-selected target.

3. Community Visualizations

Third-party chart types (beyond standard bar/line/pie):

1. Add a chart → Community visualizations
2. Popular types:
   • Sankey diagram (flow charts)
   • Sunburst chart (hierarchical data)
   • Radar chart (multi-variable comparison)
   • Funnel chart (conversion dropoff)
3. Add to report → Use like standard charts

Example: Sankey diagram showing user journey (Homepage → Product → Cart → Checkout)

4. Data Blending (Advanced Joins)

Already covered basics. Advanced technique:

Self-Join (compare current vs previous period):

1. Data → Blend data
2. Left source: Sales data (Date = current period)
3. Right source: Same sales data (Date = previous period)
4. Join key: Product_ID
5. Create calculated field: Sales_Current - Sales_Previous

Result: Charts show week-over-week or month-over-month growth per product.

5. Drill-Down (Hierarchical Navigation)

Create hierarchies for exploration (Year → Quarter → Month → Day):

Method:

1. Chart properties → Drill down → Enable
2. Dimension hierarchy: Add levels
   • Level 1: Year (from Date)
   • Level 2: Quarter
   • Level 3: Month
   • Level 4: Day
3. User interaction: Click year → Drills to quarter → Click quarter → Drills to month

6. Mobile Optimization

Auto-responsive:

• Looker Studio dashboards are responsive by default (adapt to screen width)
• Tip: Test on phone (share link, open in mobile browser)

Mobile-specific tweaks:

• Reduce number of charts (4-5 max on mobile)
• Use vertical layout (single column)
• Increase font sizes (12pt minimum)
• Simplify filters (use dropdowns, not multi-checkbox)