Welcome to CourseHorse!

Valuable Rewards & Savings

40,000 Classes to Choose From

Verified Student Reviews

Prompt Customer Service

Fast & Secure Checkout

SQL Server 2008 Business Intelligence: Services

Hands On Technology Transfer, Inc. »
Price:
$2,595
12 seats left
Start date: Mon, Oct 20 9:00am - 5:00pm (5 sessions)
Other start dates (2)
Mon, Oct 20: 9:00am - 05:00pm
Tue, Oct 21: 9:00am - 05:00pm
Wed, Oct 22: 9:00am - 05:00pm
Thu, Oct 23: 9:00am - 05:00pm
Fri, Oct 24: 9:00am - 05:00pm
Location: Chelsea
Specific Address TBD
()
New York, New York
(Map)

Class Information

  • Class Level: Intermediate
  • Age Requirements: 21 and older
  • Average Class Size: 8

What you'll learn in this sql server training:

This hands-on course walks students through the complete data warehousing and data mining process using SQL Server. Students will design and create data warehouses, then use the Business Intelligence Development Studio (BIDS) to create SQL Server Integration Services (SSIS) routines to move records from a relational database into the data warehouse.

The complete course title is SQL Server 2008 Business Intelligence: Integration Services and Analysis Services 

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
Once the data warehouse is populated, the data will be explored using SQL Server Analysis Services (SSAS). BIDS will again be used to create cubes to support business decisions. Hands-on exercises will use the cubes to develop Key Performance Indicators (KPI) and custom performance measures. Additional exercises will demonstrate how to update and manage cubes. Analysis Service's support of data mining is also covered, and hands-on labs will configure data mining algorithms to search for patterns and trends in the data. In addition to using SSIS to support data warehouses, students will also complete labs that demonstrate how to use the ETL utility to move data in and out of SQL Servers.

This includes exercises that import and export data between Excel spreadsheets, Access databases, XML files, flat files and SQL Server. Techniques to clean data will also be demonstrated, such as finding duplicate records or performing look-ups in tables. Other exercises will merge data from multiple sources, as well as splitting data to multiple destinations. Troubleshooting and security configurations for these Business Intelligence services are incorporated throughout the course.

Course Prerequisites: Familiarity with database concepts and Windows desktop navigation. Attendance at 3-day SQL Programming course, or equivalent knowledge, is recommended but not required.

"This was one of the most productive and informative classes I have experienced in my 27 years in IT. The instructor is truly an expert in his field."– T.D., Rainmaker

Note: Classes do not have fixed location. Prior to each class they examine the geographical location of the enrolled students and then select a venue that will provide most convenient overall access for the students. Classes are held in hotel conference rooms and exact location is determined 2 weeks prior to the course date.

Refund & Cancellation Policy

Tuition includes all course materials. Students may withdraw before the second day of class to receive a 100% refund, provided course materials are returned to the instructor. Prorated refunds may be granted for withdrawals after the first day.

Price Guarantee

We promise that our prices are the same (or less) than prices on the school's website

Comprehensive

We centralize over 40,000 classes from vetted, high quality class providers

Verified Student Reviews

CourseHorse is the only place where you can read class reviews from verified students

Incredible Service

We're dedicated to supporting your learning goals every step of the way

Fast & Secure Checkout

Single-page checkout and powerful encryption make CourseHorse the place to book

Save on Every Class with CourseHorse

We give you back 5% of every class purchase, to encourage you to keep on learning!

Start Dates (2)

Start Date # of Sessions Price
5 $2,595 Book
5 $2,595 Book

Schedule:
Mon, Oct 20 9:00am - 5:00pm
Tue, Oct 21 9:00am - 5:00pm
Wed, Oct 22 9:00am - 5:00pm
Thu, Oct 23 9:00am - 5:00pm
Fri, Oct 24 9:00am - 5:00pm

Location:
Chelsea, Manhattan
Specific Address TBD
New York, New York

Map

Can't make these dates? Save to Wish List this class to find out first about new class dates.

Save to Wish List

Map

Google Map
Hands On Technology Transfer, Inc.
Chelsea
Specific Address TBD

New York, New York

All classes at this location

School: Hands On Technology Transfer, Inc.

Critical Characteristics of Effective Training

There are literally hundreds of IT training companies for you to choose from. Why should you choose Hands On Technology Transfer, Inc. (HOTT) above the rest? Here are nine critical characteristics that HOTT provides to assure success and remove your risk....

Read more about Hands On Technology Transfer, Inc. »

CourseHorse Approved School

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Ready to take this class?

Book Online
Or call 212-729-4088

Taking this class for work? Get exclusive perks & discounts for free.

Need help finding a class? Call 212-729-4088 or email [email protected]
Customer Service: 212-729-4088