Why Reinvent the Wheel

Through our careers, we saw mistakes that many organizations were making when building data warehouses and we are truly sick of seeing how the same mistakes are repeated again and again. The goal of this project is to share our proven patterns and good practices we developed over the last 15 years.

There are DWH patterns which already work

Busines Orientation

Real success of a data warehouse is defined by number of users who use it on a daily basis, so do not forget to always put their needs in the first place.

Agile

It is easier to build successful data warehouse in Agile with cross-functional team players. Make sure each of your team members can play someone's else role

Proven Design

Straightforward Stage layer, normalized Integrated layer, and business oriented, dimensional Access layer - these are 3 gold pillars of successful data warehouse.

We are the alliance of DWH veterans, professionals who have owned their own businesses. We have learned already from our own successes and mistakes, which allows us to share our proven patterns to help you successfully build and maintain DWH in your organization.

Lubomir Kamensky

DWH Consultant

15 years of experience in building enterprise data warehouses in Logistics, Telco, Banking, and Pharma. Lubo has a strong passion to observe, connect and make things work. Using the power of abstraction to utilize unexpected patterns.

Grzegorz Swierniak

DWH Consultant

8 years of experience in Business Intelligence. His pragmatic approach leads to functional and robust solutions that work. He played multiple roles in DWH projects, so he gets different perspectives and angles in order to clearly define problems and solve them.

Core principles

“Using reason without applying it to experience only leads to theoretical illusions. Ideas derived from real world experiences lead to acquisition of knowledge, and the accumulation of time-tested principles leads to wisdom.” ― Kilroy J. Oldster

Code Under Control

Version control system is an essential tool for DWH projects, tracking changes in the code during development. GIT is a great choice due to the best fit into agile integration.

Separation of Concerns

This principle is applicable recursively starting with DWH layers, going down to data models, entities, attributes. Experiences show that Separation of concerns makes DWH solution maintainable in the long term.

End-to-end Transaparency

Clear and well-commented code and configuration files, descriptive documentation of the whole data flow. No black boxes and magician features. The best code is not the shortest but the most self-descriptive one.

Automation

Anything what can be automated, has to be automated. Start with packaging, deployment and testing. Analyse all repeating activities and assess which really need to be manual.

Symplicity

There are several traditional approaches helping to keep things simple like Refactoring, YAGNI, Single responsibility, DRY. Perfection is achieved not when there is nothing more to add, but when there is nothing left to take away (Antoine de Saint-Exupery).

Blog

We love sharing our ideas about datawarehousing, below you can find some of the articles that we posted on our Blog.

Entropy of the DWH systems

“When DWH accumulates unorganized data it tends to experience some kind of Turbo Effect in the entropy increase. The main motivation to start the project DWH Academy was to share the patterns and tools which work to build a successful Data warehouse (…) ”

Lubomir Kamensky Read more DWH Consultant

Proven DWH Design

“There is an unlimited number of ways how to build a data warehouse. Few of them work and some of the few can even survive in the long term. In this post, we are going to describe the high-level design of the typical successful DWH in the long term (…) ”

Lubomir Kamensky Read more DWH Consultant

Agile in Data warehousing

“Working in Agile became a hot topic. Big consulting companies (including big 4) realized that implementing agile methodology is a very lucrative business. But have you ever seen a good implementation of Agile methodology in Data Warehousing? Probably not (…) ”

Grzegorz Swierniak Read more DWH Consultant

Why Reinvent the Wheel

Through our careers, we saw mistakes that many organizations were making when building data warehouses and we are truly sick of seeing how the same mistakes are repeated again and again. The goal of this project is to share our proven patterns and good practices we developed over the last 15 years.

There are DWH patterns which already work

Busines Orientation

Agile

Proven Design

About us

We are the alliance of DWH veterans, professionals who have owned their own businesses. We have learned already from our own successes and mistakes, which allows us to share our proven patterns to help you successfully build and maintain DWH in your organization.

Lubomir Kamensky

Grzegorz Swierniak

Core principles

“Using reason without applying it to experience only leads to theoretical illusions. Ideas derived from real world experiences lead to acquisition of knowledge, and the accumulation of time-tested principles leads to wisdom.” ― Kilroy J. Oldster

Code Under Control

Separation of Concerns

End-to-end Transaparency

Automation

Symplicity

Blog

We love sharing our ideas about datawarehousing, below you can find some of the articles that we posted on our Blog.

Projects

“Education without application is just entertainment.” – Tim Sanders. Here are the white papers that we wrote based on our real projects

Get in touch

Feel free to contact us if you want to share your thoughts about our project - DWH Academy.

Stats

Why Reinvent the Wheel

Through our careers, we saw mistakes that many organizations were making when building data warehouses and we are truly sick of seeing how the same mistakes are repeated again and again. The goal of this project is to share our proven patterns and good practices we developed over the last 15 years.

There are DWH patterns which already work

Busines Orientation

Agile

Proven Design

About us

We are the alliance of DWH veterans, professionals who have owned their own businesses. We have learned already from our own successes and mistakes, which allows us to share our proven patterns to help you successfully build and maintain DWH in your organization.

Lubomir Kamensky

Grzegorz Swierniak

Core principles

“Using reason without applying it to experience only leads to theoretical illusions. Ideas derived from real world experiences lead to acquisition of knowledge, and the accumulation of time-tested principles leads to wisdom.” ― Kilroy J. Oldster

Code Under Control

Separation of Concerns

End-to-end Transaparency

Automation

Symplicity

Blog

We love sharing our ideas about datawarehousing, below you can find some of the articles that we posted on our Blog.

Projects

“Education without application is just entertainment.” – Tim Sanders. Here are the white papers that we wrote based on our real projects

Merck Sharpe and Dhome

DHL

Kyivstar GSM

Franklin Templeton Investment

Telefonica

Nordea

Get in touch

Feel free to contact us if you want to share your thoughts about our project - DWH Academy.

Stats