Agile Data Warehouse Design Training Video

Courses For Success
Online

AU$ 189 - (132 )
+IVA

Informazione importanti

  • Corso
  • Online
  • Quando:
    Da definire
Descrizione

In this project-based Agile Data Warehouse Design video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course to get: Concise, informative and broadcast-quality Agile Data Warehouse Design training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Agile Data Warehouse Design subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Agile Data Warehouse Design tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 7 hours to complete this course 104 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Agile Data Warehouse Design training course, expert author Michael Blaha will teach you how to model and design a data warehouse. This course is designed for users that are already familiar with data warehouses.

You will start with a data warehouse overview, then jump into learning about data sources, such as customer order, customer account, and vendor procurement. From there, Michael teaches you about staging tables, basic data warehouse modeling, recurrent dimensions, and advanced dimension data warehouse modeling. This video tutorial also covers data warehouse design, data warehouse data, and end user access. Finally, you will learn about metadata management.

Once you have completed this computer based training course, you will be fully capable of modeling and designing your own data warehouse.

Informazione importanti

Requisiti: System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Sedi

Dove e quando

Inizio Luogo
Da definire
Online

Cosa impari in questo corso?

Management
Access
Self assessment
SQL
Design
IT Development
IT Management

Programma

  • 01. Getting Started
    • About The Course
    • About The Author
    • What Is A Data Warehouse?
    • Comparing Operational Applications And Data Warehouses
    • 0105 How To Access Your Working Files
  • 02. Data Warehouse Overview
    • Development Approach
    • Data Sources
    • Staging Tables
    • Data Warehouse Model
    • Data Warehouse Design
    • Data Warehouse Data
    • End User Access, Old Data, And Metadata Management
    • Introduction To The Case Study
  • 03. Data Sources
    • 0301 Data Modeling Review - Part 1
    • 0302 Data Modeling Review - Part 2
    • 0303 Data Sources Overview
    • 0304 Source Data: Menu Definition
    • 0305 Source Data: Miscellaneous Metadata
    • 0306 Source Data: Customer Order
    • 0307 Source Data: Customer Account
    • 0308 Source Data: Customer Prospect
    • 0309 Source Data: Vendor Procurement
    • 0310 Case Study: Assess Source Data
  • 04. Staging Tables
    • 0401 Staging Tables Overview
    • 0402 Case Study: Create Staging Model
  • 05. Data Warehouse Modeling Basics
    • 0501 The Star Schema
    • 0502 Dimension
    • 0503 Fact
    • 0504 Surrogate Keys
    • 0505 The Bus Architecture
    • 0506 Dimensional Modeling And Agile Development
    • 0507 Practical Tips
    • 0508 Self Assessment Test
    • 0509 Case Study: Business Requirements
    • 0510 Case Study: Bus Architecture
  • 06. Recurrent Dimensions
    • 0601 Date
    • 0602 Time
    • 0603 Customer
    • 0604 Account
    • 0605 Employee
    • 0606 Unit of Measure
    • 0607 Product
    • 0608 Currency
    • 0609 Audit
    • 0610 Case Study: Initial Warehouse Model - Part 1
    • 0611 Case Study: Initial Warehouse Model - Part 2
    • 0612 Case Study: Initial Warehouse Model - Part 3
  • 07. DW Modeling - Advanced Dimension
    • 0701 Kinds of Conformed Dimensions
    • 0702 Junk Dimension
    • 0703 Degenerate Dimension
    • 0704 Slowly Changing Dimension - Part 1
    • 0705 Slowly Changing Dimension - Part 2
    • 0706 Snowflake, Outrigger, and Bridge
    • 0707 Swappable Dimension
    • 0708 Master Dimension
    • 0709 Hierarchy
    • 0710 Practical Tips
    • 0711 Self Assessment Test
    • 0712 Case Study: Elaborate Dimensions
  • 08. DW Modeling - Advanced Fact
    • 0801 Kinds Of Facts
    • 0802 Transaction Fact
    • 0803 Periodic Snapshot
    • 0804 Accumulating Snapshot
    • 0805 Aggregate Fact
    • 0806 Consolidated Fact
    • 0807 Practical Tips
    • 0808 Case Study: Elaborate Facts
  • 09. Data Warehouse Modeling Recap
    • 0901 Warehouse Modeling Review
    • 0902 Common Warehouse Modeling Mistakes
  • 10. Data Warehouse Design
    • 1001 Conceptual, Logical, Physical Models
    • 1002 System Attributes - Part 1
    • 1003 System Attributes - Part 2
    • 1004 Data Types And Domains
    • 1005 Nullability
    • 1006 Constraints
    • 1007 Data Warehouse Tuning - Part 1
    • 1008 Data Warehouse Tuning - Part 2
    • 1009 Views - Part 1
    • 1010 Views - Part 2
    • 1011 Miscellaneous Aspects Of Design
    • 1012 Practical Tips
    • 1013 Self Assessment Test
    • 1014 Case Study: Create Staging SQL
    • 1015 Case Study: Execute Staging SQL
    • 1016 Case Study: Create Warehouse SQL
    • 1017 Case Study: Execute Warehouse SQL
  • 11. Data Warehouse Data
    • 1101 Warehouse Data Overview
    • 1102 Source-To-Target Mappings
    • 1103 Data Profiling
    • 1104 Loading Staging Tables - Part 1
    • 1105 Loading Staging Tables - Part 2
    • 1106 Loading The Date and Time Dimensions - Part 1
    • 1107 Loading The Date and Time Dimensions - Part 2
    • 1108 Initial Warehouse Loading: Dimensions
    • 1109 Initial Warehouse Loading: Facts
    • 1110 Updating The Warehouse
    • 1111 Warehouse Data Processing And Agile Development
    • 1112 Case Study: Load Warehouse Data
  • 12. End User Access
    • 1201 End User Access Overview
    • 1202 Case Study: Analyze Data - Part 1
    • 1203 Case Study: Analyze Data - Part 2
  • 13. Data And Metadata Management
    • 1301 Offload Of Old Data
    • 1302 Metadata Management
  • 14. Conclusion
    • 1401 Course Wrap-Up

Ulteriori informazioni

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download...