Developing SQL Data Models
20768
Avanzado
DDBB SQL Server
18 horas
290 €
Convocatorias
Inicio - Fin
Horario  
No hay convocatorias abiertas
Descripción

Este curso esta destinado a gestores de bases de datos que tengan un rol de desarrollador de soluciones Business Intelligence. el curso nos enseña a implementar bases de datos multidimensionales medienta el uso de servicios de análisis de datos (SQL Server Analysis Services), así como a la creación de modelos tabulares de datos semánticos para análisis con SSAS.

Contenido
Course OutlineModule 1: Introduction to Business Intelligence and Data Modeling
  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform
Module 2: Creating Multidimensional Databases
  • Introduction to multidimensional analysis
  • Creating data sources and data source views
  • Creating a cube
  • Overview of cube security
Module 3: Working with Cubes and Dimensions
  • Configuring dimensions
  • Define attribute hierarchies
  • Sorting and grouping attributes
Module 4: Working with Measures and Measure Groups
  • Working with measures
  • Working with measure groups
Module 5: Introduction to MDX
  • MDX fundamentals
  • Adding calculations to a cube
  • Using MDX to query a cube
Module 6: Customizing Cube Functionality
  • Implementing key performance indicators
  • Implementing actions
  • Implementing perspectives
  • Implementing translations
Module 7: 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
Module 8: Introduction to Data Analysis Expression (DAX)
  • DAX fundamentals
  • Using DAX to create calculated columns and measures in a tabular data model
Module 9: 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
Itinerario
Este curso pertenece al itinerario: