If you’ve been following these blogs in order (and if not, why not??), you will have read all about:
The time has come to discuss the structure of your data warehouse. What is the best way to build it? Kimball? Immon? Facts? Dimensions? What’s it all about? Grab a coffee and let’s dive in.
As we discussed in the ELT versus ETL blog, the near removal of storage and compute barriers has changed the game for data modelling and design. No longer do we need to worry about minimising data redundancy and repetition. No more careful Kimball modelling of fact and dimension tables with spidered joins between them.
Instead we can flatten, denormalise and disaggregate.
With any of the column store cloud data warehouse technology out there, the thing to focus on is minimising the complexity of the data at rest.
In nearly all cases, the greatest cost to a business in delivering business intelligence, insight and analysis is in the human resource required to actually perform the analysis. The cost of having to wait a week for an answer to a question almost certainly outweighs any infrastructure cost in your data pipeline (see our data driven company blog here).
By denormalising the data into the minimum number of large, flat, disaggregated tables (think: a customer table – single row per customer, an orders table – single row per order; each with potentially hundreds of columns with all of the relevant attributes), you minimise the cognitive load on the analysts.
Analysis is predominantly conducted intra-table rather than using joins to create inter-table queries.
If constructed carefully and designed well, you may even achieve the nirvana of Insight at the Speed of Thought.
Imagine the dream scenario:
You can sit down in a meeting room with your senior stakeholders, a decent BI tool connected to your curated, structured data warehouse, and you can confidently say to them: “ask me the burning questions – what do you want to know?”
Go as deep as you like – with the data structured properly, available at the fingertips of your analysts, you can become the data heroes your business needs.
Use the transform layer and the power of a cloud data warehouse to create the data structures. Disaggregate the data completely (remember – to aggregate data is to destroy data – don’t do it where you can’t undo it). Use a BI tool (Tableau, Looker, PowerBI – they’re all good) to aggregate, compare, slice and dice for analysis.
Want to know more? We’d love to chat. Please get in touch.
We’d love to show off a bit, so get in touch below.
Business strategy relies on clear thinking – and metrics. We can help you build a robust KPI framework to...
Trying to weigh up data warehouse vs BI tools? We think you need both. Find out how to unlock...
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.