Articles on Best Practices in OLAP, Business Intelligence, Planning and Forecasting.
OLAP & BI Solutions
Finance and Business Use Cases
Get the latest on OLAP and Business Intelligence straight in your inbox.
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
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.
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.
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.
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.
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,...