TDWI Data Warehouse Automation: Better, Faster, Cheaper Training in Denmark

  • Learn via: Classroom / Virtual Classroom / Online
  • Duration: 1 Day
  • Price: Please contact for booking options
We can host this training at your preferred location. Contact us!

Building a data warehouse is among the most labor-intensive and time-consuming activities of BI development. There are many moving parts—requirements, source data analysis, source-target mapping, data acquisition, data transformation logic, ETL design, database loading, scheduling, error handling—and getting it right the first time isn’t easy. When you finally do get it right, something changes. One of the most pervasive problems in BI today is the fact that data warehouses take too long to build and they are hard to change!

Data warehouse automation (DWA) is a relatively new class of technology that accelerates warehouse development and change cycles while simultaneously assuring quality and consistency. More than simply generating ETL scripts, DWA automates the entire life cycle from source system analysis to testing and documentation. Productivity gains, cost savings, and quality improvement are all possible with DWA.

There is no prerequisite.

BI and data warehousing program and project managers; data integration architects, designers, and developers; data warehouse operations, maintenance, and support personnel; data and technology architects.

  • Concepts, principles, and practices of data warehouse automation (DWA)
  • The current state of DWA technology
  • Automation opportunities and benefits when building or managing a data warehouse
  • How to get started with DWA
  • Best practices and mistakes to avoid with DWA

Module 1 – Data Warehouse Automation Concepts and Principles

  • Data Warehouse Automation Basics
    • Data Warehouse Automation Defined
    • Automated vs. Hand-Crafted
    • Automation vs. Customization
    • Data Warehouse Automation vs. CASE
  • Why Data Warehouse Automation
    • Business Benefits
    • Technical Benefits
    • Barriers and Resistance
  • The Foundation
    • Components of Data Warehousing
    • Data Warehousing Projects
    • Design Patterns
  • Activities and Deliverables
    • Data Warehousing Processes
    • What Can You Automate?
  • The Technology Landscape
    • Automation Tools and Vendors

Modue 2 – Building and Managing the Data Warehouse

  • The Data Warehousing Lifecycle
    • A Closed Loop
    • Architecture and Planning
    • Implementation
    • Deployment and Operations
  • Building the Data Warehouse
    • Requirements Driven Development
    • Modeling and Metadata Driven Development
    • Discovery Driven Development
    • Data Driven Development
  • Managing the Data Warehouse
    • Operations
    • Monitoring and Tuning
    • Maintenance and Change
    • Evolution
    • Support

Module 3 – Using Data Warehouse Automation

  • Automation Use Cases
    • Building an New Data Warehouse
    • Building Dependent Data Marts
    • Building Dimensional Data Marts
    • Conforming Independent Data Marts
    • Data Warehouse Prototyping
    • Agile Data Warehousing
    • Data Warehouse Migration
    • Re-Architecting the Data Warehouse
    • Warehouse Management
  • Case Studies
    • Arch Insurance Group
    • British American Tobacco
    • F5 Networks
    • Lamar
    • ProShop
    • Shell Oil
    • Union Bank

Module 4 – Data Warehouse Automation in Action

  • BIReady in Action
    • Product Overview
    • Demonstration
  • Kalido in Action
    • Product Overview
    • Demonstration
  • TimeXtender in Action
    • Product Overview
    • Demonstration
  • WhereScape in Action
    • Products Overview
    • WhereScape RED
    • Demonstration

Module 5 – Getting Started with Data Warehouse Automation

  • Step by Step
    • A Process for Automation
  • Human Factors
    • People and Automation
  • New Horizons
    • Automation and Data Warehousing Trends
  • Next Steps
    • Making Your Plans


Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Denmark facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

25 januar 2025 (1 Day)
Kopenhag, Aarhus, Odense
Classroom / Virtual Classroom
27 januar 2025 (1 Day)
Kopenhag, Aarhus, Odense
Classroom / Virtual Classroom
25 januar 2025 (1 Day)
Kopenhag, Aarhus, Odense
Classroom / Virtual Classroom
27 januar 2025 (1 Day)
Kopenhag, Aarhus, Odense
Classroom / Virtual Classroom
25 februar 2025 (1 Day)
Kopenhag, Aarhus, Odense
Classroom / Virtual Classroom
03 marts 2025 (1 Day)
Kopenhag, Aarhus, Odense
Classroom / Virtual Classroom
25 februar 2025 (1 Day)
Kopenhag, Aarhus, Odense
Classroom / Virtual Classroom
03 marts 2025 (1 Day)
Kopenhag, Aarhus, Odense
Classroom / Virtual Classroom
TDWI Data Warehouse Automation: Better, Faster, Cheaper Training Course in Denmark

Denmark is a constitutionally unitary state that is in Northern Europe. The population of the country is 5.91 million and 800,000 of them live in the capital and largest city, Copenhagen. And Danish is the official language. Denmark is a part of Scandinavia, like Norway and Sweden. The country experiences changeable weather, since it's located in the meeting point of diverse air masses. The coldest month of Denmark is February while July is the warmest month.

The most popular tourist attractions are Tivoli Gardens, Nyhavn, Kronborg Slot and Viking Ship Museum. Tivoli is considered as the inspiration behind the Disney theme parks, which also contains roller coasters, puppet theaters, restaurants and food pavilions. And the reason why Kronborg Slot attracts tourists is because the castle is the setting of Shakespeare's Hamlet, and also a UNESCO World Heritage Site.

With a focus on meeting the unique requirements of Denmark, Bilginç IT Academy integrates advanced training methodologies into our diverse range of Certification Exam preparation courses and accredited corporate training programs. Prepare to revolutionize your perception of IT training with us.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.