Formation : Designing an Analysis Solution Architecture using SQL Server 2005 Analysis Services
Se former avec
EduGroupe
- Renseignements :
- Durée : 0 Jour
- Type : En centre (inter)
- Diplômant : Non
-
Prix H.T. € :N.C.
- Objectifs :
- After completing this course, students will be able to:Capture the business and technical requirements for an analysis solution.Design and implement a logical Online Analytical Processing (OLAP) solution architecture.Design physical storage for a multidimensional solution.Create calculated members and named sets.Implement Key Performance Indicators (KPIs), actions, and stored procedures.Design the infrastructure for an OLAP solution.Deploy and secure an Analysis Services solution in a production environment.Monitor and optimize an Analysis Services solution.Implement a data mining solution.
- Public visé :
-
This course is intended for experienced BI professionals. The target students for this course already have an understanding of how to use SQL Server 2005 tools to implement Analysis Services functionality, but need to develop their understanding of design principles and best practices when planning, implementing, and deploying an Analysis Services solution.
- Pré-requis :
- Before attending this course, students must:Have hands-on experience with database development tasks. For example:Creating Transact-SQL queriesWriting and optimizing advanced queries (for example, queries that contain complex joins or subqueries)Creating database objects such as tables, views, and indexesHave foundational conceptual understanding of data warehousing, data marts, and business intelligence. Students must be well versed on the subjects of data warehousing, data marts, and BI, and preferably have read at least one book by Ralph Kimball or Bill Inmon.Have a conceptual understanding of OLAP technologies, multidimensional data, MDX, and relational database modeling. For example, know what facts, dimensions, measures, calculated measures, and foreign keys are.Be familiar with SQL Server 2005 features, tools, and technologies. In particular, they must have built and queried an Analysis Services cube.Have foundational understanding of Microsoft Windows security. For example, how groups, delegation of credentials, and impersonation function in a security context.Have foundational understanding of Web-based architecture. For example, SSL, SOAP, and IIS-what they are and what their role is.Must understand the difference between replication and ETL.Already know how to use: Microsoft Office Visio - Microsoft SQL Server Business Intelligence Development Studio - Microsoft SQL Server Management Studio - Performance Monitor - Microsoft SQL Server Profiler
- Module 1: Capturing Business and Technical RequirementsPlanning an Analysis SolutionIdentifying Requirements and ConstraintsLab 1: Capturing Business and Technical RequirementsReviewing Solution RequirementsIdentifying Further Information Requirements Module 2: Designing and Implementing a Logical OLAP Solution ArchitecturePlanning an OLAP SolutionDesigning and Implementing Fact and Dimension TablesDesigning and Implementing CubesLab 2: Designing and Implementing an OLAP SolutionDesigning and Implementing a Relational Database SchemaDesigning and Implementing a CubeDesigning and Implementing Perspectives Module 3: Designing Physical Storage for a Multidimensional SolutionDesigning Physical StoragePartitioning Relational DataPartitioning Multidimensional DataLab 3: Designing and Implementing Physical StorageDesigning and Implementing a Storage SolutionDesigning and Implementing Relational PartitioningDesigning and Implementing Multidimensional PartitioningTesting the Solution Module 4: Creating CalculationsImplementing Calculated MembersImplementing Named SetsImplementing Scoped MDX ScriptsLab 4: Implementing CalculationsCreating Calculated MembersCreating Named SetsCreating a Scoped MDX Script Module 5: Extending Cube FunctionalityKey Performance IndicatorsActionsStored ProceduresLab 5: Implementing Advanced FunctionalityCreating KPIsCreating ActionsCreating Stored Procedures Module 6: Designing an Analysis Services InfrastructureConsiderations for Analysis Services Resource RequirementsConsiderations for Analysis Services ScalabilityConsiderations for Analysis Services AvailabilityLab 6: Designing and Implementing Analysis Services InfrastructurePlanning Production System InfrastructureInstalling Analysis Services in a Cluster Module 7: Deploying a Multidimensional Solution into ProductionDeploying an Analysis Services DatabaseManaging Analysis Services SecurityLab 7: Deploying Analysis Services into ProductionDeploying an Analysis Services DatabaseEnabling User Access Module 8: Optimizing an OLAP SolutionMonitoring Analysis ServicesOptimizing PerformanceLab 8: Optimizing Analysis ServicesMonitoring Analysis ServicesOptimizing Queries Module 9: Implementing Data MiningIntroduction to Data MiningImplementing a Data Mining SolutionUsing Data Mining in a BI SolutionLab 9: Implementing Data MiningCreating a Data Mining Structure
