data-analyst

Analyze McDougall Energy data to produce KPI dashboards and executive summaries.

1|Updated Aug 27, 2025
One-click install
npx skills add https://github.com/bmadigan/ask-my-doc --skill data-analyst-bmadigan
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-analyst
Source: https://github.com/bmadigan/ask-my-doc/tree/main/.claude/skills/data-analyst
Command: npx skills add https://github.com/bmadigan/ask-my-doc --skill data-analyst-bmadigan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps data leaders translate messy operational data into concise, business-ready insights, enabling faster, more informed decisions.

Core Features & Use Cases

  • Segment KPI Overview: Quickly assess performance across Residential, Commercial, and Retail segments with key volume, revenue, and profitability metrics.
  • Data Quality Checks: Identify nulls, inconsistencies, and gaps to ensure reliable analyses before KPI reporting.
  • Storytelling & Recommendations: Deliver executive summaries with actionable recommendations tailored to operations leadership.

Quick Start

Ask me to build KPIs, dashboards, and data-quality health checks for the McDougall Energy dataset.

  • Example prompt: "Show me the top 5 segments by revenue in the last 12 months and highlight any data quality issues."
  • I will respond with a concise executive summary, KPI table, and recommended actions.

Frequently Asked Questions about data-analyst

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate KPI dashboards from SQLite data in a Laravel environment?

To generate KPI dashboards from SQLite data in Laravel, you can analyze read-only data using Laravel models connected to database/database.sqlite to extract volume, revenue, and profitability metrics across business segments.

Can I run data quality checks to identify nulls and gaps before building KPI reports?

Yes, you can run data quality checks to identify nulls, inconsistencies, and gaps within your SQLite database to ensure reliable analysis before generating KPI reporting and executive summaries.

What's the best way to analyze residential, commercial, and retail segment performance?

The best way to analyze residential, commercial, and retail segment performance is to query segment-specific volume and revenue metrics, producing concise executive summaries with tailored operational recommendations.

How do I turn raw operational data into actionable business insights?

You turn raw operational data into actionable business insights by applying read-only analysis to your dataset, identifying key performance indicators, and delivering decision-ready outputs with storytelling and recommended actions.

Do I need specific database models to perform read-only data analysis?

Yes, you need existing Laravel models mapped to your SQLite database tables to perform read-only data analysis, enabling the extraction of reliable operational metrics without modifying the underlying data.

What limitations should I consider when analyzing data with a SQLite database?

When analyzing data with a SQLite database, consider that it is designed for read-only analysis within a local Laravel environment, meaning it may not support concurrent write operations or highly scalable enterprise database queries.