Developing SQL Data Models 3 days | | $1,785 PLUS TAX

This course is aimed at database professionals who fulfill a Business Intelligence (BI) developer role. Students will learn to implement multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models. Prerequisite:

TARGET AUDIENCE

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:

» Implementing multidimensional databases by using SQL Server Analysis Services
» Creating tabular semantic data models for analysis by using SQL Server Analysis Services
» The secondary audiences for this course are ‘power’ information workers/data analysts.

COURSE OBJECTIVES

After completing this course, students will be able to:

» Describe the components, architecture, and nature of a BI solution
» 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
» Implement a tabular database
» Use DAX to query a tabular model
» Use data mining for predictive analysis

COURSE OUTLINE

INTRODUCTION TO BUSINESS INTELLIGENCE AND DATA MODELING

» Introduction to Business Intelligence
» The Microsoft business intelligence platform
» Lab : Exploring a Data Warehouse

CREATING MULTIDIMENSIONAL DATABASES

» Introduction to multidimensional analysis
» Creating data sources and data source views
» Creating a cube
» Overview of cube security
» Lab : Creating a multidimensional database

WORKING WITH CUBES AND DIMENSIONS

» Configuring dimensions
» Define attribute hierarchies
» Sorting and grouping attributes
» Lab : Working with Cubes and Dimensions

WORKING WITH MEASURES AND MEASURE GROUPS

» Working with measures
» Working with measure groups
» Lab : Configuring Measures and Measure Groups

INTRODUCTION TO MDX

» MDX fundamentals
» Adding calculations to a cube
» Using MDX to query a cube
» Lab : Using MDX

CUSTOMIZING CUBE FUNCTIONALITY

» Implementing key performance indicators
» Implementing actions
» Implementing perspectives
» Implementing translations
» Lab : Customizing a Cube

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

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

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

Please call for dates

Your Email Address

Contact Us