The latest articles on Forem by Juan C. Del Monte (@juandelmonte). https://forem.com/juandelmonte https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3575198%2F54ddd8d9-1c21-4f42-9e12-81b9cc766e6a.png https://forem.com/juandelmonte en Juan C. Del Monte Mon, 20 Oct 2025 14:21:02 +0000 https://forem.com/juandelmonte/turning-pandas-dataframes-into-hypercubes-meet-cube-alchemy-hcj https://forem.com/juandelmonte/turning-pandas-dataframes-into-hypercubes-meet-cube-alchemy-hcj <p>🚀 I would like to share with you my last project, <a href="https://www.cube-alchemy.info/" rel="noopener noreferrer"><strong>Cube Alchemy</strong></a>: an open-source Python engine for semantic modeling, smart automation, and multidimensional analytics.</p> <p>It started as a way to make my data workflows less messy by turning dataframes into <em>reusable hypercubes</em>, letting you define dimensions, metrics, and queries declaratively.. all while automating the boring plumbing.</p> <p>Whether you’re a Python-loving analyst, a BI team craving flexibility, or a data org that dislikes vendor lock-in, Cube Alchemy is built to give you clarity, control, and a little magic.</p> <p>Highlights:</p> <p>🤖 Automates relationships and joins</p> <p>🧭 Declarative semantic modeling</p> <p>⚡ Interactive in notebooks and Python apps like Streamlit</p> <p>🧩 Filters, plotting, YAML catalogs, and query enrichment</p> <p>Open-source, flexible, and made for developers who want more than just dashboards — it’s for anyone who wants to shape analytics on their terms.</p> <p>💬 Feedback, ideas, or collabs are more than welcome — especially from anyone exploring open semantic layers or Python-native analytics.</p> python pandas stramlit opensource