I’m looking for information around designing a data model. I’ve implemented Metabase and progressed through the typical steps of a growing business with a growing operational team. I have stake holders using ad-hoc queries that I have written to get data, some even creating their own queries. The questions have started to change from “can you make this query” to “how do I find this data”, great progress.
Now I would like to start working on a plan to create a denormalized data model. I plan to start with the same data currently accessible, data about our application. If it makes sense, and I can find the time, I will start looking into ingesting data from other services (Salesforce, Recurly, HubSpot etc.).
I was hoping that someone could point me towards info/guides/articles that will help me to start defining a flat data model for BI use. If you have any info you would like to share, I’d greatly appreciate it. Thank!