Microsoft SQL Server Data Warehousing and Business Intelligence Overview Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description
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.
Target Audience
IT and business professionals with an interest in harvesting business intelligence from SQL Server databases
Prerequisites
None
Expected Duration (hours)
2.0
Lesson Objectives Microsoft SQL Server Data Warehousing and Business Intelligence Overview
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
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
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
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
connect to a data source to create a report in SQL Server Report Builder
create a basic SQL Server Report
create a SQL Server report with calculations
create a SQL Server report with end user interactive elements
deploy a SQL Server report
create and query a data warehouse in SQL Server
Course Number: md_dwbi_a01_it_enus
Expertise Level
Intermediate