Thanks for reaching out!
I am a Pro Datawarehouse(DW) and BI Developer. There are a couple of ways to deliver a DW solution (1) A Relational DW (2) An Analytical Solution , such as a cube. Once the DW solution is available the presentation layer can be developed.
I think it is important is to deliver a centralized DW model for resusability, governance, metadata management and the like :) . My approach is start small deliver something tangible so that the business can realize the benefits sooner and then gradually build and scale-up.
It would be great if you can share your high level requirements. Please feel free to contact at VisualInsights@protonmail.com to move ahead. We can schedule a call to discuss your requirements.
We at Lyftron have built out of the box Shopify data warehouse & analytics solution to save cost and time for customers like you, where you do not required to code anything manually from scratch. Simply connect your Shopify store, and use our prebuilt pipelines and analytics and get your solution faster at 1/10th of the cost. We have helped Shopify stores like Orange Panda, OfficeGenie, FortuneTimepieces, RefurbGenie, QueenV, Brandabe and many more for analytics solution. More information of our solution can be found at https://lyftron.com/lyftron-integrates-shopify-for-modern-analytics-and-accelerated-growth/ and you also check the data sheet at https://rb.gy/vov8wg
Feel free to setup live demo at https://lyftron.com/request-demo/