Forum Discussion
Need help with Data Modeling
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.
1 Reply
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.