Developing SQL Data Models [20768]

Introduction to Business Intelligence

The Microsoft business intelligence platform

Introduction to multidimensional analysis

Creating data sources and data source views

Creating a cube

Overview of cube security

Configuring dimensions

Define attribute hierarchies

Sorting and grouping attributes

Working with measures

Working with measure groups

MDX fundamentals

Adding calculations to a cube

Using MDX to query a cube

Implementing key performance indicators

Implementing actions

Implementing perspectives

Implementing translations

Introduction to tabular data models

Creating a tabular data model

Using an analysis services tabular model in an enterprise BI solution

DAX fundamentals

Using DAX to create calculated columns and measures in a tabular data model

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