Instructor Led Data Warehousing Training in United Kingdom

SQL Server 2005 Analysis Services SSAS This scenario-based presentation details how to use the Business Intelligence Development Studio (BIDS) to develop and deploy Analysis Services projects and to use the SQL Server Management Studio to manage the databases derived from these projects. Objectives: Upon completion of this presentation, the delegate should be competent to: - Build and deploy Analysis Services projects - Develop  more...

Data Warehousing Fundamentals training course This dimensional modelling techniques course is designed to answer questions, such as the following: - What is data warehousing? - What is a data mart? - What are the data modelling options? - What is Extract, Transform and Load (ETL)? - What are the terms and concepts specific to data warehousing and OLAP design? - How to plan and implement a data warehouse with high availability,  more...

Advanced SQL Server 2005 Integration Services SSIS for Developers As SSIS is mainly an Extract, Transform and Load (ETL) tool and since ETL has been accepted as being between 70-80% of the data warehouse maintenance challenge, this course is accordingly dedicated. After discussing advanced features of the SSIS control and data flow engines, delegates will be taught how to design, develop and implement an SSIS-based ETL system, accounting for some of the more  more...

SQL Server 2005 Integration Services SSIS Fundamentals This presentation provides detailed treatment of the following SQL Server 2005 Integration Services (SSIS) topics: - Creating and managing SSIS packages - Connecting to, querying and transforming disparate data sources - Scripting - Business Intelligence and data warehousing considerations - Event handling - SSIS problem determination - And the like. Prerequisites: At least six (6)  more...