›
Nyheter

›
Informatormetoden

›
Utbildningar

›
Technet och MSDN

›
Mina sidor

Logga in

Lösenord:

› › Systemutveckling › Business Intelligence › Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008

MS6314

Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008

Denna utbildning lär dig att designa och utveckla avancerade business intelligence-lösningar med hjälp av SQL Server. Kursen riktar sig mot erfarna BI-utvecklare som vill lära sig mer om design och best-practices.

Microsoft har dragit tillbaka utvecklingen av denna kurs. Vad den ersätts med är i detta läge ej klart. För frågor, kontakta info@informator.se

Målgrupp

BI-utvecklare med lång erfarenhet av att utveckla BI-lösningar med hjälp av de BI-verktyg som finns i SQL Server 2005 eller 2008. BI-utvecklare som vill certifiera sig och bli MCITP: Business Intelligence Developer 2008.

Du får lära dig

Describe the various concepts related to BI.
Plan a BI solution.
Plan the development of a BI solution.
Determine BI requirements.
Determine architectural requirements of a BI solution.
Plan the Microsoft BI environment.
Describe the concepts and guidelines related to managing BI operations.
Plan data sources and destinations.
Determine staging requirements.
Plan SSIS packages.
Plan SSIS package development.
Design data flow.
Plan data flow operations.
Extend SSIS packages with scripts.
Design a strategy for logging ETL operations.
Design a strategy for managing errors.
Design and implement reliable ETL processes.
Design a strategy for deploying and maintaining SSIS packages.
Design a strategy for optimizing an SSIS solution.
Describe the purpose and functionality of an OLAP solution.
Describe how to gather requirements for an OLAP solution.
Design a logical OLAP solution architecture.
Design dimensions.
Design dimension relationships.
Describe the considerations for implementing cubes, KPIs, and actions.
Describe the international considerations for an SSAS Solution.
Design and implement physical storage for dimensions.
Design and implement a partitioning strategy for relational data.
Design a partitioning strategy for multidimensional data.
Design aggregations.
Describe the SSAS resource requirements.
Describe the considerations for providing SSAS scalability.
Describe the considerations for providing SSAS availability.
Plan and implement a deployment strategy for an SSAS solution.
Design a strategy for monitoring an SSAS solution.
Secure an SSAS solution.
Design a strategy for optimizing the performance of SSAS.
Design business driven calculations by using MDX.
Work with MDX queries.
Describe MDX query context and execution.
Optimize MDX queries.
Extend multidimensional expressions.
Analyze the business requirements for a reporting solution.
Plan the SSRS architecture.
Design a data acquisition strategy.
Plan a reporting solution.
Design report models.
Extend reporting with custom code.
Plan the integration of reports with applications.
Design security for a reporting solution.
Plan reports distribution.
Design a strategy for managing report execution.
Design a strategy for optimizing report performance.
Plan the administration of SSRS.
Describe the fundamentals of data mining.
Design a mining model and structure.
Design strategies for staging data.
Visualize data mining results
Test mining models.

Innehåll

Module 1: Designing a Business Intelligence Architecture in Microsoft SQL Server 2008
Module 2: Designing a Strategy for Implementing ETL by Using Microsoft SQL Server 2008 Integration Services
Module 3: Designing a Strategy for Managing Packages by Using Microsoft SQL Server 2008 Integration Services
Module 4: Designing an OLAP Solution Architecture by Using Microsoft SQL Server 2008 Analysis Services
Module 5: Designing Physical Storage for an OLAP Solution by Using Microsoft SQL Server 2008 Analysis Services
Module 6: Designing an Administration and Maintenance Strategy for a Microsoft SQL Server 2008 Analysis Services Solution
Module 7: Designing Effective Queries for an OLAP Solution by Using Microsoft SQL Server 2008 Analysis Services
Module 8: Designing and Developing a Microsoft SQL Server 2008 Reporting Services Solution Architecture
Module 9: Designing a Strategy for Deploying and Managing a Microsoft SQL Server 2008 Reporting Services Solution Architecture
Module 10: Designing Data Mining Solutions by Using Microsoft SQL Server 2008