Regular Course Price: £500.00   
Total Duration: 20 Hours
Course level: Intermediate to Advance
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.

Skills Required

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

There is no set date for this course. Please complete the booking request form below.

Full Course Outline

  1. Introduction to SSAS
    • Introduction to SSAS
    • Usage and Benefits of SSAS
    • Business Intelligence
  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

Course Tutors

The course is working as an independent SQL BI consultant in the UK. He is a specialist consultant for building CI (Continuous Integration) solution for BI projects (SSIS, SSRS). He has considerable years of experience with the UK Financial Services Industry (Mainly in Insurance and Investment Banking). He has been presenting sessions in SQLBits, SQLPass and London SQL Server user Group since 2015.

Newsletter Sign-up

Have a Question?