| Subcategories |
 |
Programming |
|
|
|
|
 |
 |
| |
|
|
|
|
|
Multi-Dimensional Business Intelligence on 7 CD-ROMs
Studio : Silico-Magnetic Intelligence Corp.
by Silico-Magnetic Intelligence Corp.
Brand : SQLUSA
Publisher : Silico-Magnetic Intelligence Corp.
Availability : Usually ships in 1-2 business days
UPC : 850171001074
Avg. Customer Rating: (based on 1 review)
List Price : $695.00
Our Price : $625.00
|
|
| |
-
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 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 |
| |
|
| |
|
Complete waste of time |
|
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 |
| |
|
|
|
