Project 06
AI-Powered Business Intelligence & Performance Analysis
An AI-assisted reporting and analysis environment designed to interpret business performance, acquisition channels, e-commerce data and marketing results and turn them into structured insights.
The problem
Performance data sits in separate tools: the store, analytics, ad platforms, email and finance sheets. Answering what happened and why means pulling from all of them and lining the numbers up by hand.
What I built
A dashboard that brings these sources into one database and shows revenue, marketing spend, acquisition channels and targets side by side. Every view can be compared with the previous period or the same period last year, and with the plan.
Where AI fits
An assistant reads the same data through a read only tool interface (MCP). It can list the tables and run a query, and nothing else. Questions such as which channel drove last month's change are answered from the numbers in the database, not from guesses.
Running it
Data syncs on a schedule, and each view shows when its data was last refreshed. The dashboard is self hosted behind a login.
- How it starts
- A person requests an analysis or report.
- Where results go
- A person, through structured reports and analysis.