CubeOne Hands-on Demo: Build a Complete FP&A Model from Scratch (Python + Excel)
💻 Get the Code: https://github.com/smilingsand/CubeOne
📄 Documentation: https://github.com/smilingsand/CubeOne/blo...
👉 Watch the 8-min Intro First: [ • CubeOne: The Python-Native OLAP Engine | E...
Welcome to the complete hands-on tutorial for CubeOne.
In this 1-hour deep dive, we go beyond the theory. I will walk you through the entire lifecycle of a CubeOne project by building a real-world "Sales Planning" scenario from scratch.
We will build two connected Cubes ("Price & Cost" and "Sales Plan"), load data via CSV, write TM1-style business rules, and finally perform data entry/write-back directly from Excel.
📝 *What we cover in this demo:*
1. **Server & Clients**: Starting the FastAPI server and configuring the Excel Add-in (xlwings).
2. **Modeling**: Creating Dimensions (Simple, User-defined, & CSV load) and Attributes.
3. **ETL**: Using the Server-side ETL engine to load bulk data from CSVs into Cubes.
4. **Rules Engine**: Writing business logic (e.g., `Sales = Price * Quantity`) to automate calculations.
5. **Planning (Write-back)**: Using `M1_WRITE` (DBRW) to input data from Excel and real-time calculation.
6. **Integration**: Connecting Power BI/Tableau directly to CubeOne's Apache Parquet storage.
Whether you are an FP&A professional looking for a TM1 alternative or a Python developer building data apps, this video is your comprehensive guide.
👇 *Prerequisites:*
Python 3.10+ installed
Basic knowledge of OLAP concepts (Dimensions, Cubes)
Excel (for the client interface)
⏱️ *Timestamps:*
00:00 - Intro & Demo Overview
00:15 - Server Start & Web Client Tour (FastAPI UI)
02:40 - Excel Client Configuration (xlwings & cubeone.ini)
03:18 - Scenario Setup: "Price & Cost" and "Sales Plan" Cubes
04:10 - Creating Dimensions & Attributes (API & CSV Load)
21:19 - Creating Subsets (Static & Dynamic Expressions)
26:56 - Creating Cubes & Views
31:25 - Loading Data from CSV (Server-side)
36:17 - Viewing Data: M1_VIEW_READ & Ad-hoc Views
42:42 - Writing Business Rules (Price * Units Calculation)
50:09 - Planning & Write-back: Input Data from Excel (M1_WRITE)
54:41 - Bonus: Power BI / Tableau Connection (Parquet)
56:24 - Extracting Data & Hierarchies via API
1:01:29 - Ending
#CubeOne #Python #FPandA #OLAP #FinancialModeling #Excel #xlwings #DataEngineering #OpenSource #PowerBI