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...
by Dalia Fernandes | Apr 18, 2023 | EPM - Enterprise Performance Management, Spreadsheets, Technology and Trends, The Multidimensional View, Uncategorized
Little more than 5 years ago, prospects would balk at the idea of working with business solutions in the Cloud. Does anyone else remember? Putting key company information, especially financials, into the “Cloud” was considered too risky. In addition, it...
