Cursos > Curso Microsoft Sql Server 2008 Business Intelligence
Ficha Tecnica: Curso Microsoft SQL Server 2008 Business Intelligence
Tipo de Formacion: Cursos
Categorias: Cursos Informática e Información |
Modalidad de Curso: Cursos Presencial
Pais: España
Provincia: Madrid
Descripción Curso Microsoft SQL Server 2008 Business Intelligence
El Curso Microsoft SQL Server 2008 Business Intelligence es asistencial, es impartido 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
Comentarios:
Quieres comentar con tu login de Facebook este articulo?
