Agent skill · personamanagmentlayer
business-intelligence-expert
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.
What it needs
About 3k tokens when loaded.
What this skill does
Business Intelligence Expert 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. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills personamanagmentlayer/business-intelligence-expert