SSAS Multidimensional and MDX

Batch Price From £500 (approx. $665 USD) View Dates & Prices

Total Duration: 20-Hour
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 SQL for Beginners 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.

Note: Online classes are usually delivered through Zoom video conferencing.

Course Content

Introduction to SSAS
- Introduction to SSAS
- Usage and Benefits of SSAS
- Business Intelligence
- OLAP VS OLTP
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
Dimension Development -1
- Create dimension using wizard
- Dimension designer
- Attributes
- Implementing a Date dimension
- Unknown Member
- Attribute properties
Dimension Development -2
- Best practises – customization
- User hierarchies
- Parent child hierarchy
- Attribute relationship
- Translations
- Development tasks
CUBE Development -1
- Cube Wizard
- Cube Designer
- Measure properties
- Aggregate functions
- Role playing dimension
- Additional measures
- Dimension usage
CUBE Development -2
- Aggregations
- Perspectives
- Translations
- Cube Development Tasks
Calculations – Basic
- Calculations overview
- Calculations Designer
- Calculation Tools
- Formula
- Calculation to Sum
- Testing a calculation
- Functions
- Color and font expressions
Calculations – Advanced
- Calculated members of dimension
- Named sets
- Key performance indicators
Administrative Tasks
- Deployment using SSDT
- Deployment wizard
- Storage wizard
- Processing options
Security
- User security
- Dimension security
- Testing security
- Multiple roles
- Default member
- Cell level security
- Administrative security
Advanced Analysis Service
- Partitions
- Writeback
- Referenced Relationship
- Many-Many Relationship
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

Related Courses

Newsletter Sign-up

First Name

Last Name

Email address

Have a Question?

Please read our frequently asked questions or contact us.

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT

Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom

UK: +44 (0)208 432 6218
USA: +1 610-234-7870
CANADA: +1 416-900-1211

WhatsApp: +44 0749 461 6045