• phone icon +44 7459 302492 email message icon support@uplatz.com
  • Register
0- - 0
Job Meter = High

Developing SQL 2016 Data Models (SSAS)

30 Hours
Online Instructor-led Training
USD 2800
Developing SQL 2016 Data Models (SSAS)  course and certification
318 Learners

About this Course
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.

-----------------------------------------------------------------

Developing SQL 2016 Data Models (SSAS)

Course Details & Curriculum

1. Introduction to Business Intelligence and Data Modeling

  • Introduction to Business Intelligence
  • Microsoft Business Intelligence Platform

2. Create Multidimensional Databases

  • Introduction to Multidimensional Analysis
  • Create Data Sources and Data Source Views
  • Cubes
  • Overview of Cube Security
  • Configure SSAS
  • Monitoring SSAS

3. Working Cubes and Dimensions

  • Configure Dimensions
  • Define Attribute Hierarchies
  • Implementing Sorting and Grouping Attributes
  • Slowly Changing Dimensions

4. Working with Measures and Measure Groups

  • Working with Measures
  • Working with Measure Groups

5. Introduction to Multidimensional Expressions (MDX)

  • MDX Fundamentals
  • Add Calculations to a Cube
  • Use MDX to Query a Cube

6. Customize Cube Functionality

  • Implement Key Performance Indicators
  • Implement Actions
  • ImplementPerspectives
  • Implement Translations

7. Implement a Tabular Data Model by Using Analysis Services

  • Introduction to Tabular Data Models
  • Create a Tabular Data Model
  • Use an Analysis Services Tabular Model in an Enterprise BI Solution

8. Introduction to Data Analysis Expression (DAX)

  • DAX Fundamentals
  • Using Dax to create Calculated Columns and Measures in a Tabular Data Model

9. Perform Predictive Analysis with Data Mining

  • Overview of Data Mining
  • Create a Custom Data Mining Solution
  • Validate a Data Mining Model
  • Connecting to and Consume a Data Mining Model
  • Using the Data Mining add-in for Excel

-----------------------------------------------------------------

 


Didn't find what you are looking for?  Contact Us

course.php