Blog

Categories

Best Practices
OLAP & BI Solutions
Data management
Finance and Business Use Cases
Dashboards
Predictive Analytics

Subscribe

Get the latest on OLAP and Business Intelligence straight in your inbox.

FROM OUR SPONSORS

Featured Story

 

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.

CONTINUE READING

Latest Posts

Hot

Analyzing the 2023 Rugby World Cup with OLAP Cube Technology

Analyzing the 2023 Rugby World Cup with OLAP Cube Technology

In this article, we explore some “scenario planning” capabilities of cube technology by delving into the world of sports, specifically for the 2023 Rugby World Cup tournament. Using our product’s analytical tool (the front end you will see is PARIS Tech’s PowerExcel; the back end, Olation), we’ll examine historical data, team performances, “dream-killers,” and make predictions for the upcoming competition

read more
Infographic: 5 Signs You are in Excel Hell

Infographic: 5 Signs You are in Excel Hell

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.

read more
EPM in the Cloud…and Solving the DIY Instinct of Spreadsheet Users

EPM in the Cloud…and Solving the DIY Instinct of Spreadsheet Users

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 was natural to ask, How easily can I reach my data when it’s in the Cloud, as compared to reaching it in my local environment?
Accessing data through a browser seemed much shakier than simply double-clicking on

read more
If You Think OLAP is Obsolete…  Think Again!

If You Think OLAP is Obsolete… Think Again!

OK, so I’ll give nay-sayers of OLAP a little bit of credit, OLAP (historically) can be frustrating.  Especially when some implementations are hardly what we consider to be “online”.  Most of what people are calling OLAP technology is not really connected in a live way to the data source.  There is a batch process to update the data from relational source to a Proprietary OLAP cube.

read more
Excel is Not a One-stop Shop for your Data Needs

Excel is Not a One-stop Shop for your Data Needs

Excel is everywhere and it has proven to be a valuable resource to every company across the globe. The problem is that many companies are using spreadsheets as their main line of communication internally. Excel is great at displaying all of the raw data you could possibly dream of, just ask any Data Analyst, who eats, sleeps and dreams of never-ending spreadsheets.

read more
OLAP and Excel

OLAP and Excel

Excel reports are just not cutting in today’s world of even larger and more complex organizations. Thankfully, there is a solution that not only gives companies the capability to access large amounts of data at the speed in which there is no “waiting around” time, but it enhances the every day use of Excel. Let’s take a look at how this is possible.

read more
Take a Moment to Reconsider OLAP

Take a Moment to Reconsider OLAP

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,...

read more

Learn OLAP

Resources

Types of OLAP Systems

MOLAP, ROLAP, HOLAP... what's the difference? And modern OLAP for this century.

Learn more

Terms and Definitions

Learn all the terms you need to start your OLAP journey.

Learn more

History of OLAP and BI

Learn about the history of OLAP technology with this comprehensive inforgraphic

Learn more