BI Academy
Sign In
  • University Courses
  • News | Events
  • Top Experts
  • University Minors
  • FAQs
  • Forum
  • Register
Online Analytical Processing
Online Analytical Processing
Prof. Dr. Peter Lehmann
389

Description

About the Course

Online Analytical Processing, or OLAP, is an approach for business users to answering multi-dimensional analytical queries. OLAP is part of the broader category of Business Intelligence. Typical applications of OLAP include business reporting, for example for sales, marketing, management reporting, budgeting and forecasting, financial reporting and similar areas.

OLAP tools enable business users to analyze multidimensional data interactively from multiple perspectives. OLAP consists of three basic analytical operations: consolidation (roll-up), drill-down, and slicing and dicing.

  1. Consolidation involves the aggregation of data that can be accumulated and computed in one or more dimensions.
  2. Drill-down is a technique that allows users to navigate through the details.
  3. Slicing and dicing is a feature whereby users can take out (slicing) a specific set of data of the OLAP cube and view (dicing) the slices from different viewpoints.

Lessons

Online Analytical Processing

Table of Content

Unit 1: Installation Guide

Unit 2: Create a PivotTable

Unit 2: Create a PivotTable (Exercise)

Unit 3: Working with PivotTable Calculations

Unit 4: Working with PivotTable Calculations (Exercise) *

Unit 5: Data Analytics with PowerPivot

Unit 6: Working with PowerPivot and PivotTables

Unit 7: Creating Relationships with PowerPivot *

Unit 8: Data Analysis Expressions *

Unit 9: PowerPivot and DAX (Exercise) *

Take the course to view this content

Academy Theme © 2013
  • Impressum | Imprint
  • | Lecturer Login
  • | Get a BIA User (Students)