Data warehouse modelling advice

[Gary How]

dear all, looking for advice.

This was the only data warehouse use case i saw: https://www.mongodb.com/mongodb-data-warehouse-time-series-and-device-history-data-medtronic-transcript 

but it haven't explain deep enough. i scorn through Google Scholar to find a few more, but still not quite useful.

In the RDMS world, we have kimball vs inmon/ star and snowflake and data vault. But are there any similar methodology that we can follow for NoSQL esp for MongdoDB?

my use case: 

1. Using BI tools like Qlik/ Tableau for reporting

2. For analytics - e.g. create time series datasets for machine learning models

3. Domain driven data model for apps to consume

any thoughts? 

[Wan Bachtiar]

any thoughts?

Hi Gary,

MongoDB has a flexible data model, should work for either top-down or bottom-up approach depending on your requirements. You can always alter the data model to suit the application requirements. See also Data Modeling and Data Model Design.

Worth mentioning that you can utilise MongoDB Aggregation Pipeline to transforms documents.

You may also find MongoDB Connector for BI a useful reference for your BI use cases.

Regards,
Wan.

​