Need help with Data Modeling

[Anonymous]

I'm looking to combine the attached data in such a way that I can analyze sales representatives by their sales vs target by their branch and class. And also create measures to consider their total sales and target.

https://docs.google.com/spreadsheets/d/1SEo9T49z_bGeOuvzqL6gcFrScG9yVEGy/edit?usp=sharing&ouid=10407... 

[Anonymous]

Hi @Anonymous ,

You need to create a star schema with your sales data at the center and dimension tables for sales representatives, branches, and classes.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.