About

Imported from personamanagmentlayer/pcl (stdlib/domains/business-intelligence-expert/SKILL.md). Install upstream with npx skills add personamanagmentlayer/pcl --skill business-intelligence-expert. Copyright stays with the author.

Business Intelligence Expert

Name: business-intelligence-expert
Author: personamanagmentlayer

Build comprehensive business intelligence solutions including data warehouses, ETL pipelines, interactive dashboards, and analytical reporting systems.

Learning Objectives

Master business intelligence platforms and architectures
Understand data warehousing and ETL processes
Implement reporting and dashboard solutions
Apply data visualization best practices
Navigate OLAP and multidimensional analysis

Prerequisites

Understanding of database systems and SQL
Knowledge of data modeling concepts
Familiarity with reporting tools
Experience with data analysis and metrics

Core Concepts

Business Intelligence Architecture

End-to-end BI systems including data sources, ETL processes, data warehouses, OLAP cubes, reporting layers, and visualization tools that transform raw data into actionable business insights.

Data Warehousing

Centralized repositories that consolidate data from multiple sources using dimensional modeling (star/snowflake schemas), providing historical data storage optimized for analysis and reporting.

ETL (Extract, Transform, Load)

Processes for extracting data from source systems, transforming it for consistency and quality, and loading it into data warehouses with scheduling, error handling, and data validation.

Reporting & Dashboards

Interactive visualizations and reports that present key performance indicators, trends, and insights to stakeholders with drill-down capabilities, filters, and real-time or scheduled updates.

OLAP & Analytics

Online Analytical Processing enabling multidimensional analysis through operations like slice, dice, drill-down, roll-up, and pivot for exploring data from various business perspectives.

Best Practices

Data Warehouse Design

Use dimensional modeling (star/snowflake schemas)
Define clear business processes and grain
Implement slowly changing dimensions (SCD)
Use surrogate keys for dimension tables
Optimize for query performance
Document data lineage and definitions
Plan for scalability and growth

ETL Development

Implement robust error handling
Maintain data quality checks
Use incremental loading when possible
Log all transformations and errors
Implement idempotent processes
Monitor execution times and performance
Document transformation logic

Dashboard Design

Focus on key metrics and KPIs
Use appropriate visualization types
Provide context with comparisons
Enable drill-down capabilities
Optimize load times
Design for mobile viewing
Follow data visualization best practices

Performance Optimization

Pre-aggregate common queries
Implement partitioning strategies
Use columnarvstore indexes
Cache frequently accessed data
Optimize ETL schedules
Monitor query performance
Balance real-time vs batch processing

Anti-Patterns

Poor Practices

Copying transactional database design to warehouse
No data quality validation in ETL
Over-complicated transformations
Building dashboards without user input
Ignoring data governance
No documentation of metrics
Poor naming conventions
Mixing operational and analytical workloads

Common Mistakes

Not understanding business requirements
Creating too many dashboards
Using wrong chart types
Slow-running queries in dashboards
No version control for BI artifacts
Inadequate testing of ETL jobs
Ignoring data security and access control
Not monitoring BI system performance

Reference Documentation

Detailed material lives alongside this skill and is read on demand:

Code Examples — Data Warehouse Core System, ETL Pipeline System, Dashboard & Visualization System

Resources

BI Platforms

Tableau - Visual analytics platform
Power BI - Microsoft BI solution
Qlik Sense - Associative analytics
Looker - Modern BI platform
MicroStrategy - Enterprise BI
Domo - Cloud BI platform

Data Warehouse Solutions

Snowflake - Cloud data warehouse
Amazon Redshift - AWS data warehouse
Google BigQuery - Serverless data warehouse
Azure Synapse - Analytics service
Teradata - Enterprise data warehouse

ETL Tools

Informatica - Enterprise ETL
Talend - Open-source ETL
Apache Airflow - Workflow orchestration
dbt - Data transformation tool
Fivetran - Automated data pipelines

Learning Resources

Kimball Group - Dimensional modeling
TDWI (Transforming Data with Intelligence)
Gartner BI & Analytics research
Data Warehousing Institute

Standards & Methodologies

Kimball Methodology
Inmon Methodology (Corporate Information Factory)
Data Vault 2.0
CRISP-DM for analytics

Part of the PCL Standard Library - Master business intelligence systems and transform data into actionable insights for strategic decision-making.

CONGRATULATIONS! This is skill #100, completing the PCL Standard Library with comprehensive coverage across all major business and technology domains!

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/personamanagmentlayer-pcl-business-intelligence-expert/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

personamanagmentlayer-pcl-business-intelligence-expert.ocm.jsonjson

{
  "ocm": "1",
  "id": "personamanagmentlayer-pcl-business-intelligence-expert",
  "kind": "skill",
  "name": "business-intelligence-expert",
  "description": "Build comprehensive business intelligence solutions including data warehouses, ETL pipelines, interactive dashboards, and analytical reporting systems. Use when the user mentions BI, data warehousing, star or snowflake schemas, OLAP cubes, ETL/ELT pipelines, dashboards, KPIs, or analytical reporting.",
  "publisher": "personamanagmentlayer",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "general"
    ],
    "tags": [
      "skill-md",
      "bi",
      "business-intelligence",
      "data-warehouse",
      "reporting",
      "dashboards",
      "data-visualization",
      "analytics",
      "olap",
      "skills-sh"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Build comprehensive business intelligence solutions including data warehouses, ETL pipelines, interactive dashboards, and analytical reporting systems. Use when the user mentions BI, data warehousing, star or snowflake schemas, OLAP cubes, ETL/ELT pipelines, dashboards, KPIs, or analytical reporting."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "skills.sh",
      "repository": "https://github.com/personamanagmentlayer/pcl",
      "path": "stdlib/domains/business-intelligence-expert/SKILL.md",
      "ref": "HEAD",
      "url": "https://github.com/personamanagmentlayer/pcl/blob/HEAD/stdlib/domains/business-intelligence-expert/SKILL.md",
      "key": "personamanagmentlayer/pcl/stdlib/domains/business-intelligence-expert/SKILL.md"
    },
    "allowed_tools": [
      "Read",
      "Write",
      "Bash",
      "WebSearch"
    ]
  },
  "instructions": "# Business Intelligence Expert\n\nBuild comprehensive business intelligence solutions including data warehouses, ETL pipelines, interactive dashboards, and analytical reporting systems.\n\n## Learning Objectives\n\n- Master business intelligence platforms and architectures\n- Understand data warehousing and ETL processes\n- Implement reporting and dashboard solutions\n- Apply data visualization best practices\n- Navigate OLAP and multidimensional analysis\n\n## Prerequisites\n\n- Understanding of database systems and SQL\n- Knowledge of data modeling concepts\n- Familiarity with reporting tools\n- Experience w",
  "cost": {
    "context_tokens": 1252
  }
}

Fetch it by URL: GET /api/v1/registry/personamanagmentlayer-pcl-business-intelligence-expert/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.