Labs4Change

Blog

Insights on analytics engineering and AI strategy

Launch state starts with no public posts.

2026-03-10

Looker Explore Best Practices: Labels, Joins, and Field Organization

How to design Looker Explores that business users actually understand. Covers labeling conventions, join best practices, field grouping, and documentation patterns.

Read post →

2026-03-08

SQL Fanouts in Looker: Why Your Measures Are Wrong and How to Fix Them

Understand SQL fanouts in Looker — why joined tables produce incorrect counts and sums, how to detect fanouts, and three patterns to prevent them.

Read post →

2026-03-06

Looker Caching and Datagroups: Stop Hitting Your Database on Every Query

How Looker caching works, how to configure datagroups for optimal performance, and the caching patterns that align refresh with your ETL schedule.

Read post →

2026-03-04

dbt vs Looker: Where Should Your Business Logic Live?

A decision framework for what belongs in dbt and what belongs in Looker. Stop duplicating logic across your data stack — here's where each transformation should go.

Read post →

2026-03-03

5 AI Use Cases Every Business Should Implement in 2026

Five practical, high-ROI AI use cases you can implement today — from internal knowledge search to automated reporting. No hype, just what works.

Read post →

2026-03-02

Migrate from Looker to Omni in Days, Not Months

A practical guide to migrating from Looker to Omni Analytics — why most migrations fail, how our AI-powered tool handles the hard parts, and a step-by-step approach.

Read post →

2026-03-01

Omni vs Looker in 2026: An Honest Comparison by the Team That Knows Both

A side-by-side comparison of Omni Analytics and Google Looker — schema layer vs LookML, AI features, pricing, migration path, and when each tool makes sense.

Read post →

2026-02-28

The Fractional Head of Data: Why You Don't Need a $250k Hire

Why a fractional Head of Data beats a full-time hire for most mid-market companies — and what the engagement actually looks like.

Read post →

2026-02-25

Looker Dashboard Tabs: How We Cut Load Times from 2 Minutes to Under 10 Seconds

How Looker's tabbed dashboard components transformed slow, monolithic dashboards into sub-10-second experiences — implementation guide with real performance results.

Read post →

2026-02-25

LookML Best Practices: The Folder Structure That Scales

How to organize your Looker project with auto-generated views, refinements, and a clean folder structure that doesn't fall apart at 500 views.

Read post →

2026-02-22

Automate Looker Content Cleanup with the SDK and BigQuery

How to build an automated Looker content cleanup pipeline using the Looker SDK — identify stale dashboards, unused Looks, and orphaned content every 90 days with results stored in BigQuery.

Read post →

2026-02-20

Looker Permissions Done Right: Groups, Access Grants, and Row-Level Security

A practical guide to Looker permissions — groups-first access, row-level security, column-level grants, and the folder structure that keeps content governed.

Read post →

2026-02-18

Omni User Management at Scale with omni-user-manager

How to manage users, roles, and permissions in Omni Analytics at scale using Hawkfry Group's open-source omni-user-manager tool — bulk provisioning, role assignment, and lifecycle automation.

Read post →

2026-02-15

The Essential Omni Analytics Resource Guide

A curated guide to the Omni Analytics ecosystem — tools, documentation, community resources, migration guides, and open-source projects for teams adopting Omni.

Read post →

2026-02-12

dbt + BigQuery + Looker: Building Your Modern BI Stack in 2026

How to architect a modern BI stack with dbt, BigQuery, and Looker — layer separation, transformation best practices, LookML patterns, and the role of AI in the modern analytics pipeline.

Read post →