Generalized Data models for sales data

Question

We need to consolidate sales data and build a common set of reports for a group of companies. They all use different ERPs, so while the data looks similar, there are not quite the same.

Are there any standardized data models for sales that we can utilize? It would be higly appreciated if experienced folks can share what they did for this type of use cases.

anonymous · Answer

sanimesa,You can create Power BI template file(.PBIT) as below for your users. The users can instantiate&nbsp;the PBIT file with their own data.&nbsp;https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/Regards,Lydia

Forum Discussion

Generalized Data models for sales data

1 Reply

Related content

Edm Model Generation Fails

Unable to Generate Ontology from Semantic Model in Microsoft Fabric

Help With Semantic Model - Different Sums & Counts for Sales in Specific Counties From Total Sales

Generating Missing Data

Unable to delete auto-generated Semantic Model (empty, no lineage)