Curso Microsoft SQL Server 2008 Business Intelligence Presencial

Descripción Curso Microsoft SQL Server 2008 Business Intelligence

El Curso Microsoft SQL Server 2008 Business Intelligence es presencial, se imparte en Madrid y tiene una duración de 45 horas.

La inteligencia de negocio (BI o Business Intelligence) hace referencia a una amplia variedad de aplicaciones y herramientas tecnológicas diseñadas para recopilar, almacenar y analizar datos de negocio y ser utilizados para guiar la toma de decisiones.

Estas tecnologías tienden a ampliar de manera dramática su alcance, llegando a todos los segmentos en los procesos de las organizaciones.

Temario Curso Microsoft SQL Server 2008 Business Intelligence

Module 1: Introduction to Microsoft SQL Server Analysis Services

·    Overview of Data Analysis Solutions

·    Overview of SQL Server Analysis Services

·    Installing SQL Server Analysis Services

Module 2: Creating Multidimensional Analysis Solutions

·    Developing Analysis Services Solutions

·    Creating Data Sources and Data Source Views

·    Creating a Cube

Module 3: Working with Cubes and Dimensions

·    Configuring Dimensions

·    Defining Attribute Hierarchies

·    Sorting and Grouping Attributes

Module 4: Working with Measures and Measure Groups

·    Working with Measures

·    Working with Measure Groups

Module 5: Querying Multidimensional Analysis Solutions

·    MDX Fundamentals

·    Adding Calculations to a Cube

Module 6: Customizing Cube Functionality

·    Implementing Key Performance Indicators

·    Implementing Actions

·    Implementing Perspectives

·    Implementing Translations

Module 7: Deploying and Securing an Analysis Services Database

·    Deploying an Analysis Services Database

·    Securing an Analysis Services Database

Module 8: Maintaining a Multidimensional Solution

·    Configuring Processing

·    Logging, Monitoring, and Optimizing an Analysis Services Solution

·    Backing Up and Restoring an Analysis Services Database

Module 9: Introduction to Data Mining

·    Overview of Data Mining

·    Creating a Data Mining Solution

·    Validating Data Mining Models

Module 10: Introduction to SQL Server 2008 Integration Services

·    Overview of SQL Server Integration Services

·    Using Integration Services Tools

Module 11: Developing Integration Services Solutions

·    Creating an Integration Services Solution

·    Using Variables

·    Building and Running a Solution

Módulo 12: Implementing Control Flow

·    Control Flow Tasks

·    Control Flow Precedent Constraints

·    Control Flow Containers

Módulo 13: Implementing Data Flow

·    Data Flow Sources and Destinations

·    Basic Data Flow Transformations

·    Advanced Data Flow Transformations

·    Data Flow Paths

Módulo 14: Implementing Logging

·    Overview of Integration Services Logging

·    Enabling and Configuring Logging

Módulo 15: Debugging and Error Handling

·    Debugging a Package

·    Implementing Error Handling

Module 16: Implementing Checkpoints and Transactions

·    Implementing Checkpoints

·    Implementing Transactions

Module 17: Configuring and Deploying Packages

·    Package Configurations

·    Deploying Packages

Module 19: Managing and Securing Packages

·    Managing Packages

·    Securing Packages

Module 20: Introduction to Microsoft SQL Server Reporting Services

·    Overview of SQL Server Reporting Services

·    Installing Reporting Services

·    Reporting Services Tools

Module 21: Authoring Basic Reports

·    Creating a Basic Table Report

·    Formatting Report Pages

·    Calculating Values

Module 22: Enhancing Basic Reports

·    Interactive Navigation

·    Displaying Data

Module 23: Manipulating Data Sets

·    Defining Report Data

·    Using Parameters and Filters

·    Using Parameter Lists

Module 24: Using Report Models

·    Creating Report Models

·    Using Report Builder

Module 25: Publishing and Executing Reports

·    Publishing Reports

·    Executing Reports

·    Creating Cached Instances

·    Creating Snapshots and Report History

Module 26: Using Subscriptions to Distribute Reports

·    Introduction to Report Subscriptions

·    Creating Report Subscriptions

·    Managing Report Subscriptions

Module 27: Administering Reporting Services

·    Reporting Server Administration

·    Performance and Reliability Monitoring

·    Administering Report Server Databases

·    Security Administration

·    Upgrading to Reporting Services 2008

Module 28: Programming Reporting Services

·    Querying for Server Information Using a Web Service

·    Automating Report Management

·    Rendering Reports

·    Creating Custom Code

Duración Curso Microsoft SQL Server 2008 Business Intelligence

45 Horas