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.

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

45 Horas