Training Course:SQL Server 2005 Analysis Services (SSAS)School/Trainer:Software Training Academy
Toronto, Ontario, Canada
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services. Implementing SSAS solutions have shown to boost data retrieval and report generation from SQL Server by up to 1000%.
LEARNING OBJECTIVES
· Learn about disaster recovery options
· Learn the core concepts in building solutions using Microsoft Business Intelligence with SSAS.
· Understand OLAP (cube) modeling and data mining.
· See how to develop solutions using Business Intelligence Development Studio (BIDS).
· Understand advanced storage design including MOLAP, ROLAP, and HOLAP.
· Learn the fundamentals of MultiDimensional Expressions (MDX).
· See best practices for SSAS administration using SQL Server Management Studio (SSMS) and XMLA (XML for Analysis).
· Work with OLAP reporting clients including Microsoft Excel and SQL Server Reporting Services.
· See integration with Microsoft Office 2007 and Microsoft SharePoint 2007.
Course Duration: 3 days
Prerequisites:
This course does not require any prior experience with Analysis Server 2005. It is assumed that students have working experience with SQL Server 2000 or 2005; basic relational database concepts (e.g., tables, queries, and indexing); data transformation services; Excel 2003; and SharePoint Server 2003.
...''
Please go to the school's official website for training price and schedule:
http://www.softwaretrainingacademy.com/
Phone:1-888-896-7852
School Address:
Toronto Star Building
1 Yonge Street, Suite 1801
Downtown Toronto
Ontario, Canada - M5E 1W7
Jobs & Resumes: Toronto
Houses & Roommates: Toronto
Travel Agencies: Toronto
Search other schools for SQL Server 2005 Analysis Services (SSAS) training resources.
Other training courses offered by Software Training Academy:
JSP
JDBC
Oracle 10g Advanced SQL
Oracle 10g Introduction to SQL
Oracle 10g PL/SQL Programming
Oracle Applications Using ADO.NET and C#
J2EE
Visual Basic for Applications (VBA)
Securing Java Web Applications
SQL Server 2005 Additional Topics
SQL Server 2005
SQL Server 2005 Integration Services (SSIS)
SQL Server 2005 Reporting Services (SSRS)
SQL Server 2005 Transact SQL (T-SQL)
The Java Message Service
JSP Standard Tag Library
Using and Developing JavaBeans
XML Programming Using C# and .NET
XML Programming Using Java
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.
Tips:
Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results. |
|
| 
