Agile Data Warehouse Design Training Video

Course

Online

£ 98.75 + VAT

*Indicative price

Original amount in AUD:

$ 189

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Management
  • Access
  • Self assessment
  • SQL
  • Design
  • IT Development
  • IT Management

Course programme

  • 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

Additional information

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 purchase?

Once you complete your purchase, you will receive an email with an Access Key, and instructions on how to download your purchase. You will enter that Access Key...

Agile Data Warehouse Design Training Video

£ 98.75 + VAT

*Indicative price

Original amount in AUD:

$ 189