Implementación OLAP Utilizando SQL Server 2005 (40 horas)

Objetivo:

Capacitar a los asistentes en la utilización efectiva de las herramientas contenidas en la plataforma Microsoft SQL Server 2005 para el desarrollo de soluciones BI. El curso está estructurado desde los conceptos generales de BI hasta la implementación de cubos complejos y su explotación.

Tópicos:

1 Understanding Business Intelligence and Data Warehousing
    * Introducing Business Intelligence
    * Reviewing Data Warehousing Concepts
    * The Purpose of a Data Warehouse
    * The Structure of a Dimensional Database
    * A Fact Table
    * Dimension Tables

2 Understanding OLAP and Analysis Services
    * Understanding OLAP
    * Consistently Fast Response
    * Metadata-Based Queries.
    * Spreadsheet-Style Formulas
    * Understanding Analysis Services
    * Analysis Services and Speed
    * Analysis Services and Metadata
    * Analysis Services Formulas
    * Analysis Services Tools

3 Building Your First Cube
    * Exploring Business Intelligence Development Studio
    * Examining the Contents of an Analysis Services Project
    * Exploring Menu Commands
    * Preparing to Create a Cube
    * Reviewing the Analysis Requirements
    * Creating a New Analysis Services Project
    * Creating a Cube
    * Using the Cube Wizard Without a Data Source
    * Reviewing the Cube Structure in the Cube Designer
    * Generating a Schema
    * Using the Schema Generation Wizard
    * Loading Data into the Relational Schema
    * Processing and Browsing a Cube
    * Deploying and Processing a Cube
    * Browsing a Cube

4 Designing Dimensions
    * Reviewing the Data Warehouse Structure
    * Building a Standard Dimension
    * Adding a Data Source
    * Creating a Data Source View
    * Using the Dimension Wizard
    * Deploying a Dimension
    * Changing Attribute Properties
    * Working with a Time Dimension
    * Modifying a Data Source View
    * Creating a Time Dimension
    * Working with Role-Playing Dimensions
    * Creating a Parent-Child Dimension
    * Adding an Employee Dimension
    * Totaling Data for Non–Leaf-Level Data
    * Managing Levels within a Parent-Child Dimension

5 Designing Measure Groups and Measures
    * Adding Measure Groups to a Cube
    * Building a Cube
    * Changing Properties for Measure Groups and Measures
    * Specifying Dimension Usage
    * Browsing Multiple Measure Groups
    * Aggregating Semiadditive Measures
    * Adding a Measure Group to an Existing Cube
    * Using a Semiadditive Aggregate Function
    * Calculating Distinct Counts
    * Creating Simple Calculations
    * Adding a Calculation to a Cube
    * Applying Conditional Formatting

6 Working with a Finance Measure Group
    * Designing an Account Dimension
    * Working with Account Intelligence
    * Using Unary Operators
    * Aggregating by Account
    * Designing Nonadditive Financial Measures
    * Creating a Nonadditive Measure

7 Designing Aggregations and Hierarchies
    * Understanding Aggregation Design
    * Using the Aggregation Design Wizard
    * Inspecting Aggregations
    * Changing Partition Counts
    * Adding Attributes to the Aggregation Design
    * Designing User Hierarchies
    * Adding a User Hierarchy
    * Aggregating User Hierarchies
    * Optimizing Aggregations
    * Using the Query Log
    * Viewing Usage Data
    * Using the Usage-Based Optimization Wizard

8 Using MDX
    * Creating Tuple-Based Calculated Members
    * Creating an MDX Calculation for Percent of Total
    * Creating an MDX Calculation for Percent of Parent.
    * Querying with MDX
    * Executing MDX Queries
    * Working with Basic MDX Queries
    * Designing Custom Members
    * Creating a Calculated Member Using a Set-Based Function
    * Creating Cumulative Calculations
    * Working with MDX Scripts
    * Managing the Sequence of Calculations
    * Adding a Script Assignment
    * Developing Key Performance Indicators
    * Comparing Cube Values to Goals
    * Using MDX Expressions with Key Performance Indicators

9 Exploring Special Features
    * Defining Dimension Relationships
    * Using a Referenced Relationship Type
    * Using a Many-to-Many Relationship Type
    * Supporting Currency Conversions
    * Localizing Cubes
    * Adding Translations
    * Browsing Translations
    * Organizing Information with Folders and Perspectives
    * Organizing Measures
    * Using Perspectives

10 Interacting with Cubes
    * Implementing Actions
    * Using Standard Actions
    * Linking to Reports
    * Adding Drillthrough
    * Using Writeback
    * Write-Enabling a Dimension
    * Dynamically Adding Members to a Dimension
    * Modifying the Cube Structure for Writeback
    * Writing Values Back to a Cube 

Track IT
Entrenamiento y capacitación

Huerfanos 786 Oficina 910 Piso 9
Santiago de Chile.
Teléfono: (56)(2)5824530

Envíenos sus consultas y cometarios a:

Asesores de Capacitación:

Asesor Capacitación

Patricia Falcon

Solange Cerda

Consultas

Contacto