Erkenningsnummer: DV.O105732

Praktische business intelligence voor de KMO

Leden die tewerkgesteld zijn in het onderwijs of bij de overheid betalen 710 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.
SQL Server Reporting Services (SSRS)
- Creating a Basic Report
  - Creating a Report Server Project
  - Setting Up Connection Information
  - Defining a Query for the Report
  - Adding a Table Data Region
  - Previewing the Basic Report
- Adding Grouping, Sorting, and Formatting to a Basic Report
  - Opening the Tutorial Project
  - Adding a Group
  - Adding a New Column
  - Sorting the Detail Data
  - Adding a Subtotal
  - Applying Formatting and Style
  - Publishing the Updated Report
- Adding Parameters to a Basic Tabular Report
  - Creating a Report Server Project for the Parameter Tutorial
  - Adding Parameters to Filter by Date
  - Adding a Single Value Parameter with an Available Values List
  - Adding a Multivalue Parameter with Select All
  - Adding a Parameter to Control Row Visibility
  - Adding a Parameter to Pass to a Drillthrough Report
- Setting Permissions in Reporting Services
  - Setting System-level Permissions on a Report Server
  - Setting Item-level Permissions on a Report Server
  - Setting Permissions on Specific Items
- Creating a Data-Driven Subscription
  - Creating a Sample Subscriber Database
  - Modifying the Report Data Source Properties
  - Defining a Data-Driven Subscription
- Creating a Report Model
  - Creating a New Report Model Project
  - Defining a Data Source for Your Report Model
  - Defining a Data Source View for Your Report Model
  - Defining a Report Model
  - Publishing a Report Model Project
- Accessing the Report Server Web Service Using Visual Basic or Visual C#
  - Creating the Web Service Client Project
  - Adding a Web Reference
  - Accessing the Web Service
  - Running the Application (VB/VC#)
Analysis and Monitoring with Performance Point Server
- What is Performance Point Server?
- Creating Scorecards
- Creating Dashboards
- Creating KPI’s (Key Performance Indicators)
- Analysis with the Analytical Chart
- Analysis with the AnalyticalGrid
- Analysis with Excel 2007