by Jack Guarneri | Oct 12, 2023 | Uncategorized
This video from our sponsor PARIS Tech compares Microsoft Excel’s PivotTable capabilities with the pivot table in PowerExcel. PivotTables are recognized for their ability to organize data effectively, but they are primarily designed for single-user productivity...
by Dalia Fernandes | Sep 25, 2023 | Business Planning, Data Analysis, OLAP, OLAP and Excel, Predictive Analytics, Sports Analysis, Strategic Dashboards, Technology and Trends, Uncategorized
If you’re a sports enthusiast with a penchant for rugby, then you’re in for a treat! 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...
by Dalia Fernandes | Sep 14, 2023 | Business Analytics, Business Budgeting, Business Planning, Data Analysis, OLAP, OLAP and Excel, Spreadsheets, Uncategorized
Top-down and Bottom-up budgeting methods co-exist in most companies. 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...
by Dalia Fernandes | Aug 31, 2023 | Business Planning, Data Analysis, OLAP, OLAP and Excel, Predictive Analytics, Sports Analysis, Strategic Dashboards, Technology and Trends, Uncategorized
One of the more vexing things to contend with in a business model is “version maintenance.” How many plan versions should we keep? How can we codify certain drivers that result in various premises? What if we want to compare one scenario against another…or numerous...
by Dalia Fernandes | Aug 21, 2023 | Business Planning, Data Analysis, OLAP, OLAP and Excel, Predictive Analytics, Sports Analysis, Strategic Dashboards, Technology and Trends, Uncategorized
A closer look at some rugby statistics in anticipation of the upcoming Rugby World Cup. The statistics are running through an OLAP model and the beauty of OLAP technology, often referred to as “cube technology,” lies in its ability to allow data to be viewed from...
by Dalia Fernandes | Aug 15, 2023 | Business Analytics, Business Budgeting, Business Planning, Data Analysis, OLAP, OLAP and Excel, Spreadsheets, Uncategorized
In FP&A in the retail industry, there is a concept of Open-to-Buy (OTB) planning. It is a challenging report to maintain in Excel and calculating it can be quite intricate. OTB (Open-to-Buy) is a forward-looking metric based on future projections. In retail, it...
