If you sit in on Senturus team meetings, you’ll hear impassioned discussions about how folks need to properly stage their data. And we’re not talking about merely replicating tables in a separate database offline and calling that a data warehouse. We mean a high performance, business-centric, subject-area-organized system, aligned with the company’s strategic goals. One with validated and secure metrics that is easy to pull data from and as a result enjoys high adoption rates across the organization.
As technologies advance and data types grow, the more we see the need for solidly architected data warehouses. Our CEO and co-founder John Peterson can wax poetic on the subject. He recently pulled together this quick list of real-life, practical reasons why a data warehouse plays such an important role in any data driven organization. (We’d bet John’s got another good 30 reasons in his back pocket!)
To make data truly usable and valuable, it needs to be transformed into business centric terms and metrics that support organizational decision-making and enriched to provide roll up and drill down access into information. This transformation needs to take place somewhere between the raw source and the final report/analysis. It becomes a question of where and how you handle that transformation, upstream or downstream.
Addressing the transformation downstream simply forces business end-users to tackle it themselves, which leads to the horribly time consuming process of what we call “Excel hell.” It also results in complex, slow and inaccurate self-service dashboards and reports and data “acquisition aggravation.”
Senturus recommends you do the work upstream by properly staging your data to avoid “Excel hell”… and for at least 30 other good reasons.
30 reasons you still need to stage data
- Consolidates multiple sources of data
- Retains history when changing/upgrading systems
- Captures snapshots and realigns data
- Consolidates data from cloud and on-premise
- Provides persistent storage of critical data
- Increases efficiency by storing data only once
- Cleanses data
- Handles and fixes NULL values
- Applies universal, one-time filters
- Improves performance (end-user reports, etc.)
- Eliminates expensive and incorrect joins
- Transforms complex source data into usable facts
- Captures strategic business-centric metrics
- Consolidates and simplifies disparate attribute data
- Adds mandatory business “dimensional richness”
- Simplifies complex data relationships
- Applies logic to complete and align data
- Facilitates allocation and attribution
- Provides an insulating layer from source systems
- Eliminates complex logic needed in BA layer(s)
- Allows for slow-changing dimensions
- Captures slow-changing facts
- Eliminates live connections to source data
- Eliminates spreadmarts and local databases
- Reduces challenges associated when people leave the organization
- Eliminates incorrect calculations by end users
- Provides security and controlled access
- Helps reduce software license fees
- Enables consolidated dashboards and aligned metrics
- Enables better dashboards thru context
Benefits of properly staged data
Properly staged data offer numerous strategic advantages to an organization. Benefits include:
- Better decisions
- Faster actions
- Unified strategic direction: what gets measured, gets managed
- Greater efficiency: less time in Excel hell
- Less redundancy and waste
- Fewer errors: some can cost $millions
- Happier business users
- Greater user adoption
For more on this topic, you can hear direct from John in his on-demand webinar Death of the Data Warehouse?