Register Now for this Training



Current Promotions

PMP Exam Free Preview Session

May 28, 2013 - Tuesday @6:15pm and

June 11, 2013 - Tuesday @ 6:15 pm

 

 

 
 
 
 

Business Intelligence Using SQL Server


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

Course Contents: Using SQL Server for Strategic Business Intelligence

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


Course Objectives

With SQL Server 2008, 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 2008. 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 2008: 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.

 

Target Audience
  • 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 2008, 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:
6-10 participants

Course Outline

Day 1
Effective Decision Making
Introduction to Business Intelligence and SQL Server 2008
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


How to Register

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

 

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

Your Question:

Your Email:      

 

 

Intellisoft System Facebook Link Intellisoft System Linkedin Link Intellisoft System Youtube Link Intellisoft System Twitter Link Intellisoft System Blog Link

Course Enquiry

Select Your Course *
Course Date*
Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*  
Pass Type
No. of Participants*
Our Clients
Mindef Singapore Ministry of Manpower Nanyang Polytechnic National Heart Center Singapore National University Hospital NUS PSB Academy Richemont Standard Chartered Bank Singapore Polytechnic Singapore Land Authority StatsChipPac ST Electronics The RITZ Carlton At Sunrice AXA BNY Mellon Guthre HDB Johnson Control JTC Marina Bay Sands National Park Paypal Semdcorp Vodaphone Xilinx

 

Testimonial for PHP & MySql

I learnt how to create my own quizes, and manage a portal. The hands-on practice with instant trouble shooting with the training was very helpful. - Lee Teck Hong, Hwa Chong Singapore.

The training met my expectations. Each individual lesson was short, organized and easy to understand and do. I liked the interactive sessions the bost - Thomas Kong, Singapore

I liked the hands-on exercises, and was able to create a database driven application within the 3 days of the course - Judy Lim, ITE College East, Singapore

The greatest strength is the hands-on exercises & tips on using PHP & Mysql for real life projects - SIM University

I liked the clear instructions and guides to recommended sites - ABN AMRO N.V.

Everything is great about this workshop. I most liked the hands-on approach to PHP & MySQL database programming - Chung K Y, Temasek Polytechnic

 

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, Richemont, BHP Billiton, Science Centre, American Express, Standard Chartered Bank,  Estee Lauder, Amadeus and many more.




Register Now for this Training