Build OLAP Cubes With AI (Star Schemas in Practice) | From Excel to Product (Ep. 4)

Can an LLM build your OLAP layer? I have Claude write a Mondrian schema over a 250k-row Postgres database — and explain dimensional modelling as we go. Build your analytics layer with us: https://concepttocloud.com Episode 4 of "From Excel to Product." We turn the star schema into a working OLAP cube, with AI doing the heavy lifting: - What an OLAP cube is and why it's worth building - Having Claude generate a Mondrian schema from our model - Loading 250k pharma facts and querying the cube - Where AI helps with dimensional modelling — and where it doesn't Chapters: 0:00 The Postgres pharma database 5:08 Dimensions: geography, zip, state 7:42 Claude writes the Mondrian schema Saiku (open source): https://github.com/spiculedata/saiku Concept To Cloud builds critical systems for missions that can't afford to fail — MVPs, legacy modernisation, cloud, data and AI infrastructure. Ex-NASA engineers. Start a project: https://concepttocloud.com #OLAP #Mondrian #AI #dataengineering #analytics