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.YOU MIGHT ALSO LIKE
Rating 4.5 of 175 users
(175)
