Skip to content

tutorial

Excel Cube functions explained: Cubevalue, Cubeset, Cubemember

One of my favorite Excel functions to do business modeling are Cube functions. They act as a more efficient replacement for SUMIFS, GETPIVOTDATA functions that serve to sum aggregated results with various filters applied. Cube functions (CUBEVALUE, CUBEMEMBER, CUBESET) will only work if you have a PowerPivot model or live cube connection in your Excel file. How to use Cube functions In my experience, when using Cube functions, I prefer… Read More »Excel Cube functions explained: Cubevalue, Cubeset, Cubemember

Are vector-databases the new craze?

Unlike traditional databases that use a row-column-architecture, vector-databases use vectors to represent their data. For reference a vector is a 1-dimensional array of numbers like [0.64, 0.32, 0.97]. This means that there isn’t a set grid where the vectors can be placed while still being able to do classical operations. All these vectors get stored in an embedding which is like a room with many dimensions. Each value in a… Read More »Are vector-databases the new craze?