Cours M20768-C
Developing SQL Data Models

Doelstelling
  • 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
Inhoud

Introduction to Business Intelligence and Data Modeling

  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform

Creating Multidimensional Databases

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

Working with Cubes and Dimensions

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Implementing Sorting and Grouping Attributes
  • Slowly Changing Dimensions

Working with Measures and Measure Groups

  • Working with Measures
  • Working with Measure Groups

Introduction to MDX

  • Adding Calculations to a Cube
  • Using MDX to Query a Cube

Customizing Cube Functionality

  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations

Implementing a Tabular Data Model by Using Analysis Services

  • Introduction to Tabular Data Models
  • Creating a Tabular Data Model
  • Using an Analysis Services Tabular Data Model in an Enterprise BI Solution

Introduction to Data Analysis Expression (DAX)

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

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

Details

Duur
3 dagen
Deelnemers
8
Bestemd voor
IT-specialist
Voorkennis
  • Experience of querying data using Transact-SQL