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 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 Jack Guarneri | Jul 31, 2023 | Business Analytics, Business Budgeting, Business Planning, Data Analysis, OLAP, OLAP and Excel, Spreadsheets, Uncategorized
In this article, Gareth Jones from PARIS Technologies discusses the challenges faced by companies when managing their payroll and workforce planning. Payroll planning is crucial for businesses, but it is often difficult to optimize due to the limitations of...
by Blogger@olap | May 17, 2023 | Business Budgeting, Business Forecasting, Infographic, OLAP and Excel, Spreadsheets
Check out this cool infographic! Submitted to OLAP.com by the folks at PARIS Technologies. They’ve mapped here 5 warning signs that you and your professional team are living in Excel Hell. Perhaps it’s just been accepted that your Excel Hell is what it is,...
by Jessica Otero | Mar 3, 2023 | BI Solutions, Big Data, Business Analytics, Business Budgeting, Business Forecasting, Business Planning, Data Analysis, Data Visualization, Data Warehousing, OLAP, Predictive Analytics, Spreadsheets
“There’s nothing inherently wrong with spreadsheets; they’re excellent tools for many different jobs. But data visualization and data communication is not one of them.” – Bernard Marr We couldn’t agree more with what Bernard is saying in his article, “Why You...
by Jessica Otero | Mar 2, 2023 | Application/Data Integration, BI Solutions, Business Budgeting, Business Forecasting, Business Planning, Business Reporting, Data Analysis, Data Visualization, Data Warehousing, OLAP, OLAP and Excel
The Power of OLAP and Excel Should Excel be a key component of your company’s Business Performance Management (BPM) system? There’s no doubt how most IT managers would answer this question. Name IT’s top ten requirements for a successful BPM system, and they’ll...