• Venue
  • Register
  • FAQs
  • Contact
  • Time Zone

SSAS Multidimensional and MDX

Batch Price From £500 (approx. $617 USD) View Dates & Prices
Total Duration: 20 Hours
Course level: Intermediate to Advanced
Delivery Method: Instructor Led Classroom Training
Certification: Certificate of Completion will be provided after completing the course.

Course Overview

This course is for BI Developers and DB professionals responsible for preparing data for multidimensional analysis.

This course helps students on how to design and develop SQL Server Analysis Service Databases. It covers dimensional modeling, development of dimensions and development of cubes.

Students will also learn to apply business logic in the cube using calculations, named sets and KPI.

This course also cover some of the Advanced features like implementing security for different users of analysis service.

Requirements

Knowledge about SQL Server and Data Warehouse concepts. Our Database Design with Microsoft SQL Server and SQL Server Integration Services (SSIS) Training Courses cover all of the prerequisites.

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes
Time Zone:
There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later.

Course Content

  1. Introduction to SSAS
    • Introduction to SSAS
    • Usage and Benefits of SSAS
    • Business Intelligence
    • OLAP VS OLTP
  2. Dimensional Modelling
    • Basics of Dimensional Modelling
    • Creating a Data Source
    • Different types of modelling
    • Creating a CUBE using wizard
    • Schema generation
    • Data Source View
    • Named calculations
    • Named queries
  3. Dimension Development -1
    • Create dimension using wizard
    • Dimension designer
    • Attributes
    • Implementing a Date dimension
    • Unknown Member
    • Attribute properties
  4. Dimension Development -2
    • Best practises – customization
    • User hierarchies
    • Parent child hierarchy
    • Attribute relationship
    • Translations
    • Development tasks
  5. CUBE Development -1
    • Cube Wizard
    • Cube Designer
    • Measure properties
    • Aggregate functions
    • Role playing dimension
    • Additional measures
    • Dimension usage
  6. CUBE Development -2
    • Aggregations
    • Perspectives
    • Translations
    • Cube Development Tasks
  7. Calculations – Basic
    • Calculations overview
    • Calculations Designer
    • Calculation Tools
    • Formula
    • Calculation to Sum
    • Testing a calculation
    • Functions
    • Color and font expressions
  8. Calculations – Advanced
    • Calculated members of dimension
    • Named sets
    • Key performance indicators
  9. Administrative Tasks
    • Deployment using SSDT
    • Deployment wizard
    • Storage wizard
    • Processing options
  10. Security
    • User security
    • Dimension security
    • Testing security
    • Multiple roles
    • Default member
    • Cell level security
    • Administrative security
  11. Advanced Analysis Service
    • Partitions
    • Writeback
    • Referenced Relationship
    • Many-Many Relationship
  12. Introduction to MDX
    • Basics of MDX
    • MDX VS SQL
    • Usage of MDX
    • Tuples and Sets
    • Axes , Rows and Columns
    • Cell Properties
    • MDX Functions
    • Hierarchies in MDX
    • Hierarchy Navigation

Share This Course

Newsletter Sign-up

Have a Question?