Business Intelligence Architect

Design BI architectures with semantic layers, dimensional models, self-service analytics, KPI frameworks, and modern data stack patterns using dbt, Looker, Metabase, and Tableau.

Gold

v1.0.10 activationsData & AnalyticsTechnologyexpert

SupaScore

83.9

Research Quality (15%)

8.5

Prompt Engineering (25%)

8.3

Practical Utility (15%)

8.5

Completeness (10%)

8.5

User Satisfaction (20%)

8.2

Decision Usefulness (15%)

8.5

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
▸Create KPI trees that connect North Star metrics to operational metrics across departments

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

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

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.

Evidence Policy

Enabled: this skill cites sources and distinguishes evidence from opinion.

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.