SQL Server Business Intelligence (Certificate)

New Horizons Malaysia
Kuala Lumpur, Kuantan, Penang, Petaling Jaya, Malaysia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Formerly ’non-MOC’ course 7032, this course on SQL Server 2005 provides many new and enhanced business intelligence (BI) features designed to give you a competitive advantage.

Who Should Attend:
This course is intended for IT professionals.

At Course Completion:
After completing this course, students will be able to: - Explain the elements of SQL Server Business Intelligence. - Input and output data, script to branch control, and configure and deploy packages. - Create an account and work with measures. - Scale Analysis Services. - Use Client Reporting Tools and the web service. - Create custom OLAP clients. - Create queries using Analytical MDX. - Create and execute a package using Integration Services.


Outline: Top
Lesson 1: Quick Start Introduction
Integration Services
Analysis Services
Reporting Services
SQL Server Management Studio
Top
Lesson 2: Integration Services
Cleanse Data Input
Output to Multiple Destinations
Script to Branch Control
Lookup Fuzzy Values
Package Configuration and Deployment

Lesson 3: Core Analysis Services
Explore Analysis Services Objects
Create an Account (Parent-Child) Dimension
Create Measure Groups
Add Time
Work with Measures
Create AMO

Lesson 4: Analysis Services Scalability
Analysis Services Demonstrations
Cube Scalability
Aggregates in Natural Hierarchies

Lesson 5: Client Reporting Tools
Client Reporting Tools Demonstrations
Use URL Access in Applications
Use the Web Service
Top
Lesson 6: Custom OLAP Clients
Custom OLAP Clients Demonstrations
Render Cells
Render a Flattened Rowset

Lesson 7: Analytical MDX
MDX Queries: MDX vs. SQL
MDX Stored Procedures

Lesson 8: Data Mining
Browse Data Mining Models
Add DM Viewers to a Web Page

Lesson 9: Extending Integration Services
Create and Execute a Package
...''

Elements of this syllabus are subject to change.

Phone:+ 603-26946455

School Address:

3rd Floor, Wisma Thakurdas
Kuala Lumpur,16-1, Jalan Raja Laut 50350
Malaysia


Jobs & Resumes: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Houses & Roommates: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Travel Agencies: Kuala Lumpur,

Search other schools for SQL Server Business Intelligence training resources.

Designing Microsoft SQL Server 2005 Infrastructure and Services
Designing Security for Microsoft SQL Server 2005
Designing a High Availability Database Solutions Using Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005
SQL Server 2008
Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
implementing and maintaining microsoft sql server 2008 reporting services
oracle database 10g - introduction to sql
Oracle Database 10g: Program With PL/SQL
Oracle10g SQL and SQL Plus
Installing and Managing Microsoft Exchange Server 2007
Managing Messaging Security using Microsoft Exchange Server 2007
Recovering Messaging Servers and Databases Using Microsoft Exchange Server 2007
Monitoring and Troubleshooting Microsoft Exchange Server 2007
Designing a Messaging Infrastructure Using Microsoft Exchange Server 2007
Designing a High Availability Messaging Solution Using Microsoft Exchange Server 2007

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!