You have to divide tables into 2 parts dimensions ( Masters) & fact (Transactions) and after identify
common fields between all fact tables and using link table concept you can link all masters with fact
tables.
First gather all requirements from sales depart ments this is necessary because after requirements
again there can be changes in data model so before design you have document all requirements
in dash board following charts you can show mainly.
1. Sales Summary
2 Top 5 division wise sales
3 Daily Net Sales vs Collection
4 Quarter wise / month /year wise sales
5 Targets vs Achivements
6 Collections vs sales
This way you can create dash board ( Tables depend upon u r software for e.g customer master / product master/location master etc. sales fact table / sales return / collection fact etc.)
Bye
Vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
