Excel Data Analysis and Dashboard

What it solves

When Excel data is scattered across workbooks, has inconsistent field definitions, contains duplicates, or lacks a clear exploratory analysis path, this skill fits a lightweight BI workflow. It focuses on data cleansing, descriptive statistics, grouped comparisons, trend detection, and anomaly explanation, then packages the output into a reviewable conclusion dashboard. Typical inputs include business context, table material, target objects, constraints, and success criteria. Typical outputs include cleansed data, statistical summaries, comparison tables, conclusions, and next-step suggestions.

How it works

The skill follows the EASE method:
- Extract: define the scope, fields, and extraction rules.
- Assess: check missing values, duplicates, outliers, and other quality issues.
- Slice: split the data by dimensions and compare groups.
- Explain: interpret trends, differences, or possible causes of anomalies.
- Suggest: propose actionable next steps.

In practice, provide the scenario and key facts first, then request a specific module such as cleansing, comparison, or dashboarding. If the input is incomplete, list known facts first and ask the output to mark items as “to be confirmed.”

Boundaries

This skill is scoped to single-point Excel analysis and does not replace official publications, real-time data, or professional statistical audits. For important external deliverables, humans should review sample bias, business definitions, and conclusion reliability. Cross-system workflows, knowledge bases, or agent orchestration should be designed as a separate enterprise AI implementation.