OLAP and Business Intelligence Tutorials
I. Download Free OLAP Software
To follow these exercises download PowerOLAP:
II. OLAP Tutorials
You can also follow the PowerOLAP Quick Start Exercises and access other related videos on the PARISTech TV YouTube Channel
OLAP Cube Modeling
*One additional note about these Quick Start exercises: these steps explain how to construct a model by working entirely with the PowerOLAP product’s “modeler.” Note that—especially if you are an administrator or power user—you will not build Cubes (business models) only by these steps. Instead, many Cube features (Meta Data) and the actual figures you work with (Fact Data) will likely come from another source and will therefore be built by using an integration capability (OLAP Exchange®, in PowerOLAP) to reach logic in, for example, and ERP or general ledger package. That said, the concepts and the steps covered in these pages and videos should be very helpful as they convey how to use, customize and advance your OLAP models. These skills, in turn, will enable you to vastly increase the potential business uses and benefits of using an OLAP modeling tool like PowerOLAP at your firm.
Latest Blogs
Hot
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.