Are you a SQL Server professional looking to expand your understanding of SQL Server 2012 data warehousing concepts and implementation? Or maybe you are preparing for Exam 70-463, a key component of the MCSA: SQL Server certification. Take this Jump Start course that focuses on the design of dimensions to support business intelligence (BI) in the organization, the implementation of extract, transform, and load (ETL) processes, and the implementation of enterprise-level master data and data quality. Watch the live demos to learn about building dimension tables in a data warehouse, implementing an ETL process with control flow and data flow definitions, configuring logging and event handling, deploying an ETL solution, and implementing master data and data quality solutions.Instructors | Rich Currey - Microsoft Certified Trainer; George Squillace - Microsoft Certified TrainerAssociated Exam(s) | 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012Related Certification | MCSA: SQL ServerAssociated Course(s) | 10777: Implementing a Data Warehouse with Microsoft SQL Server 2012
In this module, find out about the distinct differences between the data that you use to run your operational systems and the way that you need to consume that data to analyze your business. Understand the key design issues between the two as well as the impacts that they can have on your load process.
A key process in the development of a data warehouse is the extraction of data from your operational systems. In this module, you’ll hear about the methods available to you and the advantages and disadvantages of each, as well as learning how to configure communication between data sources and data destinations.
Is data ever in the form that you need it to be? Most data warehouse projects will require at least some level of transformation between the source and destination. In this module you’ll learn what data transformations are available in SQL Server Integration Services (SSIS) and how to implement them.
The process of loading data into a data warehouse is typically a complex process with many steps and dependencies. This module teaches you how to build these complex workflows and how to define the dependencies to ensure that data is piped through to its correct destinations.
This module covers development through testing into production. Learn how to configure your projects to easily manage the transitions from one environment to another with a minimum of manual intervention. Learn the details of error management, logging, and transactional management as well, to ensure that if and when something happens, you can recover with the minimum of effort.
What is the biggest fairy tale in IT? My data is clean!! In this module, learn how Data Quality Services and Master Data Services can provide you with a solution that has a single source of validated data for all operational data stores in your organization.
Please peruse this section for additional information that supports this Jump Start event. This is an opportunity for you to dive deeper into Implementing a Data Warehouse with SQL Server at your own pace.
Free Microsoft Training Delivered by Experts