12 On-Demand Sessions Open on August 14th, 2012 and Closes After September 12th, 2012
In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class will provide you with the skills to properly use SQL Server Analysis Services (SSAS) 2008 in your enterprise.
Brian Knight, course instructor and SQL Server MVP, will take you from the ground-up, teaching you the fundamental skills you need to develop and deploy SSAS solutions and present this new data to your end users. This class is presented in SQL Server 2008, but is appropriate for those using SQL 2005 as well.
Target Audiences and Prerequisites
The target audiences for this class are developers, architects or IT professionals who have basic SQL skills already. This class assumes that you have no previous knowledge of OLAP or Analysis Services. Technical knowledge of basic database design concepts is assumed. It is required that you already know how to navigate around SQL Server 2005/2008 and how to query a SQL Server.
Throughout the 30-day course, you will learn how to:
- Develop a data warehouse and a repeatable methodology for a successful SSAS project
- Create and configure a cube and dimensions
- Write MDX (the querying language for cubes)
- Define calculations, Key Performance Indicators (KPIs) and perspectives
- Implement dynamic security
- Administer and deploy SSAS
- Build office-based BI applications and dashboards
Course Structure and Cost
Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on-demand period.
The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.
Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (Download link via e-mail).