Self-Service Stars Analytics Data Mart
Empowering analysts with a secure, curated Gold layer
Project Overview
A curated 'Gold Layer' data mart built on BigQuery, designed to enable self-service analytics for business users. It features pre-calculated metrics, clean dimensions, and Row-Level Security (RLS) to ensure data privacy.
The Challenge
Business analysts were writing inconsistent, ad-hoc SQL queries against raw data, leading to 'multiple versions of the truth' and performance bottlenecks.
Key Results
- Reduced ad-hoc data requests to the engineering team by 40%.
- Improved query performance for standard reports by 10x.
- Ensured consistent metric definitions across all departments and dashboards.
Technical Solution
- 1
Designed a dimensional data model (Star Schema) optimized for reporting and ad-hoc analysis.
- 2
Implemented Row-Level Security (RLS) to restrict data access based on user roles and contract permissions.
- 3
Created pre-aggregated summary tables for common queries to improve dashboard performance.
- 4
Published a 'Data User Guide' with sample queries and best practices for the analytics team.