Microsoft SQL Server 2008 Analysis Services Business Intelligence Skills for MCTS 70-448 and MCITP 70-452 Video Mentor

Description

Using Microsoft SQL Server 2008 Analysis Services (SSAS), thousands of businesses are capturing more timely insights for more effective action. To succeed with SSAS, businesses need professionals who've mastered this technology. Thousands of these professionals are seeking to demonstrate their expertise by passing one of Microsoft's new SQL Server exams: MCTS 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance, or MCITP: Business Intelligence Developer 2008 70-452. In 6+ hours of personal, interactive video mentoring, leading SQL Server trainer Wendy Henry walks you through all the Analysis Services tasks and concepts you need to install, configure, monitor and recover SSAS systems. Henry combines audio instruction, step-by-step screencasts, and more: everything you need to fully understand the tasks you're watching. There's never been a more efficient, cost-effective, compelling SQL Server 2008 Analysis Services training solution.

• 6+ hours of video mentoring from one of the world's leading SQL Server Analysis Services experts and instructors!
• Covers exam objectives on MCTS exam 70-448 and MCITP exam 70-452
• The best of classroom training for a fraction of the price, packed with insider tips and tricks - all delivered in an amazingly convenient, flexible visual format

Sample Content

Table of Contents

II.     Implementing and Managing SQL Server 2008 Analysis Services

a.      Lab 1:  Install and Configure SSAS

i.      Pre-Installation Checklist (min req's, editions, etc.)

ii.     Install SSAS in non-clustered environment then a clustered environment

iii.    Configuring Logging, Storage (partition, dimension) & Security

b.      Lab 2:  SSAS Solution Management

i.      Deploying Solutions (Dep Wiz, XMLA Scripts, Sync DB Wiz SSIS, BIDS)

ii.     SSAS Project Object Processing (explanation and options)

iii.    Implementing Object Processing (SSMS, BIDS, XMLA Scripts)

c.      Lab 3:  Monitor and Maintain SSAS

i.      Monitoring queries (SQL Server Profiler, etc.)

ii.     Monitoring server performance (System Monitor counters, DBCC UBOW, etc.)

iii.    Backing up and restoring the SSAS database (SSMS, sqlcmd)

iv.     Regenerating SSAS database objects (XMLA Scripts, reprocessing)

d.      Lab 4:  Create Basic SSAS Database Objects

i.      Creating a Cube (Cube Wiz, Designer, CLI)

ii.     Creating a Data Source View (add tables, create relationships, add keys, denormalization)

iii.    Creating Named Queries and Calculations

iv.     Creating a Dimension (Cube Designer, Dimension-Usage Tab, defining dims & fact tables)

v.      Creating and Maintaining a Measure Group or Partition (defining measures by properties, adding measures to measure groups, partition storage modes, unknown member handling)

vi.     Defining Data Access (ROLAPvsMOLAPvsHOLAP, caching, aggregation design, refresh)

vii.    Creating a Query, Calculation, KPI and Action Using MDX

e.      Lab 5: Modifying a SSAS Cube

i.      Modifying SSAS Dimensions (member properties, attributes, column bindings, ragged hierarchies)

ii.     Modifying SSAS Cubes (analyzing calculated members, perspectives, translations, KPI's, actions and drillthrough)

f.      Lab 6:  Secure SSAS Database Objects

i.      Implementing security on a cube or dimension (roles, granularity, leveraging Windows)

ii.     Implementing cell-level security (granular and drillthrough)

iii.    Using MDX

II.     Implementing Data Mining

a.      Lab 1:  Implement Data Mining

i.      Creating a Data Mining Solution (DMWiz, DMDesigner)

ii.     Defining and Implementing a Data Mining Model  (prediction, trend analysis, compliance)

iii.    Implementing a Data Mining Definition Method (algorithm parameters)

b.      Lab 2:  Process and Query a Data Mine

i.      Processing a Data Mining Object (structure=full/structure/default ; model=full/default)

ii.     Querying a Data Mining Model Using DMX (SSMS, Prediction Query Builder, reporting results), ADOMD, SSIS or .NET application viewer controls

c.      Lab 3:  Manage a Data Mining Solution

i.      Validating a Data Mining Model (accuracy charts)

ii.     Implementing Data Mining Security (structure and model)

Updates

Submit Errata