Business Intelligence with SQL Server 2008 R2 (SSAS, SSIS, SSRS) Training Course
Node ID: 15475
Duration
35 hours
Requirements
No requirements but any previous experience with SQL and databases will be highly beneficial.
Public Course Dates
Can't find a course date that suits your needs below?
Then just submit a public course date request now!
And we will organize the training at a location and date to suit you.
Request Public Course Date >>
Then just submit a public course date request now!
And we will organize the training at a location and date to suit you.
Request Public Course Date >>
| Date | Venue | Price | ||
|---|---|---|---|---|
| 2012-06-11 09:30 | Manchester | From 1800 to 4500 GBP Check! | ||
| 2012-06-11 09:30 | London, Westbourne Grove | From 1800 to 4500 GBP Check! | ||
| 2012-07-02 09:30 | Bristol, Temple Gate | From 1800 to 4500 GBP Check! | ||
| 2012-07-09 09:30 | London, Westbourne Grove | From 1800 to 4500 GBP Check! | ||
| 2012-07-17 09:30 | Manchester | From 1800 to 4500 GBP Check! | ||
| 2012-07-31 09:30 | Manchester | From 1620 to 4050 GBP Check! | ||
| 2012-08-20 09:30 | Bristol, Temple Gate | From 1620 to 4050 GBP Check! | ||
| 2012-08-20 09:30 | London, Westbourne Grove | From 1620 to 4050 GBP Check! | ||
| 2012-09-03 09:30 | Manchester | From 1620 to 4050 GBP Check! | ||
| 2012-09-10 09:30 | London, Westbourne Grove | From 1620 to 4050 GBP Check! |
Overview
Learn SQL Server Business Intelligence from the ground up using SQL Server 2008 R2. SSAS, SSIS, SSRS are covered in this full immersion 5-day course.
Course Outline
Introduction to SQL Server 2008 Business Intelligence
What is Business Intelligence?
Business Intelligence and SQL Server 2008
Data Warehouse vs Data Mart
Multidimensional databases
OLAP vs OLTP
SSAS (SQL Server Analysis Services)
UDM
The Cube
Dimensions and Measures
Schemas, Dimensions and Fact Table
BIDS
The Dimension Wizard
Translations and Localization
Designers and Wizards
Storage, caching and partitioning
MDX
Data Mining
Using SSIS with SSAS
Performance and Availability
SSRS with SSAS
SharePoint integration
SSIS (SQL Server Integration Services)
ETL and SSIS
Packages
Control Flow
Workflow
Constraints
Data Flows
Variables
Containers
Transactions
Errors and Debugging
Logging
Slowly Changing Dimensions
Deploying a Package
Security
Scripting
Best Practices
SSRS (SQL Server Reporting Services)
The tools and the architecture
Creating SSRS projects
Controls
Types of reports (tabular, list, matrix)
Expressions
Global collections
Groups and Totals
Parameters
Sorting a report
The Tablix data region
Charts and Gauges
Caching
Subscriptions
Deploying reports
Security
APIs
RS Web Service
Custom Assemblies
