E-1537739

Developing Microsoft SQL Data 2016 Models • E-learning

Tananyag szintje
Közepes
Tananyag hossza
13 óra 57 perc
Elérhető képzési nyelvek
  • Magyar
Képzési forma
Személyre szabott ajánlatot szeretnél?
Kollégáink készséggel állnak rendelkezésedre, hogy segítsenek a neked megfelelő megoldás kialakításában.
Ajánlatot kérek

Tematika

Module 0: Developing SQL Data Models
  • Overview: Developing SQL Data Models
Module 1: Introduction to Business Intelligence and Data Modeling
  • Overview: Introduction to Business Intelligence and Data Modeling
  • Lesson 1: Overview of Business Intelligence and Data Models
  • Lesson 2: Microsoft Business Intelligence Platform
  • Lab 1: Exploring a Business Intelligence Solution
Module 2: Creating Multidimensional Databases
  • Overview: Creating Multidimensional Databases
  • Lesson 1: Introduction to Multidimensional Analysis
  • Lesson 2: Data Sources and Data Source Views
  • Lesson 3: Cubes
  • Lesson 4: Overview of Cube Security
  • Lesson 5: Configuring SSAS
  • Lesson 6: Monitoring SSAS
  • Lab 2: Creating a Multidimensional Database
Module 3: Working with Cubes and Dimensions
  • Overview: Working with Cubes and Dimensions
  • Lesson 1: Configuring Dimensions
  • Lesson 2: Defining Attribute Hierarchies
  • Lesson 3: Implementing Sorting and Grouping for Attributes
  • Lesson 4: Slowly Changing Dimensions
  • Lab 3: Working with Cubes and Dimensions
Module 4: Working with Measures and Measure Groups
  • Overview: Working with Measures and Measure Groups
  • Lesson 1: Working with Measures
  • Lesson 2: Working with Measure Groups
  • Lab 4: Configuring Measures and Measure Groups
Module 5: Introduction to MDX
  • Overview: Introduction to MDX
  • Lesson 1: MDX Fundamentals
  • Lesson 2: Adding Calculations to a Cube
  • Lesson 3: Using MDX to Query a Cube
  • Lab 5: Using MDX
Module 6: Customizing Cube Functionality
  • Overview: Customizing Cube Functionality
  • Lesson 1: Implementing Key Performance Indicators
  • Lesson 2: Implementing Actions
  • Lesson 3: Implementing Perspectives
  • Lesson 4: Implementing Translations
  • Lab 6: Customizing a Cube
Module 7: Implementing a Tabular Data Model by Using SQL Server Analysis Services
  • Overview: Implementing a Tabular Data Model by Using SQL Server Analysis Services
  • Lesson 1: Introduction to Tabular Data Models in SQL Server Analysis Services
  • Lesson 2: Creating a Tabular Data Model
  • Lesson 3: Using a SQL Server Analysis Services Tabular Model in an Enterprise BI Solution
  • Lab 7: Implementing a Tabular Data Model in SQL Server Analysis Services
Module 8: Introduction to Data Analysis Expressions (DAX)
  • Overview: Introduction to Data Analysis Expressions (DAX)
  • Lesson 1: DAX Fundamentals
  • Lesson 2: Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
  • Lab 8: Using DAX to Enhance a Tabular Data Model
Module 9: Performing Predictive Analysis with Data Mining
  • Overview: Performing Predictive Analysis with Data Mining
  • Lesson 1: Overview of Data Mining
  • Lesson 2: Creating a Custom Data Mining Solution
  • Lesson 3: Validating a Data Mining Model
  • Lesson 4: Connecting to and Consuming a Data Mining Model
  • Lab 9: Using Data Mining to Support a Marketing Campaign
Tematika (PDF)