Course level: Intermediate to Advance
Total Duration: 20 Hours
Certification: Certificate of Completion will be provided after completing the course.

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

DatesPriceEnrol
30 Apr 2017 - 21 May 2017
4 Saturdays
£400 (normal price £500)Enrol Now
  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

Course Tutor

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?