Implementing BI Infrastructure
SQL Server 2014
| Expert
- 10 videos | 59m 16s
- Includes Assessment
- Earns a Badge
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 7sIn 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 14sIn this video, you will learn how to determine the storage requirements for a data warehouse database. FREE ACCESS
-
3. Data Warehouse Database Design3m 55sUpon 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
-
4. Designing Dimension Modeling and Documentation6m 44sIn this video, find out how to design a dimensional model for the business process using a matrix design and document it. FREE ACCESS
-
5. Designing Dimension Keys, Attributes, and Hierarchies6m 37sIn this video, learn how to design dimension keys, attributes, and hierarchies for a given scenario. FREE ACCESS
-
6. Designing Slowly Changing Data and Unknown Values6m 30sLearn how to design slowly changing data and unknown values for a dimension. FREE ACCESS
-
7. Designing Time Dimension Tables5m 52sIn this video, find out how to design time dimension tables based on a scenario. FREE ACCESS
-
8. Designing Self-referencing Dimension Tables5m 33sIn this video, learn how to design dimension tables that reference themselves based on a scenario. FREE ACCESS
-
9. Types of Columns for a Fact Table5m 19sUpon 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
-
10. Types of Measures Stored and Common Fact Tables6m 26sAfter 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.
