|
Formål:
Kurset retter sig mod deltagere, som allerede arbejder med Business Intelligence.
Forudsætninger:
Følgende kurser eller tilsvarende viden:
Grundviden om udv. af BI-løsninger. Grundbegreber inden for OLAP multidim. data, MDX og modellering af rel. databaser. Kunne skrive T-SQL, performance-optimere queries samt oprette tabeller, views, indices. Grundlæggende forståelse af datawarehousing og SQL 2005-serverens værktøjer -- bl.a. til at oprette Analysis Services funktionalitet!
Beskrivelse:
Kurset giver retningslinier til planlægning, im-plementering og udrulning af Analysis Services med fokus på arkitektur af multidimensionelle data til understøttelse af Business Intelligence.
Lærebøger:
Microsoft kursusmateriale på engelsk
Certificeringer:
- Indgår i certificeringen 70-445
Varighed / Pris:
3 dage / 11.100,- kr. (ekskl. moms)
Videre forløb:
Inden for Business Intelligence:
- MS-2794 Design. a Bus. Intelligence Solution for the Enterprise Using MS SQL Server 2005
- MS-2795 Design. an ETL Solut. Architecture Using MS SQL Server 2005 Integrat. Services
- MS-2797 Design. a Rep. Sol. Architect. using MS SQL Server 2005 Reporting Services
|
Indhold:
- Captur. Business and Technical Requirements
- Plan an analysis solution
- Identify business and technical requirements to ensure the solution meets the needs of its users
- Designing and Implementing a Logical OLAP Solution Architecture
- Design-considerations for an OLAP solution
- Design-considerations for the relational schema of an OLAP solution
- Considerations for designing and implementing OLAP cubes
- Designing Physical Storage for a multidimen-sional Solution
- Effective physical storage solution for dimensions and measures
- Partition relational data
- Partition multidimensional data
- Creating calculations
- Create calculated members
- Implementing Named Sets
- Implementing Scoped MDX Scripts
- Extending Cube Functionality
- Key Performance Indicators (KPI)
- Actions - how to create
- Creating stored procedures
- Designing an Analysis Services Infrastructure
- Specify appropriate hardware and software resources for an Analysis Services solution
- Infrastructure that supports high scalability and high availability
- Deploying a Multidim. Solut. into Production
- Deploy and secure an Analysis solution
- Optimizing an OLAP Solution
- Monitoring Analysis Services
- Optimize performance of Analysis Services
- Implementing Data Mining
- Introduction to data mining
- Implementing a data mining solution
- Use data mining in a Business Intelligence Solution
|
