Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (Examen: 70-467)
€2290, aangeboden door Master it Training
Deze vijfdaagse training leert de deelnemers een BI infrastructuur te ontwerpen en implementeren. Deze training behandelT het ontwerp, de installatie en het onderhouden van een BI platform.Deze training richt zich op de vaardigheden en kennis die getoetst worden bij het examen 70467: Designing Business Intelligence Solutions with Microsoft SQL Server. Gecombineerd met praktische ervaring bereidt deze training je voor op dit examen.Let op!Wij raden cursisten aan om deze training binnen 30 dagen af te ronden voor het beste resultaat. De training maakt gebruik van Azure in de lab omgeving en deze is maar 30 dagen beschikbaar.Na afronding van deze training kun je: De onderdelen van een BI oplossing plannen; Een data warehouse ontwerpen; Een ETL oplossingen ontwerpen; Data modellen voor analyse plannen; Een BI delivery oplossing plannen; Reporting Services oplossing ontwerpen; Excel rapportage oplossing ontwerpen; Een Sharepoint Server BI oplossing plannen; Een BI oplossing monitoren en optimaliseren; BI handelingen voorbereiden.
Let op. Deze training is exclusief het examen.
Doelgroep
Deze training is bedoeld voor BI professionals zoals BI Architecten of database professionals die BI oplossingen ontwerpen: BI architecten die verantwoordelijk zijn voor het totaal ontwerp van de BI infrastructuur en hoe deze relateert aan andere gebruikte systemen; Hun verantwoordelijkheden bestaan onder andere uit Online Analytical Processing (OLAP) cube ontwerp en integratie met Microsoft SharePoint of lineofbusiness toepassingen; Ze zouden deze vaardigheden kunnen toepassen in een Windows Azure SQL Server database omgeving.
Voorkennis voor de Designing Business Intelligence Solutions with Microsoft SQL Server 2012 training
Basiskennis van dimensionaal modelleren (ster schema) voor data warehouses; Integration Services Packages kunnen maken met daarin control flows en data flows; Een basis "multidimensional cube" kunnen maken met Analysis Services; Basale tabellarisch modellen kunnen maken met PowerPivot en Analysis Services; Reporting Services reports kunnen maken met Report Designer; Authenticatie en toegang in de SQL Server database engine, Analysis diensten en Reporting Services kunnen implementeren; Bekend zijn met SharePoint Server en Microsoft Office applicaties, voornamelijk Excel.Je kunt aan deze vereisten voldoen door de onderstaande trainingen te volgen of door te beschikken over gelijkwaardige kennis en vaardigheden: MS10777: Implementing a Data Warehouse with Microsoft SQL Server 2012; MS10778: Implementing Data Models and Reports with Microsoft SQL Server 2012.
Examen
70-467
Onderwerpen in de Designing Business Intelligence Solutions with Microsoft SQL Server 2012 training
Module 1: Planning a BI SolutionThis module discusses how to plan the components of a BI solution.Lessons Elements of a BI Solution The Microsoft BI Platform Planning a BI ProjectLab : Planning a BI Solution Scoping a BI Solution Determining Software RequirementsAfter completing this module, students will be able to: Describe elements of a BI Solution. Describe how Microsoft products can be used to implement a BI solution. Describe considerations for a BI project.Module 2: Planning SQL Server Business Intelligence InfrastructureThis module explains how to plan an appropriate BI infrastructure for a given set of BI services.Lessons Considerations for BI Infrastructure Planning Data Warehouse HardwareLab : Planning a BI Infrastructure Planning Server Topology Planning Data Warehouse Server HardwareAfter completing this module, students will be able to: Describe key considerations for BI infrastructure. Plan data warehouse infrastructure.Module 3: Designing a Data WarehouseThis module explains how to design a data warehouse for a given set of user requirements.Lessons Data Warehouse Design Overview Designing Dimension Tables Designing Fact Tables Designing a Data Warehouse Physical ImplementationLab : Designing a Data Warehouse Logical Schema Identifying Business Processes and Dimensions Designing Dimension Models and Data Warehouse TablesLab : Designing a Data Warehouse Physical Implementation Designing File Storage Designing Warehouse Data StructuresAfter completing this module, students will be able to: Describe a process for designing a dimensional model for a data warehouse. Design dimensions tables for a data warehouse. Design fact tables for a data warehouse. Design and implement effective physical data structures for a data warehouse.Module 4: Designing an ETL SolutionThis module explains how to design an ETL solution for a data warehouse.Lessons ETL Overview Planning Data Extraction Planning Data Transformation Planning Data LoadsLab : Designing an ETL Solution Preparing for ETL Design Creating SourcetoTarget Documentation Using SSIS To Load a Partitioned Fact TableAfter completing this module, students will be able to: Describe considerations for designing an ETL solution. Plan data extraction. Plan data transformations. Plan Data loads.Module 5: Designing Analytical Data ModelsThis module explains how to design analytical data models for specific BI scenarios.Lessons Introduction to Analytical Data Models Designing an Analytical Data Model Designing Dimensions Enhancing Data ModelsLab : Comparing Analytical Data Models Creating a Multidimensional Data Model Creating a Tabular Data ModelLab : Designing Dimensions and Hierarchies Creating Dimensions in a Multidimensional Data Model Creating Dimensions in a Tabular Data ModelLab : Enhancing Analytical Data Models Enhancing a Multidimensional Data Model Enhancing a Tabular Data ModelAfter completing this module, students will be able to: Describe options for analytical data models. Design an initial multidimensional or tabular data model. Design dimensions in a multidimensional or tabular data model. Design measures and cubes in a multidimensional or tabular data model.Module 6: Planning a BI Delivery SolutionThis module explains how to choose an appropriate delivery solution for a given scenario.Lessons Considerations for Delivering BI Common Reporting Scenarios Choosing a Reporting ToolLab : Planning a BI Delivery Solution Assessing Reporting RequirementsAfter completing this module, students will be able to: Describe considerations for delivering BI to users. Describe the key features of common reporting scenarios. Choose an appropriate reporting tool for a particular reporting scenario.Module 7: Designing a Reporting Services SolutionThis module explains how to design a Reporting Services solution.Lessons Planning a Reporting Services Solution Designing Reports Planning Report ConsistencyLab : Designing a Reporting Services Solution Designing a Reporting Environment Creating Reusable Report Item Creating ReportsAfter completing this module, students will be able to: Plan a Reporting Services solution. Design reports. Plan report consistency.Module 8: Designing a Microsoft ExcelBased Reporting SolutionThis module explains how to design a reporting solution that uses Excel.Lessons Using Excel for Data Analysis and Reporting PowerPivot for Excel Power View for ExcelLab : Designing an Excel Reporting Solution Exercise 1: Planning Excel Features Exercise 2: Analyzing a Cube with Excel Exercise 3: Creating a PowerPivot Workbook Exercise 4: Using Power View in ExcelAfter completing this module, students will be able to: Describe Excel features that enable users to analyze data. Configure and use PowerPivot for Excel. Configure and use Power View in an Excel workbook.Module 9: Planning a SharePoint Server BI SolutionThis module explains how to design a SharePoint BI solution.Lessons Introduction to SharePoint Server as a BI Platform Planning Security for a SharePoint Server BI Solution Planning Reporting Services Configuration Planning PowerPivot Configuration Planning for PerformancePoint ServicesLab : Implementing a SharePoint Server BI Solution Exercise 1: Creating a SharePoint Server Site for BI Exercise 2: Configuring Reporting Services in SharePoint Server Exercise 3: Configuring PowerPivot for SharePointLab : Implementing a PerformancePoint Services Exercise 1: Creating a PerformancePoint DashboardAfter completing this module, students will be able to: Describe SharePoint Server as a BI platform. Plan security for a SharePoint Server BI solution. Plan Reporting Services configuration. Plan PowerPivot configuration. Plan for PerformancePoint Services.Module 10: Monitoring and Optimizing a BI SolutionThis module explains how to monitor and optimize a BI solution.Lessons Overview of BI Monitoring Monitoring and Optimizing the Data Warehouse Monitoring and Optimizing Analysis Services Monitoring and Optimizing Reporting ServicesLab : Monitoring and Optimizing a BI Solution Monitoring and Optimizing a Data Warehouse Monitoring and Optimizing Analysis Services Monitoring and Optimizing Reporting ServicesAfter completing this module, students will be able to: Describe key considerations for monitoring a BI solution. Monitor and optimize a data warehouse. Monitor and optimize SQL Server Analysis Services. Monitor and optimize SQL Server Reporting Services.Module 11: Operating a BI SolutionThis module explains how to plan management and maintenance operations for a BI solution.Lessons Overview of BI Operations ETL Operations Data Warehouse Operations Analysis Services Operations Reporting Services OperationsLab : Operating a BI Solution Configuring SQL Server Integration Services Automate Data Warehouse Load Tasks Test Automated OperationsAfter completing this module, students will be able to: Describe core considerations for BI operations. Describe considerations and strategies for managing ETL operations. Describe considerations and strategies for managing data warehouse operations. Describe considerations and strategies for managing Analysis Services operations. Describe considerations and strategies for managing Reporting Services operations.