It is the technology behind many Business Intelligence (BI) applications. OLAP is a powerful technology for data discovery, including capabilities for limitless report viewing, complex analytical calculations, and predictive “what if” scenario (budget, forecast) planning.
We are loving this article by Neil Raden on diginomica.com, I'm Feeling Sentimental about OLAP and You Should Too. In it Raden makes the case that the OLAP tech that existed in the 90's plus the new strides that have been made in recent years as far as scale, speed,...
Business Intelligence is needed to know what really happened in the past, but you also need predictive analytics to optimize your resources to make better decisions and take actions for the future.
Check out this cool infographic! Submitted to OLAP.com by the folks at Business Intelligence 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...
FROM OUR SPONSORS
The Importance of Planning and Forecasting in BI
From PARIS Technologies
The budgeting and forecasting process for most organizations is long and tedious and occurs on an annual basis, at least. Companies try to do it more often to improve accuracy and aim to ultimately implement a procedure for continuous planning, rolling forecasts, and driver-based planning.
Unlike any other business process, budgeting and forecasting is unique because it is forward thinking. Business processes like accounting, inventory tracking, invoicing, shipping, etc. are based on actual events from the past and present.
This is a fundamental difference as it also defines how the data from these processes are managed. Essentially, actual events are captured as transactions in ERPs, supply chain systems, invoicing and accounting systems, etc., and data related to it is effectively stored in its databases. On the other hand, budgets and forecasts typically reside in spreadsheets where aggregate data is entered by several people in the organization.