OLAP BI Assistant

About the Project

A multi-agent Business Intelligence assistant designed for analyzing global retail sales data. This personal project leverages Claude AI and advanced prompt engineering to enable natural language OLAP queries, allowing users to generate KPIs, charts, and engage in conversational follow-ups without any SQL knowledge. The system supports comprehensive OLAP operations including Slice, Dice, Drill-Down, Roll-Up, Compare, Pivot, and Drill-Through, making complex data analysis accessible through intuitive conversations.

Tech Stack

Project Goal

Create an intelligent Business Intelligence assistant that allows users to query complex data from a given dataset/database using natural language. The system enables users to perform advanced OLAP operations and generate insights through conversational interactions with the data.

Client Requirements

This is a personal project designed to work with any given dataset/database. The system supports various OLAP operations (Slice, Dice, Drill-Down, Roll-Up, Compare, Pivot, Drill-Through) and provides conversational follow-ups for deeper analysis. Integration with Claude AI for natural language processing enables intuitive data exploration.