Microsoft SQL Server Data Warehousing and Business Intelligence Overview from Skillsoft

Online, Self-Paced

As capabilities and capacities of modern computers continue to proliferate, data warehousing, and business intelligence more broadly, have become fundamental to maintaining business competitiveness. This course describes the concepts and methodologies involved in creating data warehouses and using them to extract business intelligence.

Learning Objectives

Data Warehousing and Business Intelligence

start the course
describe data warehousing
recognize the key concepts of business intelligence
recognize the function of normalization in OLTP databases and denormalization in OLAP databases
describe dimension and fact tables in OLAP databases
recognize the star and snowflake schemas in data warehouse databases, and the role of KPIs in business intelligence

SQL Server Data Warehousing

create a fact table in a data warehouse database in SQL Server
create a dimension table in a data warehouse database in SQL Server
create a columnstore index in a data warehouse database in SQL Server
create a table and index partition in a data warehouse database in SQL Server
implement data compression in a data warehouse database in SQL Server

SQL Server Integration Services

create a simple SSIS package in SQL Server using SQL Server Data Tools
create a control flow in SQL Server using SQL Server Data Tools
create a data flow in SQL Server using SQL Server Data Tools
create a transform in SQL Server using SQL Server Data Tools
deploy an SSIS package in SQL Server

SQL Server Analysis Services

create a SQL Server Analysis Service project using SQL Server Data Tools
create a data source in SQL Server Analysis Services using SQL Server Data Tools
create a cube in SQL Server Analysis Services using SQL Server Data Tools
deploy SQL Server Analysis Services
query SQL Server Analysis Services using Excel

SQL Server Reporting Services