Implementing BI Infrastructure

SQL Server 2014    |    Expert
  • 10 videos | 59m 16s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
How the database is designed will greatly impact the analysis and reporting of the data it contains. Examine data warehouse design, including dimension and fact table design, for a BI solution.

WHAT YOU WILL LEARN

  • Determine the mcr, cpu, and ram requirements for a data warehouse database
    Determine the storage requirements for a data warehouse database
    Describe the key tasks and steps in designing a data warehouse database in a bi project
    Design a dimensional model for the business process using a matrix design and document it
    Design dimension keys, attributes, and hierarchies, given a scenario
  • Design slowly changing data and unknown values for a dimension
    Design time dimension tables based on a scenario
    Design self-referencing dimension tables based on a scenario
    Describe the types of columns in a fact table and how to determine the level of grain
    Describe the types of measures in a fact table and the types of fact tables commonly used

IN THIS COURSE

  • 7m 7s
    In this video, find out how to determine the minimum capacity requirements (MCR), central processing unit (CPU) requirements, and random access memory (RAM) requirements for a data warehouse database. FREE ACCESS
  • 5m 14s
    In this video, you will learn how to determine the storage requirements for a data warehouse database. FREE ACCESS
  • Locked
    3.  Data Warehouse Database Design
    3m 55s
    Upon completion of this video, you will be able to describe the key tasks and steps in designing a data warehouse database for a BI project. FREE ACCESS
  • Locked
    4.  Designing Dimension Modeling and Documentation
    6m 44s
    In this video, find out how to design a dimensional model for the business process using a matrix design and document it. FREE ACCESS
  • Locked
    5.  Designing Dimension Keys, Attributes, and Hierarchies
    6m 37s
    In this video, learn how to design dimension keys, attributes, and hierarchies for a given scenario. FREE ACCESS
  • Locked
    6.  Designing Slowly Changing Data and Unknown Values
    6m 30s
    Learn how to design slowly changing data and unknown values for a dimension. FREE ACCESS
  • Locked
    7.  Designing Time Dimension Tables
    5m 52s
    In this video, find out how to design time dimension tables based on a scenario. FREE ACCESS
  • Locked
    8.  Designing Self-referencing Dimension Tables
    5m 33s
    In this video, learn how to design dimension tables that reference themselves based on a scenario. FREE ACCESS
  • Locked
    9.  Types of Columns for a Fact Table
    5m 19s
    Upon completion of this video, you will be able to describe the types of columns in a fact table and how to determine the level of grain. FREE ACCESS
  • Locked
    10.  Types of Measures Stored and Common Fact Tables
    6m 26s
    After completing this video, you will be able to describe the types of measures in a fact table and the types of fact tables commonly used. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Database Business Intelligence
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Channel Data Warehousing
Rating 3.0 of 1 users Rating 3.0 of 1 users (1)
Course CompTIA Data+: Understanding Databases
Rating 4.8 of 44 users Rating 4.8 of 44 users (44)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Business Analysis Overview
Rating 4.4 of 4719 users Rating 4.4 of 4719 users (4719)
Course Data Warehousing & Business Intelligence Implementation
Rating 4.5 of 67 users Rating 4.5 of 67 users (67)
Course BI Reporting & Analysis
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)