20466 – Implementing Data Models and Reports with Microsoft SQL Server

 

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.

 

Ver calendario

 

26 mayo, 2017

Empower

La misión de Ulearn es brindar soluciones de capacitación para profesionales de TI, que se traduzca en optimización de sus habilidades para una mayor eficiencia.

mail [email protected]
tel
+598 98 410 014

Redes Sociales

linkedin