Erkenningsnummer: DV.O105732

Ing. zoekt job

Integration (SSIS) en Analysis (SSAS)

Leden die tewerkgesteld zijn in het onderwijs of bij de overheid betalen 320 EURO

Programma

SQL Server Integration Services (SSIS)
- Creating a Simple ETL Package Tutorial
  - Creating the Project and Basic
  - Package
  - Adding Looping
  - Adding Package Configurations
  - Adding Logging
  - Adding Error Flow Redirection
- Adding features and functions
  - Implementing Data Flow
  - Implementing Control Flow
  - Implementing Logging
  - Deploying SSIS packages
- Other ETL tools out of the SQL Server2008 box
  - bcp
SQL Server Analysis Services (SSAS)
- Defining a Data Source View within an Analysis Services Project
  - In this lesson, you define a data source view within an Analysis Services project by using BI Development Studio
- Defining and Deploying a Cube
  - In this lesson, you define a cube and its dimensions by using the Cube Wizard, and then deploy the cube to the local instance of Analysis Services
- Modifying Measures, Attributes and Hierarchies
  - In this lesson, you improve the user-friendliness of the cube and incrementally deploy the related changes, processing the cube and its dimensions as needed
- Defining Advanced Attribute and Dimension Properties
  - In this lesson, you define a referenced dimension relationship, order attribute members by using composite keys, and define custom error handling
- Defining Relationships Between Dimensions and Measure Groups
  - In this lesson, you define a fact relationship for a degenerate dimension and define a many-tomany relationship
- Defining Calculations
  - In this lesson, you define calculated members, named sets, and scripts
- Defining Key Performance Indicators (KPIs)
  - In this lesson, you define Key Performance Indicators (KPIs)
- Defining Actions
- Defining Perspectives and Translations
  - In this lesson, you define views of a cube and translations of metadata
- Defining Administrative Roles
  - In this lesson, you define administrative and user roles