Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions
Duration: 5 Days [note]
This course will teach students to design and maintain business intelligence solutions for their organization using SQL Server 2008. They will learn how to use the SQL Server development tools to create Analysis Services databases and OLAP cubes. In addition, they will learn to implement complete business intelligence solutions from design to development to production and, finally, end user analysis and reporting.
Topics Covered In This Course
Introduction to Microsoft SQL Server Analysis Services
Creating Multidimensional Analysis Solutions
Working with Cubes and Dimensions
Working with Measures and Measure Groups
Querying Multidimensional Analysis Solutions
Customizing Cube Functionality
Deploying and Securing an Analysis Services Database
Maintaining a Multidimensional Solution
Introduction to Data Mining
SQL Server Integration Services
Integrating SSAS and MS Excel
What You Can Expect
At the end of this course, students will be able to:
Who Should Take This Course
Individuals who design and maintain business intelligence solutions and who work in environments where databases play a key role in their primary job and may perform database administration, database design, data warehouse design, maintenance, or ETL as part of their primary job responsibilities.
Individuals, including report writers, business analysts, and financial analysts, who develop applications that deliver content from SQL Server Analysis Services to the organization.
Experience navigating the Microsoft Windows Server environment. Also, experience with Microsoft SQL Server, including: SQL Server query language (SELECT, UPDATE, INSERT, and DELETE), SQL Server System tables, and SQL Server accounts (users and permissions).
Instructor led Lecture (50%) and Lab (50%).
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]