Data & AnalyticsTechnologyPlatinum

Design a BI architecture for self-service analytics.

Business Intelligence Architect

dbt, Looker, Metabase, Tableau

expertv5.0

Best for

▸Design dimensional models and star schemas for SaaS metrics like MRR, churn, and cohort analysis
▸Build semantic layers in dbt or LookML that standardize metric definitions across teams
▸Architect self-service analytics platforms using Looker, Tableau, or Metabase with governed KPI frameworks
▸Implement data mesh patterns with domain-specific data products and distributed ownership

What you'll get

▸Detailed dimensional model specifications with fact and dimension tables, grain definitions, and SCD type recommendations
▸dbt semantic layer YAML configurations with metric definitions, dimensions, and business logic
▸KPI framework documentation showing metric hierarchies, calculation formulas, ownership, and target setting methodologies

Expects

Business requirements including key metrics to track, data sources available, current BI tool landscape, and organizational analytics maturity level.

Returns

Comprehensive BI architecture blueprints including dimensional models, semantic layer definitions, KPI frameworks, and implementation roadmaps with specific dbt or BI tool configurations.

What's inside

“You are a Business Intelligence Architect. You design enterprise analytics platforms that transform raw data into trustworthy, discoverable, actionable intelligence while maintaining governance and performance at scale. - Replace verbose BI strategy with concrete architectural patterns: dimensional ...”

Covers

What You Do DifferentlyMethodologyWatch For

Not designed for ↓

×Building raw data pipelines or ETL processes (that's data engineering)
×Creating ML models or predictive analytics (that's data science)
×Basic dashboard creation without architectural governance
×Ad-hoc data analysis or one-off reporting requests

SupaScore

86.63▼

Research Quality (15%)

8.85

Prompt Engineering (25%)

8.85

Practical Utility (15%)

8.55

Completeness (10%)

8.25

User Satisfaction (20%)

8.7

Decision Usefulness (15%)

8.5

Evidence Policy

Standard: no explicit evidence policy.

business-intelligencedimensional-modelingsemantic-layerdbtlookertableaumetabasekpi-frameworkdata-meshself-service-analyticsstar-schemadata-warehouse

Research Foundation: 8 sources (4 books, 3 official docs, 1 industry frameworks)

This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.