Contact for queries :
banner1

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

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • FREE
  • UNLIMITED ACCESS
4 STUDENTS ENROLLED

About WPLMS

WPLMS is the most popular Education WordPress theme. With over 12000 customers and several startups successfully running their businesses on WPLMS, it is the most powerful solution for Education websites right now.

Popular Tags

Who’s Online

There are no users currently online
top
Template Design © VibeThemes. All rights reserved.