A Distancia
Objetivo:
Este curso provee a los estudiantes con los conocimientos y técnicas necesarias para implementar una solución empresarial de Inteligencia de Negocios (BI).
Requisitos:
Tener experiencia trabajando con bases de datos relacionales incluyendo: diseño de base de datos normalizada, creación de tablas y relaciones y consultas con Transact-SQL.
Duración:
40 horas
Temario:
- Introduction to Business Intelligence and Data Modeling
- The Microsoft Enterprise BI Platform
- Planning an Enterprise BI Project
- Introduction to Multidimensional Analysis
- Creating Multidimensional Databases
- Creating Data Sources and Data Source Views
- Creating a Cube
- Overview of Cube Security
- Working with Cubes and Dimensions
- Configuring Dimensions
- Defining Attribute Hierarchies
- Sorting and Grouping Hierarchies
- Working with Measures and Measure Groups
- Working with Measures
- Working with Measure Groups
- MDX Fundamentals
- Adding Calculations to a Cube
- Using MDX to Query a Cube
- Customizing Cube Functionality
- Implementing Key Performance Indicators
- Implementing Actions, Perspectives and Translations
- 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)
- Enhancing a Tabular Data Model with DAX
- Introduction to Reporting Services
- Implementing Reports with SQL Server Reporting Services
- Creating a Report with Report Designer
- Grouping and Aggregating Data in a Report
- Showing Data Graphically
- Filtering Reports Using Parameters
- Automating Report Execution and Delivery
- Managing Report Security
- Managing Report Execution
- Subscriptions and Data Alerts
- Troubleshooting Reporting Services
- Delivering BI with SharePoint PerformancePoint Services
- Introduction to SharePoint Server as a BI Platform
- Introduction to PerformancePoint Services
- PerformancePoint Data Sources and Time Intelligence
- Reports, Scorecards, and Dashboards
- Performing Predictive Analysis with Data Mining
- Overview of Data Mining
- Creating a Data Mining Solution
- Validating a Data Mining Model
- Connecting to and Consuming Data Mining Data
Técnicas: Al finalizar el curso los estudiantes serán capaces de
- 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 Data Model in SQL Server Analysis Services.
- Use DAX to enhance a tabular model.
- Create reports with Reporting Services.
- Enhance reports with charts and parameters.
- Manage report execution and delivery.
- Implement a dashboard in SharePoint Server with PerformancePoint Services.
- Use Data Mining for Predictive Analysis.