 |
SQL Server 2005 Analysis Services Training
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.
Course includes 36+ hours of total training time...
8 modules of training
Over 12 hours of media run time
Over 450 pages of printable courseware
Step-by-step hands-on-labs
Sample code
|
SQL Server 2005 Analysis Services Instructors
Lynn Langit is a trainer and consultant who specializes in designing and implementing Business Intelligence solutions using Microsoft Analysis Server. She has been training and working with SSAS since 2000. Lynn also has over 10 years experience as a business manager, with full P & L responsibility. This unique combination of technical knowledge and business experience makes her particularly qualified to implement OLAP training. Lynn holds the following certifications - MCT, MCITP (SQL Administration and Development), MCDBA, MSCD and MSF.
|
About this course:
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%
In this course, you will:
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. v
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.
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.
|
|
DVD ROM'S:The DVD version of this training set will only run on DVD ROM computer players only. These DVD's WILL NOT run on entertainment DVD players that are connected to TV's. An Internet connection is also required.
|
Home ||
Shopping Cart ||
Site Map ||
Newsletter/Blog
Search HALLoGRAM ||
Request More Information
CALL TOLL FREE 1-866-340-3404
|
