Data Warehouse Development

| April 16, 2020

Dr Barry Devlin is among the foremost authorities on business insight and one of the founders of data warehousing, having published the first architectural paper on the topic in 1988. Today he is a leading consultant and speaker on data warehouse development.

Barry has published a number of articles for WhereScape, to follow you will find a synopsis and introduction to some of these. Each has a link to the full blog so you can explore that specific subject in more detail.

Designing a Data Warehouse

Always keep in mind the basic goal of your project: to deliver a cross-functional, long-life foundation for data provision and decision support. Data warehouse development project types vary and will continue to mutate over time with requirements that you cannot predict now, and your data warehouse must continue to provide accurate data throughout this evolution.

This blog explains how to:

  • Use templates to save time and money rather than building from scratch
  • How to define and refine the logical structure of relational tables
  • Choose which approach of data modelling is best for you – 3NF, Star Schema, Data Vault etc.

Read the full blog here.

Building a Data Warehouse

This blog explains how every design is only as good as the reality of its source systems, their missing data and poorly defined data structures. The finished design is always a balance between the vision for the model and the constrains of the sources. The article covers:

  • The five steps to follow when building a data warehouse
  • How Data Warehouse Automation can help
  • How to move from design to build
  • Building a Data Vault with WhereScape Data Vault Express

Read the full blog here.

Operating a Data Warehouse

This blog explains how to deliver your data warehouse successfully to the business and run it smoothly on a daily basis. We must avoid the problems of past ad hoc data warehouse development approaches that combined manual and semi-automated methods, and adopt advanced data management and automation practices. Find out how:

  • Deployment needs to be treated as a long-term, monogamous relationship
  • To address issues such as packaging and installation of the code
  • To bundle sets of objects and transport from dev to QA and through to production
  • To handle interdependencies between the data warehouse, data marts and data lake
  • To automate the historical information that tracks performance over time

Read the full blog here.

Maintaining a Data Warehouse

In some development projects, once a piece of software is up and running it needs only minor bug-fixing, but maintaining a data warehouse needs more attention than that. The nature of creative decision-making support is that users are continuously discovering new business requirements, changing their mind about what data they need and thus demanding new data elements and structures on a weekly or monthly basis. Indeed, in some cases, the demands may arrive daily! Read this blog to find out:

  • What a data lake should and shouldn’t be used for
  • Why and how a Data Vault gives more agility in the maintenance phase
  • The role of metadata in data warehouse maintenance
  • How to predict downstream impact of changes from automated documentation

Read the full blog here.

Simplify Cloud Migrations: Webinar Highlights from Mike Ferguson

Migrating your data warehouse to the cloud might feel like navigating uncharted territory, but it doesn’t have to be. In a recent webinar that we recently hosted, Mike Ferguson, CEO of Intelligent Business Strategies, shared actionable insights drawn from his 40+...

Mastering Data Warehouse Design, Optimization, And Lifecycle

Building a data warehouse can be tough for many businesses. A data warehouse centralizes data from many sources. This article will teach you how to master data warehouse design, optimization, and lifecycle. Start improving your data strategy today. Key Takeaways Use...

Revisiting Gartner’s First Look at Data Warehouse Automation

At WhereScape, we are delighted to revisit Gartner’s influential technical paper, Assessing the Capabilities of Data Warehouse Automation (DWA), published on February 8, 2021, by analyst Ramke Ramakrishnan. This paper marked a significant milestone for the data...

Unveiling WhereScape 3D 9.0.5: Enhanced Flexibility and Compatibility

The latest release of WhereScape 3D is here, and version 9.0.5 brings a host of updates designed to make your data management work faster and smoother. Let’s dive into the new features... Online Documentation for Enhanced Accessibility With the user guide now hosted...

Common Data Quality Challenges and How to Overcome Them

The Importance of Maintaining Data Quality Improving data quality is a top priority for many forward-thinking organizations, and for good reason. Any company making decisions based on data should also invest time and resources into ensuring high data quality. Data...

Related Content

Simplify Cloud Migrations: Webinar Highlights from Mike Ferguson

Simplify Cloud Migrations: Webinar Highlights from Mike Ferguson

Migrating your data warehouse to the cloud might feel like navigating uncharted territory, but it doesn’t have to be. In a recent webinar that we recently hosted, Mike Ferguson, CEO of Intelligent Business Strategies, shared actionable insights drawn from his 40+...