Call : (+91) 99 8080 3767
Mail : info@EncartaLabs.com
EncartaLabs

SQL Server 2017 - SSAS Multidimensional Databases

( Duration: 3 Days )

The SQL Server 2017 - SSAS Multidimensional Databases training course provides skills to administer, design, and build multidimensional databases using SQL Server Analysis Services (SSAS).

By attending SQL Server 2017 - SSAS Multidimensional Databases workshop, delegates will learn to:

  • Describe the components, architecture, and nature of a BI solution
  • Implement a logical design for a data warehouse
  • Create a multidimensional database with analysis services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX syntax
  • Customize a cube
  • Use data mining for predictive analysis

  • At least 2 years' experience of working with relational databases
  • Designing a normalized database
  • Querying with Transact-SQL is helpful but is not required

COURSE AGENDA

1

Introduction to Business Intelligence and Data Modeling

  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform
2

Designing and Implementing a Data Warehouse

  • Logical Design for a Data Warehouse
  • Physical Design for a Data Warehouse
3

Creating Multidimensional Databases

  • Introduction to multidimensional analysis
  • Creating data sources and data source views
  • Creating a cube
  • Overview of cube security
  • Configure SSAS
  • Monitoring SSAS
4

Working with Cubes and Dimensions

  • Configuring dimensions
  • Define attribute hierarchies
  • Sorting and grouping attributes
  • Slowly Changing Dimensions
5

Working with Measures and Measure Groups

  • Working with measures
  • Working with measure groups
6

Introduction to MDX

  • MDX fundamentals
  • Adding calculations to a cube
  • Using MDX to query a cube
7

Customizing Cube Functionality

  • Introduction to Business Intelligence
  • Implementing key performance indicators
  • Implementing actions
  • Implementing perspectives
  • Implementing translations
8

Performing Predictive Analysis with Data Mining

  • Overview of Data Mining
  • Creating a Custom Data Mining Solution
  • Validating a Data Mining Model
  • Connecting to and Consuming a Data-Mining Model
  • Using the Data Mining add-in for Excel

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top