A data warehouse combines data from multiple sources that can be
used to create analytical reports. This course covers schemas and
tables that are created within it and how to create dimension and
fact tables.
Each data warehouse consists of at least one fact table, which
contains fundamental measurements of the business. This course
covers the implementation of fact tables using partitions, data
compression, and columnstore indexes.
Connection managers in a data warehouse are used to define the
data source connections. This course covers how to use connection
managers to specify source and destinations, as well as how to
create custom data sources.
When working with data in a data warehouse, some level of
transformation is usually required between the source and
destination. In this course, you will learn about transformation
and designing data flow.
ETL, extract, transform, and load, is the main process in data
warehousing solutions. It facilitates the transfer of the data from
a source to a destination. This course discusses the ETL process
and how it can be implemented.
Microsoft SQL Server Integration Services
(SSIS) is a platform that can be used to build packages for data
warehousing. This course will demonstrate how to create simple SSIS
packages and also explain script tasks.
Control flow consists of three elements: containers, tasks, and
precedence constraints, which can be used to provide structure,
functionality, and order of operations. This course shows how to
design control flow elements.
By using the control flow data flow task, data flow can be
implemented into the SSIS package specifying the data source, data
transformation, and data destination. This course shows how to
implement control flow elements.
SQL Server 2014 allows for the use of parameters, variables, and
expressions to create dynamic packages. This course covers SSIS
variable concepts, such as system variables, scope,
parameterization of properties, and data types.
SSIS in SQL Server 2014 allows for dynamic
SSIS is an extensible platform for creating data integration and
workflow solutions. In this course, you will explore various
options to load data.
SSIS can be installed during the SQL Server installation or as a
separate component. Before installation, there are a number of
factors needing consideration, such as upgrade options and
architecture. This course will cover SSIS components.
Auditing, Logging, and Event Handling
Troubleshooting Data Integration
SSIS consists of several layers, including package properties
and centralized management, to provide a rich and flexible
environment. This course covers SSIS catalog creation and package
deployment.
SSIS consists of several layers, including
Data Quality Services (DQS) and Master Data Services (MDS)
For anyone who is creating a data warehouse, data quality should
be one of the top priorities. In order to trust the results of data
analysis, high-quality data is essential. This course discusses
strategies for data quality projects.