Implementing BI Infrastructure

SQL Server 2014    |    Expert
  • 10 Videos | 1h 3m 46s
  • Includes Assessment
  • Earns a Badge
Likes 44 Likes 44
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

  • Playable
    1. 
    Estimate MCR, CPU, and RAM Requirements
    7m 7s
    UP NEXT
  • Playable
    2. 
    Determining Storage Requirements
    5m 14s
  • Locked
    3. 
    Data Warehouse Database Design
    3m 55s
  • Locked
    4. 
    Designing Dimension Modeling and Documentation
    6m 44s
  • Locked
    5. 
    Designing Dimension Keys, Attributes, and Hierarchies
    6m 37s
  • Locked
    6. 
    Designing Slowly Changing Data and Unknown Values
    6m 30s
  • Locked
    7. 
    Designing Time Dimension Tables
    5m 52s
  • Locked
    8. 
    Designing Self-referencing Dimension Tables
    5m 33s
  • Locked
    9. 
    Types of Columns for a Fact Table
    5m 19s
  • Locked
    10. 
    Types of Measures Stored and Common Fact Tables
    6m 26s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 38 Likes 38  
Likes 121 Likes 121  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 37 Likes 37