"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"
Brian Leek, Data Analyst, May 2022
This course has been written to give delegates with existing skills in Data Warehousing with SQL Server a framework of best practises.
Delegates will gain a deep understanding of Cubes, Star Schemas, and Data Mining, using SQL Server 2012 Analysis Services (SSAS).
Because of the similarities in architecture and functionality between SQL Server 2012 , demonstrations and course labs will either be on SQL 2012 with any specific differences being demonstrated where necessary (usually in a short session at the end of each session).
Available as a public or closed course at our London training centre, delivered on-site as a bespoke, customised training course.
Our hands-on Advanced SSAS training course has been developed for real-world, commercial scenarios by our expert instructors.
See below for our detailed Advanced SQL Server 2012 Analysis Services training course syllabus. The course contains many SSAS tutorials based on real-world scenarios. If you have a technical question, please email[email protected].
By the end of this course you will gain:
1. Cube design best practises and security
2. A deep understanding of MOLAP / ROLAP / HOLAP
3. MDX Queries and Scripts
4. use XMLA to create, process and back-up Cubes
5. Effective Data Mining
3 types of date dimension
Role-playing dimensions
Many-to-many dimensions
Parent-child dimensions
Multiple measure groups
Measure group partitioning
Incremental cube updates
Slowly-changing dimensions – manually
and with SSIS
OLAP / MOLAP / ROLAP / HOLAP
Pro-active caching
Aggregation wizard
Query logs
Folders
Perspectives
MDX expressions
MDX queries
MDX scripts
Calculated measures
KPIs
MDX stored procedures
MDX in SSRS
Definitions
Building SSAS mining models with SSIS
Data mining visualisation with Excel 2013 (DM Plug-in)
DMX language content queries
DMX language prediction queries
DMX in SSRS
Drillthrough
Jumping to web sites from cubes
Jumping to SSRS reports from cubes
Write-back cubes
Overview of XMLA
Overview of AMO
Overview of PowerShell (SQL Server 2008 only)
Admin and user roles
Cube, dimension, and cell security
Visual totals
Backup and restore
"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"
Brian Leek, Data Analyst, May 2022
“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”
Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022
Sign up for the JBI Training newsletter to stay updated with world-class technology training opportunities, including Analytics, AI, ML, DevOps, Web, Backend and Security. Our Power BI Training Course is especially popular. Gain new skills, useful tips, and validate your expertise with an industry-leading organisation, all tailored to your schedule and learning preferences.
CONTACT
+44 (0)20 8446 7555
Copyright © 2023 JBI Training. All Rights Reserved.
JB International Training Ltd - Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS
Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us