• Online, Self-Paced
Course 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.

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

  • 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

Practice: Data Warehousing and BI

  • create and query a data warehouse in SQL Server

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.