BI Data Dashboard Generator

Problem

When you already have an Excel/CSV dataset and need to show trend, share, or KPI views to stakeholders, manually building charts and dashboard pages can be slow. BI Data Dashboard Generator targets this workflow: it reads a local data file, uses confirmed fields and aggregation rules, and outputs a static HTML dashboard that can be opened directly in a browser.

How it works

The skill first probes the data and lists available fields. Then it confirms dimensions, measures, chart types, and aggregation methods such as bar, line, pie, kpi_card, scatter, and table. After the configuration is assembled, it uses pandas, openpyxl, and pyecharts to generate a single-page HTML file with embedded CSS, JS, and an ECharts CDN. The default file name is {title}_{date}.html, the layout uses a responsive grid for PC and tablet, and the page includes a dashboard title, data update time, and chart area. If the file path is missing, a column does not exist, or a field has no valid data, it reports the available columns or asks for a better field instead of generating blindly.

Boundaries

It is best for cases where data fields are clear and the output is a lightweight static view or shareable page. It does not modify the original Excel file, start a web service, or perform complex data cleansing. The intended chart and metric logic should be confirmed in the conversation, so it does not guess business metric definitions.