|
Formål:
At give deltageren viden om administration og implementation af Analysis Service løsninger i en organisation. Endvidere gennemgås hvordan man via værktøjer skaber en Analysis Service Database og en OLAP cube.
Forudsætninger:
Følgende kurser eller tilsvarende viden:
- SU-240 SQL Programmering Grundkursus
samt
- SU-241 SQL Programmering Videre .. (fordel)
- SU-242 MS Transact SQL (T-SQL) ... (fordel)
- MS-6231 Maintaining a Microsoft ... (fordel)
- MS-6232 Implementing a Microsoft ... (fordel)
Beskrivelse:
Kurset indeholder gennemgang af, hvordan SQL Server Analysis Services kan bruges til analytiske løsninger. Man opretter multidimensionale analyse løsninger og implementerer dimensions og cubes i en Analysis Services løsning. Der implementeres measures og measure groups samt querys i en multidimensional løsning. Der gennemgås tilpasning af Analysis Services cubes. Derudover behandles vedligeholdelse, deployment og sikkerhed. Endelig arbejdes der med Data Mining.
Lærebøger:
Microsoft Official Curriculum (MOC) materiale.
Certificeringer:
- 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance (En del af testen)
Varighed / Pris:
3 dage / 11.100,- kr. (ekskl. moms)
Videre forløb:
- MS-6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
|
Indhold:
- Introduction to SQL Server Analysis Services
- Overview of Data Analysis Solutions
- Overview of SQL Server Analysis Services
- Installing SQL Server Analysis Services
- Creating Multidimensional Analysis Solutions
- Developing Analysis Services Solutions
- Creating Data Sources and Data Source Views
- Creating a Cube
- Working with Cubes and Dimensions
- Configuring Dimensions
- Defining Attribute Hierarchies
- Sorting and Grouping Attributes
- Working with Measures and Measure Groups
- Working With Measures
- Working with Measure Groups
- Querying Multidimensional Analysis Solutions
- MDX Fundamentals
- Adding Calculations to a Cube
- Customizing Cube Functionality
- Implementing Key Performance Indicators
- Implementing Actions
- Implementing Perspectives
- Implementing Translations
- Deploying/Securing an Analysis Services DBS
- Deploying an Analysis Services Database
- Securing an Analysis Services Database
- Maintaining a Multidimensional Solution
- Configuring Processing
- Logging, Monitoring, and Optimizing an Analysis Services Solution
- Backing Up and Restoring an Analysis Services Database
- Introduction to Data Mining
- Overview of Data Mining
- Creating a Data Mining Solution
- Validating Data Mining Models
|
