Skill UI

Build formula-driven Excel dashboards from CSV/tabular sources, producing a single .xlsx with raw data and a dashboard sheet whose KPIs, charts, sparklines, and formatting refresh when the data changes. Ideal for KPI reports, analytics summaries, or executive dashboards.

Reviews Python + BigQuery pipelines to flag runaway costs, missing dry-run safeguards, unsafe backfills, write idempotency issues, and monitoring gaps, returning a structured report with exact function/line references for minimal fixes.

Structured pipeline for credit risk pre-loan modeling that loads and formats raw data, filters abnormal periods, trims high-missing/low-IV/high-PSI/high-correlation features, denoises via Null Importance, and exports an Excel cleaning report for review.

Automates GA4 reporting and property management via Composio’s Rube MCP, covering account/property discovery, standard/batch/pivot/funnel reports, and key event workflows so analysts can run repeatable queries without manual UI steps.

Provides systematic Power BI performance troubleshooting guidance covering model optimization, DAX design, report layout, and capacity diagnostics, plus tool-driven measurement tips for faster page loads, interactions, and query execution.

Guides Power BI visualization and UX decisions—capturing business context, selecting optimal charts, specifying layouts, color, typography, and interaction patterns to create accessible, insight-driven dashboards across audiences.

Helps implement optimized Power BI semantic models by analyzing the active model with MCP tools, then advising on star schemas, DAX, relationships, security, documentation, and performance best practices for reporting scenarios.