Learn OLAP and Business Intelligence
What is OLAP and What are the Advantages?
OLAP is an acronym for Online Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.
It is quickly becoming the fundamental foundation for Intelligent Solutions including Business Performance Management, Planning, Budgeting, Forecasting, Financial Reporting, Analysis, Simulation Models, Knowledge Discovery, and Data Warehouse Reporting.
OLAP enables end-users to perform ad hoc analysis of data in multiple dimensions, thereby providing the insight and understanding they need for better decision making.
OLAP and Business Intelligence Terms
OLAP and Business Intelligence has a wealth of terms. Knowing these terms will make using your OLAP and/or BI software solution easier. It may also make it easier to troubleshoot and talk to IT folks when you need to.
Here is a list of the most commonly used OLAP and Business Intelligence terms.
Download Free OLAP Software
Our sponsor, PARIS Technologies, provided a set of exercises designed to introduce you to the fundamentals of OLAP by using step-by-step procedures to create an OLAP model.
The OLAP tutorials use PARIS’s OLAP product PowerOLAP, but you’ll find that the concepts of Cubes, Dimensions, Slices, multidimensionality, etc., that are demonstrated using PowerOLAP are representative of OLAP in general.
OLAP and BI Tutorials
OLAP and Database History
The history of databases starts from the pre-computer era where data was collected in the form of punch cards all the way to what we know now as computer programs that collect data for effective analysis and decision making.
OLAP is not a new concept and has persisted through the decades. As a matter of fact, the origin of OLAP technology can be traced to 1962. Kenneth Iverson introduced the base foundation of OLAP through his book “A Programming Language” (APL), which defined a mathematical language with processing operators and multidimensional variables.
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
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.
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.