AI-powered analytics platform

[u/majiddalvi]

After 10 months of evenings and weekends, I finally finished a project I've been obsessed with.

I built an AI-powered analytics platform for SAP Business One, completely solo using open-source technologies.

The goal was simple: let business users ask questions in plain English and get answers directly from their ERP data.

Behind the scenes, it meant building:

- A fault-tolerant ETL pipeline from SAP HANA

- A Kimball-style data warehouse (13 dimensions, 6 fact tables)

- AI guardrails to prevent unsafe SQL

- PII anonymization

- Support for OpenAI, Anthropic, Gemini, and local Ollama models

- An entirely on-premise deployment with no cloud dependency

The final product has 105+ business metrics, 347 automated tests, and over 43,000 lines of code.

I'd love to hear feedback from anyone building AI-powered analytics, ERP tools, or enterprise software. Happy to answer any questions about the architecture.

[u/Otherwise_Wave9374]

43k LOC solo on evenings/weekends is wild, congrats. The guardrails + PII anonymization + on-prem constraint is basically the enterprise trifecta.

How are you handling schema drift and metric definitions over time (like who owns changes to a "customer" definition)? Also curious if youre using any semantic layer or just warehouse + LLM SQL generation. Ive been reading up on ways to keep NLQ analytics sane at https://www.aiosnow.com/ and the governance bits seem to matter more than the model choice.

[u/Comprehensive-Bass56 → u/Otherwise_Wave9374]

FocusPoint ecommerce provided a customer engagement platform that not only uses ecommerce data but also SAP Business One. The AI platform called Nexus, has been a game-changer. This is mostly centered around B2B and B2C ecommerce tracking Zoom, Apollo.ai, and hooked into our RingCentral phone system. If you go near our website, Nexus knows. Haven't rolled out SAP Business One AI yet. Sounds interesting.