Microsoft/Developing SQL 2016 Data Models (SSAS)

Developing SQL 2016 Data Models (SSAS) Certification Training Course Overview

Developing SQL Data Models course imparts core skills to implement multidimensional databases using SSAS (SQL Server Analysis Services), and create tabular semantic data models for analysis. This SSAS training is meant for database professionals who create enterprise BI solutions in order to fulfil the role of a BI Developer. This SQL Data Model Development course is also suitable for power users, information workers and data analysts.

Test your current knowledge Qubits42

Developing SQL 2016 Data Models (SSAS) (24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1100
09 - 11 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

13 - 15 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1300
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Introduction to Business Intelligence and Data Modeling
  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform
  • Lab : Exploring a Data Warehouse
Module 2: Creating Multidimensional Databases
  • Introduction to multidimensional analysis
  • Course details Creating data sources and data source views
  • Creating a cube
  • Overview of cube security
  • Lab : Creating a multidimensional database
Module 3: Working with Cubes and Dimensions
  • Configuring dimensions
  • Define attribute hierarchies
  • Sorting and grouping attributes
  • Lab : Working with Cubes and Dimensions
Module 4: Working with Measures and Measure Groups
  • Working with measures
  • Working with measure groups
  • Lab : Configuring Measures and Measure Groups
Module 5: Introduction to MDX
  • MDX fundamentals
  • Adding calculations to a cube
  • Using MDX to query a cube
  • Lab : Using MDX
Module 6: Customizing Cube Functionality
  • Implementing key performance indicators
  • Implementing actions
  • Implementing perspectives
  • Implementing translations
  • Lab : Customizing a Cube
Module 7: Implementing a Tabular Data Model by Using Analysis Services
  • Introduction to tabular data models
  • Creating a tabular data model
  • Using an analysis services tabular model in an enterprise BI solution
  • Lab : Working with an Analysis services tabular data model
Module 8: Introduction to Data Analysis Expression ﴾DAX﴿
  • DAX fundamentals
  • Using DAX to create calculated columns and measures in a tabular data model
  • Lab : Creating Calculated Columns and Measures by using DAX
Module 9: Performing Predictive Analysis with Data Mining
  • Overview of data mining
  • Using the data mining add‐in for Excel
  • Creating a custom data mining solution
  • Validating a data mining model
  • Connecting to and consuming a data mining model
  • Lab : Perform Predictive Analysis with Data Mining
Download Course Contents

Request More Information

Course Prerequisites
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.

Upon Completion of this Course, you will accomplish following:-

  • Understand the architecture, components and features of BI solution
  • Use analytics of SSAS to create a multidimensional database
  • Deploy dimensions into a cube
  • Deploy measures and measure groups into a cube
  • Implement MDX syntax
  • Perform customizations on a cube
  • Create a tabular database
  • Query tables using DAX
  • Conduct predictive analysis using data mining

Give an edge to your career with Microsoft certification training courses. Students can join the classes for 20768 :Developing SQL Data Models ( SSAS) at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Student Feedback  (Check Koenig Feedback on Trustpilot)

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training ?

Student Name Country Month Feedback Rating
leandro Angola Aug-2019 https://youtu.be/KzDaHOUoIV4