Shopify Data Modelling

[Jameswh91]

Hi, 

Has anyone built a data model using to shopify tables. Should i merge the tables or use relationships for them. I've not used a data model like this prior so any help would be much appreciated. 

[faronim]

It's great to see discussions on utilizing Power BI for analyzing and visualizing Shopify data. If you're interested in diving deeper into the pros and cons of using Shopify as an e-commerce platform, I recommend checking out the article https://claspo.io/blog/16-shopify-pros-and-cons-reviewed/. Exploring the pros and cons will give you a comprehensive understanding of the platform's capabilities and potential limitations. In past its really help me in my business

[josbrodin]

I found this post on Shopify data modeling in Power BI quite informative. As a Power BI user, it's crucial to effectively model and transform your data to extract meaningful insights. Understanding the underlying structure and relationships of your Shopify data is essential for creating accurate and insightful visualizations. I appreciate the tips and discussions shared in this post, particularly the focus on defining relationships, managing data granularity, and optimizing performance

[bandini]

Thank you for sharing your experience and insights on Shopify data modeling in Power BI. Data modeling is a crucial step in creating meaningful visualizations and gaining valuable insights from your Shopify data. It's great to see the community discussing various approaches and best practices for data modeling in Power BI with Shopify

[ltopchyi]

Hi @Jameswh91 

You can use Power BI Connector with a data model where the relations are built automatically. 

Liubov

[Adel]

i'm not sure why you would need a data model for this, or merging table, if there is free shopify to Power bi connector.
try this app https://apps.shopify.com/windsor-connector
this is the how to https://windsor.ai/connect-shopify-to-power-bi/
and a free template to get you started https://appsource.microsoft.com/en-us/product/power-bi/windsorgroupgmbh1585043281642.shopify-store-o...

[v-luwang-msft]

Hi @Jameswh91 ，

Pls refer the below and check if it is helpful:

https://panoply.io/shopify-analytics-guide/understanding-the-shopify-data-model/ 

https://community.powerbi.com/t5/Desktop/Unable-connect-Shopify-to-Power-BI/td-p/2232960 

Best Regards

Lucien