Designing a Fact Table

Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisite
None

Expected Duration
67 minutes

Description
Each data warehouse consists of at least one fact table, which contains fundamental measurements of the business. This course covers the implementation of fact tables using partitions, data compression, and columnstore indexes.

Objective

Design and Implement Fact Tables

  • start the course
  • describe data warehousing and its many relationships
  • appropriately index a fact table
  • describe columnstore indexes
  • demonstrate partitioning
  • recognize when to use additive and nonadditive measures
  • implement a fact table
  • determine the loading method for fact tables
  • design summary aggregation tables

Practice: Data Warehouse Database

  • implement a data warehouse database in SQL Server 2014

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.