This case study documents the complete implementation of an AI-powered Conversational Business Intelligence platform developed by DeTLeng. The project demonstrates how a real-world e-commerce dataset can be transformed into a production-ready analytics solution by combining Data Engineering, Business Intelligence, Artificial Intelligence, and cloud technologies.
Rather than building another dashboard, the objective was to enable business users to ask questions in natural language while receiving trusted answers generated directly from analytical business models stored in Google BigQuery. The implementation follows a layered Data Engineering approach consisting of Raw, Staging, and Analytics layers, followed by a custom-built DeTLeng MCP Server, FastAPI backend, OpenAI integration, and a live AI chatbot deployed on the web.
The project began with the publicly available Brazilian Olist E-Commerce Dataset, which contains nine CSV files representing customers, orders, products, payments, sellers, reviews, and geographical information. Instead of using the dataset directly for reporting, the complete Data Engineering lifecycle was implemented.
The CSV files were imported into Google BigQuery, organized into Raw, Staging, and Analytics layers, and transformed into reusable business models using SQL. Once the Analytics Layer was complete, a custom DeTLeng MCP Server was developed to expose approved Business Intelligence tools. A FastAPI backend and OpenAI integration were then added, allowing users to interact with the analytics layer through a conversational AI chatbot.
Import a real-world dataset into Google BigQuery.
Design a layered Data Engineering architecture.
Build reusable analytical business models.
Develop a custom DeTLeng MCP Server.
Integrate OpenAI through FastAPI.
Deploy the application on Render and deliver a production-ready conversational analytics experience.
Before importing any data, each dataset was studied to understand its business purpose, relationships, and analytical value. This business understanding formed the foundation for the entire Data Engineering process.
IAM permissions, authentication, and service accounts were configured to enable secure access for backend services while maintaining proper governance throughout the implementation.
Raw datasets were cleaned to remove inconsistencies and prepare reliable source data.
Data types, naming conventions, and inconsistent values were standardized across all datasets.
Duplicate records were reviewed and quality checks were applied before analytics processing.
This layer separates technical data preparation from business analytics, creating cleaner and more maintainable transformation logic.
Raw Layer was never modified. It preserves the original imported datasets exactly as received.
Every transformation, validation, cleaning, and standardization was performed inside the Staging Layer before analytical modelling.
Build dashboards first, then expect business users to search for answers manually.
Connect Artificial Intelligence directly to the governed Analytics Layer and let users ask questions naturally.
Artificial Intelligence never communicates directly with operational or analytical tables.
Only predefined Business Intelligence tools are exposed through the MCP Server.
Every response is generated from validated analytical models stored inside Google BigQuery.
Directs every user request to the correct Business Intelligence service.
Verifies secure communication between connected components.
Invokes approved MCP Business Intelligence tools and processes responses.
Converts technical outputs into clear, business-friendly responses.
OpenAI understands the user's natural language question and determines the required action.
Analytical requests are securely routed to the appropriate approved Business Intelligence tool.
OpenAI transforms validated business results into clear, accurate, and easy-to-understand explanations.
Raw and Staging layers remain isolated from Artificial Intelligence, protecting operational data and engineering processes.
Only approved analytical models are exposed through the DeTLeng MCP Server for Business Intelligence and AI.
Every AI response is generated from validated, governed, and business-ready information rather than raw operational records.
Environment variables keep API keys and cloud credentials protected outside the source code.
GitHub source code is automatically deployed as a live backend service running on the internet.
Render exposes secure API endpoints that allow the website to communicate with backend services.
Cloud configuration, runtime settings, and deployment management are handled centrally.
Business users interact using everyday language without writing SQL or navigating dashboards.
Every response is generated from governed analytical models through approved Business Intelligence tools.
Enterprise analytics becomes conversational, immediate, and accessible directly from the web.
www.detleng.com
Data Engineering • ETL • Analytics • Business Intelligence
insights.detleng.com
Research • Articles • Knowledge Hub
casestudy.detleng.com
Projects • Implementations • Success Stories
inteligencia.detleng.com
Knowledge • Insights • Applied Intelligence
agents.detleng.com
AI Agents • Automation • Intelligent Workflows
© DeTLeng Ecosystem
DeTLeng Ecosystem
Data Engineering • AI Agents • Automation • Applied Intelligence
Transform Complexity into Clarity • Transform Information into Understanding • Transform Knowledge into Value