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.
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.
Session 1 – Date Warehouse Planning and Design – This session teaches you the fundamentals of designing a data mart or warehouse and some of the best practices in BI project planning methodologies.
Session 02 – Cube Design – With the data warehouse now complete, you’ll now see how to create your first Analysis Services cube by using some of the core wizards in SSAS. You’ll also learn the role of SSAS.
Session 03 – Editing the Dimension and Cube – The wizard can only do so much. In this session, you’ll learn how to clean the cube up by formatting different measures. You’ll also learn how to build hierarchies and attribute relationships.
Session 04 – Adding New Facts and Dimensions – Requirements constantly change and in this session, you’ll see how to accommodate the moving requirements of your company by adding new dimensions, snowflakes to existing dimensions and fact tables.
Session 05 – MDX Basics and Calculations – MDX in the query language for SSAS and has a steep learning curve. You’ll learn in this session the basics of MDX and how you’ll use the language. You’ll also see how to create calculations to make it easier to derive new data from your cube like year to date sales and profit margins.
Session 06 – Adding KPIs, Actions and Perspectives – To centralize the logic in SSAS, you’ll learn how to add Key Performance Indicators (KPIs) to the cube and drill through actions.
Session 07 – Predictive Analytics with Data mining – Data mining is the way you can add tons of value to your company by finding new customers or focusing their efforts on the best customers. In this session you’ll see how to build your first data mining prototype using a number of algorithms.
Session 08 – Securing and Administering the Cube – The DBA still has a role in business intelligence. In this module, you’ll learn about how to secure, partition, aggregate and deploy your cube. You’ll also see more techniques around processing of the cube.
Session 09 – Using Excel in SSAS – Learn how to teach your users how to access their data quickly in Excel and how to deploy amazing reports to SharePoint after they are complete.
Session 10 – Introduction to PowerPivot – This new SSAS feature is must-have knowledge for anyone entering the BI space now. In this session, you’ll learn how to create ad-hoc self-service reports with PowerPivot and how to deploy these reports to SharePoint.
Session 11 – Introduction to Performance Point – SharePoint BI has grown in popularity over the past few years and is becoming a hot commodity. Learn how to build powerful dashboards and scorecards in SharePoint using the Dashboard Designer.
Session 12 – Reporting Services Against SSAS – Static reports still have a place in the BI space. In this session, you’ll see how to build an MDX and DMX report against SSAS data.
Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of 10 SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.pragmaticworks.com.