PMP Exam Prep Tips

Receive PMP Exam Preparation Tips & Project Management Articles

Master Trainer Vinai's
articles are published in books,
magazines & newspapers

Our article in The Straits Times

Learning For Life

Subscribe to our Learning for Life Newsletter & Get Interesting Articles & Training Updates!

 Email:
Name:

Other Courses

Find out most popular courses
available at Intellisoft Systems

Course Enquiry
Course Title*
Course Date*
Self / Company Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*
Number of Participants*

 

Our Clients

Large MNCs, Local Companies & SMEs have selected Intellisoft Systems as their Training Provider.

Some of our clients are M1, Bayer, 3M, DSO National Labs, OLAM International, National Healthcare Group, HP, NUS, ITE,  LTA, MOH and many more.

Home » IT Courses » MS SQL Server BI

Business Intelligence Using SQL Server


Course Duration: 3 Days - Full Time Course on SQL Server 2005

Course Contents: Using SQL Server for Strategic Business Intelligence

SDF Funding now Available for SME companies. Call 6296-2995 for Details.


With SQL Server 2005, you can now streamline your reporting, and derive increased benefits from advanced analysis, data mining and reporting services enterprise wide. Exploit the new features for Business Intelligence for your enterprise.

Course Synopsis:

  • This 3 days deep dive, hands on workshop focuses on companies looking to exploit the full features of SQL Server 2005. It will feature hands on sessions on understanding and using the Integration Services (SSIS), analysis features of SSAS, and the Reporting features of SSRS.

  • The objective of the workshop is to give you an in-depth understanding of the rich BI capabilities in SQL Server 2005: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) & SQL Server Reporting Services (SSRS), and make you aware of the advanced concepts in deployment, & implementation.

  • After this workshop, you would have gained the necessary skills and knowledge to build, manage and integrate Data Analysis, Data Mining and Advanced Reporting capabilities in your organization.

Course Agenda

Day 1
Effective Decision Making
Introduction to Business Intelligence and SQL Server 2005
Data Marts, Dimensional Modeling, Unified Dimensional Model
Introduction to Integration Services, SSIS Architecture
Creating, Building and Populating Data Marts
Migrating from DTS to SSIS

Day 2
SQL Server Analysis Services Overview
Creating Cubes
Analyzing Cube Content
Special features of OLAP Cubes
Writing MDX Queries, MDX Scripting
Data Mining
Creating Data Mining models,
Exploring with Data Mining
Upgrading or Migrating to SS Analysis Services

Day 3
Reporting Services Architecture
Report Creation using Report Builder
Using Reports Manager, Model Designer
Managing reports on the Report Server
Ad Hoc Reporting Considerations
Reporting with Excel Pivot Tables and Pivot Charts
Upgrading to Reporting Services
 

Who Should Attend:

  • Companies initiating a Business Intelligence Project
  • SMEs planning to deploy a database for operations, reporting or decision making
  • Companies currently on SQL Server 2000 and planning to migrate
  • Companies using Access, Excel, Crystal Reports, etc. for Reporting
  • Project managers, IT Product Leads, Database administrators and Programmers who are using SQL 2005, but are not aware of the full features, or are not using the rich feature set provided.

Certification:
Certificate of attendance would be given to participants.

Materials:
Notes in folders will be provided.

Class Size:
8-12 participants

Course Dates: Custom Courses schedule is available upon request.

Have a Question? Simply Write to us & Get Your Questions Answered.

Your Question:
Your Email:

Call (65) 6296-2995 or (65) 9877-3485 to enquire about the Microsoft SQL Server 2005 training course for Business Intelligence, or email to training@intellisoft.com.sg

Home | Contact Us | Join Us