Querying Cubes and Working with Data Mining in SSAS


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
SQL Server 2008 Analysis Services takes relational data and provides a robust way to analyze it in a meaningful way through MDX queries and data mining. This course will introduce the fundamentals of querying multi-dimensional data. It will introduce the MDX language which used to query multi-dimensional data. This includes a discussion on how to create a basic MDX query, how to establish a cube context, how to build subcubes and named sets, and how data can be modified with MDX. The course also provides a review of Key Performance Indicators (KPI), Actions, Perspectives, Translations, and Stored Procedures. In addition, this course introduces data mining. It looks at the logical and physical architecture of data mining including data mining structures, models, and algorithms. Tools related to data mining such as the Data Mining Wizard, Data Mining Designer, and SQL Server Management Studio will also be discussed in this course. This course will also look at how you can create, view, validate, and query a data mining solution. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.

Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer

Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio

Expected Duration (hours)
2.0

Lesson Objectives

Querying Cubes and Working with Data Mining in SSAS

  • recognize how to query cubes using MDX
  • recognize how to work with KPIs
  • create actions with SSAS
  • recognize how data mining works
  • recognize how to create a data mining solution
  • query a data mining solution
  • use drillthrough on a data mining solution
  • use cubes in SQL Server 2008
  • use data mining in SQL Server 2008
  • Course Number:
    md_mqbm_a08_it_enus