This course is for business intelligence developers and database professionals responsible for preparing data for multidimensional analysis and assumes no prior experience with Analysis Services
Course Curriculum
1. Introduction to Analysis Services | |||
1.1. Introduction to Analysis Services | FREE | 00:00:00 | |
1.2. Business Intelligence Queries | 00:00:00 | ||
1.3. Architecture Options | 00:00:00 | ||
1.4. Database Development | 00:00:00 | ||
1.5. Development Management and Client Tools | 00:00:00 | ||
1.6. Summary | 00:00:00 | ||
2. Dimensional Model Development | |||
2.1. Demensional Model Development Overview | 00:00:00 | ||
2.2. Data Sources | 00:00:00 | ||
2.3. Demo: Creating a Data Source | 00:00:00 | ||
2.4. Top Dowm versis Bpttom up Design | 00:00:00 | ||
2.5. Top Down Design Cube Wizard | 00:00:00 | ||
2.6. Top Down Design: Demension | 00:00:00 | ||
2.7. Demo: Using the Cube Winzard with Top Down Design | 00:00:00 | ||
2.8. Demo: Designing Dimensions with Top Down | 00:00:00 | ||
2.9. Schema Generation Wizard | 00:00:00 | ||
2.10. Demo: Using the Schema Generation Wizard | 00:00:00 | ||
2.11. Data Source View | 00:00:00 | ||
2.12. Demo: Reviewing and Modifying a Top Down Source View | 00:00:00 | ||
2.13. Demo: Creating a New Data Source View from the Bottom Up | 00:00:00 | ||
2.14. Named Calculations | 00:00:00 | ||
2.15. Demo: Creating named Calculation | 00:00:00 | ||
2.16. Named Queries | 00:00:00 | ||
2.17. Demo: Creating a Named Query | 00:00:00 | ||
2.18. Summary | 00:00:00 | ||
3. Dimension Development 1 | |||
3.1. Dimension Development Overview | 00:00:00 | ||
3.2. Dimension Wizard | 00:00:00 | ||
3.3.Demo: Using the Dimension Wizard to CreateaStandard Dimension | 00:00:00 | ||
3. 4. Dimension Designer | 00:00:00 | ||
3. 5. Attributes | 00:00:00 | ||
3.6. Demo: Browsing a Dimension | 00:00:00 | ||
3.7. Demo: Combining Tables for Snowflake Dimension (Top Down Design) | 00:00:00 | ||
3.8. Demo: Using the Dimension Wizard to Createa Snowflake Dimension | 00:00:00 | ||
3.9. Demo: Using the Dimension Wizard to Createa Date Dimension (Bottom Up Design) | 00:00:00 | ||
10. Demo: Using the Dimension Wizard to CreateaDateDimension (Top Down Design) | 00:00:00 | ||
3. 11.Demo: Comparing Top Down to Bottom Up Date Dimensions | 00:00:00 | ||
3.12. Unknown Member | 00:00:00 | ||
3.13. Demo: Working with the Unknown Member | 00:00:00 | ||
3. 14. Basic Attribute Properties | 00:00:00 | ||
3. 15. Demo: Configuring Attribute Properties | 00:00:00 | ||
3.16. Summary | 00:00:00 | ||
4. Dimension Development 2 | |||
4.1. Dimension Development 2 Overview | 00:00:00 | ||
4.2. Date Dimension Properties | 00:00:00 | ||
4.3. Demo: Setting Properties for the Date Dimension | 00:00:00 | ||
4.4. Best Practice Warnings | 00:00:00 | ||
4.5. User Hierarchies | 00:00:00 | ||
4.6. Demo: Creating User-Defined Hierarchies | 00:00:00 | ||
4.7. Demo: Working with Best Practice Warnings | 00:00:00 | ||
4.8. Parent-childHierarchy | 00:00:00 | ||
3.9. Demo: Creatinga Parent-child Hierarchy | 00:00:00 | ||
3.10. Attribute Relationships | 00:00:00 | ||
4.11. Demo: Working with Attribute Relationships | 00:00:00 | ||
4.12. Translations | 00:00:00 | ||
4.13. Demo: Adding Translations to a Dimension | 00:00:00 | ||
4.14. Dimension Development Tasks | 00:00:00 | ||
4.15. Summary | 00:00:00 | ||
5. Cube Development 1 | |||
5.1. Cube Development Overview | 00:00:00 | ||
5.2. Cube Wizard | 00:00:00 | ||
5.3 . Demo: Using the Cube Wizard to Create a Cube | 00:00:00 | ||
5.4. Cube Designer | 00:00:00 | ||
5.5. Measure Properties | 00:00:00 | ||
5.6. Aggregate Functions | 00:00:00 | ||
5.7. Demo: Configuring Measure Properties | 00:00:00 | ||
5.8. Role-Playing Dimension | 00:00:00 | ||
5.9. Demo: Reviewing the Cube Dimensions | 00:00:00 | ||
5. 10.Demo: Deploying and Browsing the Cube | 00:00:00 | ||
5. 11. Additional Measures | 00:00:00 | ||
5.12.Demo: Adding Measures and Dimensions to an Existing Cube | 00:00:00 | ||
5. 13. Dimension Usage | 00:00:00 | ||
5. 14. Demo: Changing Dimension Usage | 00:00:00 | ||
5.15. Summary | 00:00:00 | ||
6. Cube Development 2 | |||
6.1. Cube Development 2 Overview | 00:00:00 | ||
6.2. Aggregations | 00:00:00 | ||
6. 3. Demo: Using the Aggregation Wizard | 00:00:00 | ||
6.4. Demo: Viewing Aggregation Designs | 00:00:00 | ||
6.5. Perspectives | 00:00:00 | ||
6.6. Demo: Adding a Perspective | 00:00:00 | ||
6.7. Translations | 00:00:00 | ||
6.8. Demo: Adding Translations to a Cube | 00:00:00 | ||
6.9. Cube Development Tasks | 00:00:00 | ||
6.10. Summary | 00:00:00 | ||
7. Calculation 1 | |||
7.1. Overview | 00:00:00 | ||
7.2. Calculation Designer | 00:00:00 | ||
7.3. Calculation Tools-Metadata | 00:00:00 | ||
7.4. Demo: Understanding Formulas | 00:00:00 | ||
7.4. Demo: Creating a Calculation to Sum Measures | 00:00:00 | ||
7.6. Demo: Testing a Calculation | 00:00:00 | ||
7.7. Calculation Tools-Functions | 00:00:00 | ||
7.8.Demo-Creating a Growth Calculation | 00:00:00 | ||
7.9. Demo:Testing the Growth Calculation | 00:00:00 | ||
7. 10. Calculation Tools-Templates | 00:00:00 | ||
7.11. Demo: Creating a Ratio Calculation | 00:00:00 | ||
7.12.Color and Font Expressions | 00:00:00 | ||
7. 13.Demo: Using Color and Font Expressions with Calculations | 00:00:00 | ||
7. 14. Summary | 00:00:00 | ||
8. Calculation 2 | |||
8.1. Overview | 00:00:00 | ||
8. 2.Calculated Members of a Dimension | 00:00:00 | ||
8.3. Demo: Creating a Non-Measure Calculation | 00:00:00 | ||
8.4. Named Sets | 00:00:00 | ||
8.5.Demo: Creating a Named Set | 00:00:00 | ||
8.6. Key Performance Indicators | 00:00:00 | ||
8.7. Demo: Creating a Key Performance Indicators | 00:00:00 | ||
8.8. Summary | 00:00:00 | ||
9. Database Processing | |||
9.1. Overview | 00:00:00 | ||
9.2. BIDS Deployment | 00:00:00 | ||
9.3. Project Properties | 00:00:00 | ||
9.4. Demo: Understanding the Deployment Process | 00:00:00 | ||
9.5.Deployment Wizard | 00:00:00 | ||
9. 6. Demo: Using the Analysis Services Deployment Wizard | 00:00:00 | ||
9.7. Storage Modes | 00:00:00 | ||
9.8. Effect of Updates | 00:00:00 | ||
9.9. Demo: Configuring the Storage Mode | 00:00:00 | ||
9.10. Processing | 00:00:00 | ||
9.11. Processing | 00:00:00 | ||
9.12. Demo: Processing Cube | 00:00:00 | ||
9.13. Summary | 00:00:00 | ||
10. Security | |||
10.1. Overview | 00:00:00 | ||
10.2. User Security | 00:00:00 | ||
10.3. Dimension Security | 00:00:00 | ||
10.4. Demo: Applying Dimension Security | 00:00:00 | ||
10. 5.Demo: Testing Dimension Security | 00:00:00 | ||
10.Demo: Applying Dimension Security | 00:00:00 | ||
10. 7.Demo-Working with Multiple Roles | 00:00:00 | ||
10.8. Demo: Working with a Default Member | 00:00:00 | ||
10.9. Cell Security | 00:00:00 | ||
10.10. Demo-Defining Cell Security | 00:00:00 | ||
10.11.Administrator Security | 00:00:00 | ||
10.12. Demo-Configuring Administrator Security | 00:00:00 | ||
10. 13. Service Account Configuration | 00:00:00 | ||
10.14. Summary | 00:00:00 |
Course Reviews
No Reviews found for this course.
4 STUDENTS ENROLLED