Analyticado
Centralised analytics hub with ~100 monthly active users
Summary
Analyticado made trusted analytics easier to find. Dashboards, metadata, and usage signals sit in one searchable hub, supporting roughly 100 monthly active users and roughly a tenfold lift in engagement compared with the previous scattered entry points.
Context
Internal / Enablement
What I built
Analyticado became the organisation's main place to find analytics: Looker dashboards and other outputs in one searchable site. Custom search, connections to Looker's APIs, embedded charts, and screens built for clarity meant analytics use rose about tenfold with roughly 100 active users each month, the default place to discover dashboards and reports. Plain language and layout supported adoption. Pipelines load Looker metadata, curated spreadsheets, and usage events; database design and internal privacy rules governed what metadata could show.
Skills demonstrated
- •Used storytelling and UX clarity to help stakeholders understand and adopt analytical content
- •Managed expectations by aligning site functionality with stakeholder needs
- •Designed interactive, intuitive visual interfaces that highlighted trends and improved findability
- •Applied visual design principles (layout, hierarchy, typography) to enhance usability
- •Built ingestion and transformation processes pulling Looker metadata, curated sheets, and analytics events
- •Demonstrated familiarity with JSON and CSV formats when handling Looker and Google Analytics data
- •Designed normalised BigQuery tables (looker_users, looker_user_activity, looker_explore_fields, looker_dashboard_elements) with proper entity separation
- •Applied 3NF principles by separating user data from activity data, linked via user_id
- •Applied code management and CI/CD principles in Python-based pipelines
- •Used structured code patterns and reusable modules for maintainability
- •Ensured metadata usage aligned with privacy rules and internal content policies
Impact
- ●~100 monthly active users
- ●10x increase in analytics engagement
- ●One-stop search for all analytics resources
- ●Shaped landings with analytics stakeholders so discovery matched real behaviour