Training Resources for:
SQL Server Business Intelligence
Total 5 record(s) available.
SQL Server Business Intelligence (Certificate) 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
A Classroom course provided by New Horizons Singapore in Singapore, Singapore
SQL Server Business Intelligence (Certificate)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
A Classroom course provided by New Horizons Computer Learning Centers of Pakistan in Karachi, Pakistan
SQL Server Business Intelligence (Certificate)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
A Classroom course provided by New Horizons Learning Center Philippines in Alabang, Makati City, Marikina City, Philippines
SQL Server Business Intelligence (Certificate)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
A Classroom course provided by New Horizons Malaysia in Kuala Lumpur, Kuantan, Penang, Petaling Jaya, Malaysia
Pages:- 1 2
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]
Tips:
Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.
|
|
|
