Course Details

Previous Page


Microsoft SQL Server Data Warehousing and Business Intelligence Overview


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



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