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

Instructor - Led Online Training Fee For Both Group Training & 1-on-1 Training 1100
Group Training

03,04,05 May
09:00 AM - 05:00 PM CST
(8 Hours/Day)

07,08,09 Jun
09:00 AM - 05:00 PM CST
(8 Hours/Day)

GTR=Guaranteed to Run
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End


Available

Not Available

Booked By You

Classroom training is available in select Cities

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

  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform
  • Lab : Exploring a Data Warehouse
  • 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
  • Configuring dimensions
  • Define attribute hierarchies
  • Sorting and grouping attributes
  • Lab : Working with Cubes and Dimensions
  • Working with measures
  • Working with measure groups
  • Lab : Configuring Measures and Measure Groups
  • MDX fundamentals
  • Adding calculations to a cube
  • Using MDX to query a cube
  • Lab : Using MDX
  • Implementing key performance indicators
  • Implementing actions
  • Implementing perspectives
  • Implementing translations
  • Lab : Customizing a Cube
  • 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
  • DAX fundamentals
  • Using DAX to create calculated columns and measures in a tabular data model
  • Lab : Creating Calculated Columns and Measures by using DAX
  • 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

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.