Multi-Dimensional Business Intelligence on 7 CD-ROMs

Other products by SQLUSA

Product Features

• Microsoft Analysis Services 2005 Administration
• Data Warehouse Architecture Using SQL Server 2005
• OLAP Cube Architecture, Design and Deployment
• Business Intelligence Solutions in the Enterprise
• Training by Senior Business Intelligence Architect

Product Details

• Product Dimensions: 9 x 2 x 12 inches
• Shipping Weight: 7 pounds
• ASIN: B000J52HKM
• Date first available at Amazon.com: September 30, 2006
• Average Customer Review: 1.0 out of 5 stars  See all reviews (1 customer review)
• Amazon.com Sales Rank: #25,095 in Software (See Bestsellers in Software)

  Popular in this category: (What's this?)

  #65 in

  Software > Programming > Training & Tutorials

Product Description

Product Description

Training on 7 Audio/Video CD-ROMs and 2 excellent textbooks. BI Overview, DW/BI Architecture, DW/BI Design, User Interfaces, Successful Project Management, Reporting (cubes, dashboards, scorecards), MDX programming and Data Mining. Microsoft Analysis Services 2005, Business Intelligence Development Studio, and SQL Server Management Studio are the major tools featured in the course. Here is the content of selected CD-s: CD-ROM 4- OLAP CUBES (2 hours 30 minutes) OLAP Concepts and Database Setup 2. Design of Fact and Dimension Tables 3. Analysis Services 2005 Architecture 4. The Foodmart 2005 Sample Data Warehouse 5. Populating Fact and Dimension Tables 6. Cube Measures, Dimensions & Hierarchies 7. Aggregations, the GROUP BY Query 8. The AdventureWorksDW Sample Data Warehouse 9. Managing AS 2005 from Management Studio 10. The Dimension Wizard 11. Creating Parent-Child Dimensions 12. The Cube Wizard 13. Designing Cubes in BI Development Studio 14. Creating a Cube with Star Schema 15. Snow Flake Schema 16. Processing Dimensions and Cubes CD-ROM 5. COMPLEX CUBES (2 hours 38 minutes) 1. 1. Adding Measure Groups & Calculated Measures 2. Editing Dimensions in the Dimension Designer 3. Editing a Cube in the Cube Designer 4. Slicing & Dicing, Drilling a Cube in the Browser 5. Schema Generation Wizard 6. MOLAP, ROLAP, HOLAP & Other Storage Models 7. Aggregation Design Wizard for Optimization 8. Usage-Based Optimization Wizard 9. Deployment Wizard & Synchronize DB Wizard 10. Automating Cube Processing with SSIS 11. Drillthroughs, Actions, Perspectives and Translations 12. Account Dimensions & Key Performance Indicators 13. Linked Dimensions & User Hierarchies 14. Writeback: Write-Enabling a Dimension 15. Cube, Dimension & Cell Level Security 16. Partition Management & AS DB Processing

Customer Reviews

Most Helpful Customer Reviews

1 of 1 people found the following review helpful:

1.0 out of 5 stars Complete waste of time, December 12, 2007

By	N. BERGMAN - See all my reviews (REAL NAME)

This is a very high level overview of Microsoft BI tools. There is no structure to the presentation, no valuable lessons or useful tips. I would not recommend this product