Business Intelligence school training courses in Cleveland, OH (public, in-house or online)

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the Reporting Services management and administrative tools.

Objective :
After completing this course, students will be able to: - Describe SQL Server Reporting Services and its components. - Create a Reporting Services report. - Enhance a Reporting Services report. - Create and manipulate data sets. - U...

Full archival course description>>

This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Objective :
After completing this course, students will be able to: - Describe SQL Server Integration Services and its tools. - Create an Integration Services package. - Implement control flow in an Integration Services package. - Implement data flow in an Integration Services package. - Implement log...

Full archival course description>>

This course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube.

Objective :
After completing this course, students will be able to: - Describe how SQL Server Analysis Services can be used to implement analytical solutions. - Create multidimensional analysis solutions with SQL Server Analysis Services. - Implement dimensions ...

Full archival course description>>

Students Will Learn:Importing Excel and XML Data
Exporting SQL Server Data
Automating ETL Routines
Migrating SQL 2000 DTS packages
Designing Data Warehouses
Creating Cubes
Mining Data
Managing Cube Security

Description: This hands-on course walks students through the complete data warehousing and data mining process. Students will design and create data warehouses using Microsoft SQL Server 2005. Then the Business Intelligence Development Studio (BIDS) will be...

Full archival course description>>