A data warehouse combines data from multiple sources that can be used to create analytical reports. This course covers schemas and tables that are created within it and how to create dimension and fact tables.
Dimensions in SQL Server 2014
start the course
describe the SQL Server Business Intelligence platform
understand slowly changing dimensions
describe how to implements dimensions and attributes
describe how to design hierarchies
recognize attributes of star and snowflake schemas
describe how to implement fact tables
determine when to use auditing and lineage
recognize when to use keys
implement data lineage of a dimension table
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.