Month 29: Analyzing Data with SQL Server Analysis Services (SSAS)
Week 1: Introduction to SQL Server Analysis Services (SSAS)
- Day 1: Understanding SQL Server Analysis Services
- Day 2: Setting Up SQL Server Analysis Services
- Day 3: Understanding Multidimensional and Tabular Models in SSAS
- Day 4: Creating Basic SSAS Models
- Day 5: Deploying and Processing SSAS Models
Week 2: Advanced SSAS Model Design
- Day 1: Adding Dimensions and Hierarchies to SSAS Models
- Day 2: Adding Measures and Measure Groups to SSAS Models
- Day 3: Working with Calculated Members and Named Sets in SSAS
- Day 4: Advanced SSAS Tabular Modeling
- Day 5: Using MDX and DAX in SSAS
Week 3: SSAS for Data Analysis
- Day 1: Querying SSAS Models
- Day 2: Using SSAS with Excel for Data Analysis
- Day 3: Creating Reports and Dashboards from SSAS Models
- Day 4: Using SSAS for Predictive Analysis
- Day 5: Optimizing SSAS Performance
Week 4: SSAS for Business Intelligence
- Day 1: Understanding Business Intelligence
- Day 2: Role of SSAS in Business Intelligence
- Day 3: Using SSAS for Data Mining
- Day 4: Integrating SSAS with other BI Tools
- Day 5: Case Studies: SSAS for Business Intelligence
dowhatkennydoes.com 