Hello!
I have a sample raw data to perform analysis for educational and training purpose in terms of pivots, charts etc. I have attached the sample file. I need help from the Pros out here as to what kind of analysis can be done with this data.
I thought about few things like:
1. cost per salesman in this year compared to past year
2. cost per sales manager in this year compared to past year
3. departmentwise comparison along with fiscal year comparision.
4. branchwise comparision along with fiscal year comparision
5. some kind of a cost analysis considering branches and departments with a comparison of fiscal years
6. productwise analysis with a comparison of fiscal years and compared to average of all products
I am working on 1 and 2 but it is difficult for me to even think of a logic as to how to go about doing the remaining things. Also if there is anything else that can be analyzed or any consolidated pivots/charts that can be added. Would greatly appreciate if I can get some help here.
Thank you
PS: Sorry if this question does not belong to this forum. If yes, kindly advice some analytical/analysis forums.
Bookmarks