Contactar
About this course:
This five-day instructor-led course provides in-depth knowledge on designing a Business Intelligence solution by using Microsoft SQL Server 2008.At course completion:
After completing this course, students will be able to:Design a Business Intelligence (BI) architecture in SQL Server 2008.
Design a strategy for implementing the extract, transform, load (ETL) processby using SQL Server 2008 Integration Services (SSIS).
Design a strategy for managing packages by using SSIS.
Design an online analytical processing (OLAP) solution architecture by using SQL Server 2008 Analysis Services (SSAS).
Design a physical storage for an OLAP solution by using SSAS.
Design an administration and maintenance strategy for an SSAS solution.
Design effective queries for an OLAP solution by using SSAS.
Design and develop a SQL Server 2008 Reporting Services (SSRS) solution architecture.
Design a strategy for deploying and managing an SSRS solution architecture.
Design data mining solutions by using SQL Server 2008.
Audience profile:
The primary audience for this course is developers who have knowledge of Business Intelligence (BI) concepts, with an experience of 4-5 years in BI. The audience has an understanding of how to use SQL Server 2005 BI tools to implement a BI infrastructure and solution. However, the audience needs to develop an understanding of design principles and best practices when designing a BI solution. The target audience also includes BI developers with experience in using SQL Server 2008 BI features and tools, and who want to obtain a professional certification in BI development and design.The secondary audience for this course is information technology (IT) professionals, and Business Analysts who specialize in the area of BI.
Before attending this course, students must have:
Knowledge of data warehousing, data marts, and industry-accepted Business Intelligence (BI) methodologies.
Conceptual understanding of SQL Server 2005 and SQL Server 2008 components, such as online analytical processing (OLAP), extract, transform, load (ETL), and reporting tools and technologies.
Experience in developing and implementing cubes at the physical level.
Experience in working with data transformations.
Experience in creating star and snowflake schemas at both conceptual and logical levels.
Experience in writing MDX for customization and querying.
Fundamental understanding of Microsoft Windows security, such as how groups, delegation of credentials, and impersonation function in a security context.
Fundamental understanding of Web-based architecture.
-
Experience in using the following tools:
· Microsoft SQL Server BI Development Studio.
· Microsoft SQL Server Management Studio.
· Report Builder and Report Manager.
· Source Code Control (SCC) product.
Possible experience in using the following tools:
· Microsoft Office Visio.
· System Monitor.
Faculty:
Our team of highly qualified instructors combine training activities with the development of their profession as experts in the field of TIC. Professionals certified by the major manufacturers capable of transferring an enjoyable and easy to understand technical concepts more abstract.Documentation:
A copy of the official Microsoft documentation.Certification:
Lets get the Microsoft official diploma of the course "MOC 50399 - Designinga BUsiness Intelligence Solutions by using Microsoft SQL Server 2008" necessary for the certification "MCITP Business Intelligence Developer 2008".
Course outline:
Designing a Business Intelligence Architecture in Microsoft SQL Server
2008
1.1 Overview of BI Concepts.
1.2 Planning BI Solutions.
1.3 Planning the Development of a BI Solution.
1.4 Determining BI Requirements.
1.5 Determining Architectural Requirements of a BI Solution.
1.6 Planning the Microsoft BI Environment.
1.7 Overview of BI Operations Management.
Designing a Strategy for Implementing ETL by Using Microsoft SQL Server 2008 Integration Services
2.1 Planning Data Sources and Destinations.
2.2 Determining Staging Requirements.
2.3 Planning SSIS Packages.
2.4 Planning the Development of SSIS Packages.
2.5 Designing Data Flow.
2.6 Planning Data Flow Operations.
2.7 Extending SSIS Packages with Scripts.
Designing a Strategy for Managing Packages by Using Microsoft SQL Server 2008 Integration Services
3.1 Designing a Strategy for Logging ETL Operations.
3.2 Designing a Strategy for Managing Errors.
3.3 Designing and Implementing Reliable ETL Processes.
3.4 Designing a Strategy for Deploying and Maintaining SSIS Packages.
3.5 Designing a Strategy for Optimizing an SSIS Solution.
Designing an OLAP Solution Architecture by Using Microsoft SQL Server 2008 Analysis Services
4.1 Overview of an OLAP Solution.
4.2 Gathering Requirements for an OLAP Solution.
4.3 Designing a Logical OLAP Solution Architecture.
4.4 Designing Dimensions.
4.5 Designing Dimension Relationships.
4.6 Considerations for Implementing Cubes, KPIs, and Actions.
4.7 Global Considerations for an SSAS Solution.
Designing Physical Storage for an OLAP Solution by Using Microsoft SQL Server 2008 Analysis Services
5.1 Designing and Implementing Physical Storage for Dimensions.
5.2 Designing and Implementing a Partitioning Strategy for Relational Data.
5.3 Designing a Partitioning Strategy for Multidimensional Data.
5.4 Designing Aggregations.
Designing an Administration and Maintenance Strategy for a Microsoft SQL Server 2008 Analysis Services Solution
6.1 Determining SSAS Resource Requirements.
6.2 Considerations for Providing SSAS Scalability.
6.3 Considerations for Providing SSAS Availability.
6.4 Planning and Implementing a Deployment Strategy for an SSAS Solution.
6.5 Designing a Strategy for Monitoring an SSAS Solution
6.6 Securing an SSAS Solution.
6.7 Designing a Strategy for Optimizing the Performance of SSAS.
Designing Effective Queries for an OLAP Solution by Using Microsoft SQL Server 2008 Analysis Services
7.1 Designing Business Driven Calculations by Using MDX.
7.2 Working with MDX Queries.
7.3 Exploring MDX Query Context and Execution.
7.4 Optimizing MDX Queries.
7.5 Extending Multidimensional Expressions.
Designing and Developing a Microsoft SQL Server 2008 Reporting Services Solution Architecture
8.1 Analyzing the Business Requirements for a Reporting Solution.
8.2 Planning the Architecture for an SSRS Solution.
8.3 Designing a Data Acquisition Strategy.
8.4 Planning a Reporting Solution.
8.5 Designing Report Models.
8.6 Extending Reporting with Custom Code.
Designing a Strategy for Deploying and Managing a Microsoft SQL Server 2008 Reporting Services Solution Architecture
9.1 Planning the Integration of Reports with Applications.
9.2 Planning Security for a Reporting Solution.
9.3 Planning Reports Distribution.
9.4 Designing a Strategy for Managing Report Execution.
9.5 Designing a Strategy for Optimizing Report Performance.
9.6 Planning the Administration of SSRS.
Designing Data Mining Solutions by Using Microsoft SQL Server 2008
10.1 Fundamentals of Data Mining.
10.2 Designing a Mining Model and Structure.
10.3 Designing Strategies for Staging Data.
10.4 Visualizing Data Mining Results.
10.5 Testing Mining Models.