Microsoft SQL Server Data Warehousing and Business Intelligence Overview
Interactive

Microsoft SQL Server Data Warehousing and Business Intelligence Overview

Skillsoft
Updated Oct 17, 2019

Course Overview

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


Learning Objectives

  • 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