Finance & Business Use Cases
Applications of OLAP and Business Intelligence in Finance and Business
OLAP & BI Solutions
Finance and Business Use Cases
Get the latest on OLAP and Business Intelligence straight in your inbox.
Rugby fans, prepare to be exhilarated! PARIS Tech has teamed up with David Newton, a luminary in the world of finance and the founder of Newton Carmen, a prestigious Fractional CFO firm. Together, they've fashioned something extraordinary - an OLAP model tailored...
PARIS Tech has recently joined forces with David Newton, an esteemed figure from Newton Carmen, a renowned Fractional CFO firm. Together, they’ve crafted an extraordinary sports analysis OLAP model tailored specifically for the upcoming Rugby World Cup.
What happens it that first the Finance team creates the budget from the bottom up, and then senior management delivers top-down directives. Meeting those directives requires adjustment, often leading to a time-consuming and demoralizing cycle in Excel to complete the budget.
This is where OLAP technology can be especially helpful: we can demonstrate to ourselves how various scenarios generate different versions, all rooted in distinct assumptions. We can even consolidate all these assumptions into a single workbook, allowing us to work with these assumptions where the numbers exist or where actual calculations occur.
Unique perspectives can unveil insights that other technologies might not provide. In this case, I’ve employed OLAP to investigate a distinct facet of Rugby World Cup data—specifically, the concept of “dream killers.”
OTB (Open-to-Buy) is a forward-looking metric based on future projections. In retail, it involves assessing current stock and estimating the exact amount of stock needed to achieve a predetermined target. It’s a blend of sales forecasting and stock planning, requiring accurate data and meticulous calculations.