Microsoft SQL Server Data Warehousing and Business Intelligence Overview

This course is included in our On-demand training solution.

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

Prerequisites

None

Expected Duration

120 min.

Course Objectives

Course Introduction

Data Warehousing Overview

  • describe data warehousing
  • Business Intelligence Overview

  • recognize the key concepts of business intelligence
  • Normalization and Denormalization

  • recognize the function of normalization in OLTP databases and denormalization in OLAP databases
  • Fact and Dimension Tables

  • describe dimension and fact tables in OLAP databases
  • Data Warehouse Schemas

  • recognize the star and snowflake schemas in data warehouse databases, and the role of KPIs in business intelligence
  • Creating a Fact Table

  • create a fact table in a data warehouse database in SQL Server
  • Creating a Dimension Table

  • create a dimension table in a data warehouse database in SQL Server
  • Create a Columnstore Index in SQL Server

  • create a columnstore index in a data warehouse database in SQL Server
  • Table and Index Partitioning

  • create a table and index partition in a data warehouse database in SQL Server
  • Implementing Data Compression

  • implement data compression in a data warehouse database in SQL Server
  • Creating a Simple SSIS Package

  • create a simple SSIS package in SQL Server using SQL Server Data Tools
  • Creating a Control Flow

  • create a control flow in SQL Server using SQL Server Data Tools
  • Creating a Data Flow

  • create a data flow in SQL Server using SQL Server Data Tools
  • Creating a Transform

  • create a transform in SQL Server using SQL Server Data Tools
  • Deploying an SSIS Package

  • deploy an SSIS package in SQL Server
  • Creating an SSAS Project

  • create a SQL Server Analysis Service project using SQL Server Data Tools
  • Creating an SSAS Data Source

  • create a data source in SQL Server Analysis Services using SQL Server Data Tools
  • Creating an SSAS Cube

  • create a cube in SQL Server Analysis Services using SQL Server Data Tools
  • Deploying SSAS

  • deploy SQL Server Analysis Services
  • Querying SSAS

  • query SQL Server Analysis Services using Excel
  • Connecting SSRS to a Data Source

  • connect to a data source to create a report in SQL Server Report Builder
  • Creating a Report

  • create a basic SQL Server Report
  • Creating a Report with Calculations

  • create a SQL Server report with calculations
  • Creating Reports with Interactivity

  • create a SQL Server report with end user interactive elements
  • Deploying a SQL Server Report

  • deploy a SQL Server report
  • Exercise: Data Warehousing and BI

    SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?