Developing SQL 2016 Data Models (SSAS) Certification Training Course

Download Course Contents

Developing SQL 2016 Data Models (SSAS) 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.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Introduction to Business Intelligence and Data Modeling
  • 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
Live Online Training (Duration : 24 Hours)
Group Training 1100 Per Participant Incl. Official Courseware
06 - 08 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 06 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 2200 1300 + If you accept merging of other students. Incl. Official Courseware
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 24 hours. We can offer you an Ultra-Fast Track for 12 hours for only USD 1,040

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 United States Aug-2019 https://youtu.be/KzDaHOUoIV4

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


The Fee includes:
  • Official courseware
  • Testing Via Qubits
  • Remote Labs
Yes, Koenig Solutions is a Microsoft Learning Partner