OLAP and Business Intelligence Tutorials

OLAP Tutorials – Free Download:

PARIS Technologies  features a set of exercises designed to introduce you to the fundamentals of OLAP by using step-by-step procedures to create an OLAP model. These example steps use PARIS’s OLAP product PowerOLAP, but you’ll find that the concepts of CubesDimensions, Slices, multidimensionality, etc., that are demonstrated using PowerOLAP are representative of OLAP in general.

 

To follow these exercises download PowerOLAP:

Download OLAP
Once installed, follow the tutorials below.

OLAP Tutorials

You can also follow the PowerOLAP Quick Start Exercises and access other related videos on the PARISTech TV YouTube Channel

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

More Articles on OLAP & Business Intelligence

Infographic: Business Analyst vs. Data Scientist

Business Analytics vs. Data Science “Business analytics” and “data science” — are they basically interchangeable terms, or entirely separate professional pursuits? There’s certainly overlap on the topic of Big Data and using data to...

Seeing Value in OLAP Anew: OLAP and Hadoop

OLAP and Hadoop: A Great Pairing OLAP continues to be a relevant and exciting technology, most recently in pairing OLAP and Hadoop. As we are OLAP.com, we have ALWAYS seen the value of OLAP technology. We admit OLAP has been a bit out of style the last few years. Some...

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.

Excel is Not a one Stop Shop for your Data Needs

“There’s nothing inherently wrong with spreadsheets; they’re excellent tools for many different jobs. But data visualization and data communication is not one of them.” – Bernard Marr We couldn’t agree more with what Bernard is saying in his article, “Why You Must...

Human Resources, Making BIG Strides in Business Analytics

Human Resources is beginning to pull ahead in the Business Analytics world. One thing is certain, if you want to run a successful business, you need to hire the right people to help you get there. Who is in charge of recruiting and hiring your team members?...