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: