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
Scenario Maintenance – Analyzing the 2023 Rugby World Cup with OLAP Cube Technology
This is where OLAP technology can be especially helpful: we can demonstrate to ourselves how various scenarios generate different versions, all rooted in distinct assumptions. We can even consolidate all these assumptions into a single workbook, allowing us to work with these assumptions where the numbers exist or where actual calculations occur.
Dreamkillers-Analyzing the 2023 Rugby World Cup with OLAP Cube Technology
Unique perspectives can unveil insights that other technologies might not provide. In this case, I’ve employed OLAP to investigate a distinct facet of Rugby World Cup data—specifically, the concept of “dream killers.”
Retail OTB (Open to Buy) Planning with PowerExcel
OTB (Open-to-Buy) is a forward-looking metric based on future projections. In retail, it involves assessing current stock and estimating the exact amount of stock needed to achieve a predetermined target. It’s a blend of sales forecasting and stock planning, requiring accurate data and meticulous calculations.