For example, start by connecting up key data sources for your finance stream, so you can report on core financial KPIs. Over time, you can iterate and scale so your data warehouse includes and interlinks HR, Operations, Sales, Quality, and so on, until you’ve added all the data sources you need.
At Cohelion, we like to start by creating a data blueprint for each client we work with. What data sources do they have, what’s the granularity of the data in them, and what are their main KPIs — both now and for the future? This sets us up to construct a data warehouse that rapidly addresses each client’s core reporting needs, but that’s also designed to evolve as their business does. Next, we create a skeleton data warehouse for the client in just a few weeks. We then connect new data sources, new offices, new regions, and so on, rolling out added complexity at a pace that suits the client.
There’s another key element to bringing in business users to your data warehouse project: Cultivating true belief in the power of a data-driven company culture — and the insights that come with it. The key figures in your company need to live, breathe, and share the idea that data is what will power your organization ahead. This is instrumental in convincing the whole company to contribute however they can as you build your data warehouse, while also becoming inspired and enthusiastic about your data-driven future.