Your Cart Is Empty
Home > Technical Courses > SQL Server > Implementing a Data Warehouse with SQL Server 2014 (20463)
In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution.
In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services.This course incorporates material from the Official Microsoft Learning Product 20463: Implementing a Data Warehouse with Microsoft SQL Server. It covers the skills and knowledge measured by Exam 70-463 and along with on-the-job experience, helps you prepare for the exam.
Category
ID
Duration
Level
Price
SQL Server
M20463
5 Day(s)
Intermediate
$3,095.00
Objectives
· Data warehouse concepts and architecture considerations· Select an appropriate hardware platform for a data warehouse· Design and implement a data warehouse· Implement data flow and control flow in a SSIS package· Debug and troubleshoot SSIS packages· Implement a SSIS solution that supports incremental data warehouse loads and extracting data· Implement data cleansing using Microsoft DQS· Implement Master Data Services (MDS) to enforce data integrity· Extend SSIS with custom scripts and components· Deploy and configure SSIS packages· How Business Intelligence solutions consume data in a data warehouse
1. Data WarehousingConcepts and Architecture ConsiderationsConsiderations for a Data Warehouse Solution2. Data Warehouse InfrastructureHardware SelectionsConsiderations for Business Intelligence Infrastructure3. Design and Implement a Data WarehouseLogical Design, Including Dimension Tables and Fact TablesPhysical Implementation, Including a Star Schema, Snowflake Schema, and Time Dimension4. Create an ETL Solution with SSISETL with SSISExplore Source DataImplement Data Flow5. Implement Control Flow in an SSIS PackageControl FlowCreate Dynamic PackagesUsing ContainersManage Consistency with Transactions and Checkpoints6. Debug and Troubleshoot SSIS PackagesDebug an SSIS PackageLog SSIS Package EventsImplement an Event HandlerHandle Errors in an SSIS Package7. Implement an Incremental ETL ProcessIncremental ETLData and Modified Data Extraction8. Load Data into a Data WarehouseData and Modified Data Load planningIncremental loads Using SSISTransact-SQL Loading Techniques
9. Enforce Data QualityMicrosoft SQL Server DQSUse DQS to Cleanse DataUse DQS to Match Data10. Master Data ServicesMaster Data Services ConceptsImplement a Master Data Services ModelMaster Data Services Tools to Manage and Create Master Data11. Extend SSISCustom Components in SSISScripting in SSIS12. Deploy and Configure SSIS PackagesDeployment ConsiderationsDeploy SSIS ProjectsPlan SSIS Package Execution13. Consume Data in a Data WarehouseBusiness Intelligence SolutionsEnterprise BI SolutionSelf-Service BI and Big Data SolutionsLabsLab 1: Explore a Data Warehouse SolutionLab 2: Data Warehouse Infrastructure PlanningLab 3: Data Warehouse ImplementationLab 4: Implement Data Flow in a SSIS PackageLab 5A: Implement Control Flow in a SSIS PackageLab 5B: Transactions and Checkpoints UsageLab 6: Debug and Troubleshoot a SSIS PackageLab 7: Extract Modified DataLab 8: Data Warehouse LoadingLab 9: Cleanse DataLab 10: Implement Master Data ServicesLab 11: Custom ScriptsLab 12: Deploy and Configure SSIS PackagesLab 13: Data Warehouse Usage in Enterprise and Self-Service BI Scenarios
Questions?
MCSA: SQL Server 2012/2014
· Minimum two years experience working with relational databases, including designing a normalized database, creating tables and relationships· Basic programming constructs, including looping and branching· Focus on key business priorities, such as revenue, profitability, and financial account· Querying Microsoft SQL Server (M20461)
Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.
Productivity Point Headquarters 1580 Sawgrass Corporate Parkway Suite 205 Sunrise, Florida 33323 United States
Contact T 1-844-238-8607 P 1-954-425-6141 F 1-954-928-9057 E info@productivitypointls.com