LOGO For Immediate Assistance Call 855-211-9361

1-3 day (9 HOUR TRAINING):

Creating OLAP Cubes: Use Data to Improve Business Performance


Call for availability 855-211-9361

Creating OLAP (Online Analytical Processing) cubes provides an easy way to explore and analyze your data to make informed business decisions. Whether you are creating your first OLAP cube or want to create better ones, join us for this 90-minute webinar and develop essential skills.

Course Overview

By the end of the class students will be able to:

  • Ways to assemble accurate, reliable, fast information about your business
  • Steps for creating an OLAP cube from start to finish
  • Keys to defining dimensions, hierarchies and attribute relationships
  • Essential techniques to organize and manipulate data using OLAP tools

Course Outline

  • Introducing an OLAP Cube in SQL Server Analysis Services

    • Comparing OLAP queries to relational queries
    • Reviewing the architectural requirements for Analysis Services
    • Modeling data for OLAP
  • Developing an OLAP Cube: Design a Foundation for Business Intelligence

    • Structuring data with a data source view
    • Defining dimensions, hierarchies and attribute relationships
    • Creating a cube and adding calculations
  • Deploying an OLAP Cube: Provide Access to Business Insights

    • Deploying a cube to the server
    • Browsing a deployed cube to test query behavior
    • Configuring cube security