topic Re: sales dashboard in QlikView https://community.qlik.com/t5/QlikView/sales-dashboard/m-p/450844#M168268 <HTML><HEAD></HEAD><BODY><P>Dear Mona,</P><P></P><P>You have to divide tables into 2 parts&nbsp; dimensions ( Masters)&nbsp; &amp; fact (Transactions) and after identify </P><P>common fields between all fact tables and using link table concept you can link all masters with fact </P><P>tables. </P><P></P><P>First gather all requirements from sales depart ments this is necessary because after requirements </P><P>again there can be changes in data model so before design you have document all requirements </P><P>in dash board following charts you can show mainly.</P><P></P><P> 1. Sales Summary </P><P> 2&nbsp; Top 5&nbsp; division wise sales</P><P> 3&nbsp; Daily Net Sales vs Collection</P><P> 4&nbsp; Quarter wise / month /year wise sales </P><P> 5&nbsp; Targets vs Achivements</P><P> 6&nbsp; Collections vs sales </P><P>&nbsp; </P><P>This way you can create dash board&nbsp; ( Tables depend upon u r software for e.g customer master / product master/location master etc. sales fact table / sales return / collection fact etc.)</P><P></P><P>Bye</P><P>Vikas</P></BODY></HTML> Thu, 20 Dec 2012 11:54:42 GMT vikasmahajan 2012-12-20T11:54:42Z sales dashboard https://community.qlik.com/t5/QlikView/sales-dashboard/m-p/450843#M168267 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>I want to make sales dashboard by qlikview using data from oracle erp</P><P>what is the schema i will use from oracle erp or what are the tables to use to make the dashboard ?</P></BODY></HTML> Wed, 19 Dec 2012 10:20:46 GMT https://community.qlik.com/t5/QlikView/sales-dashboard/m-p/450843#M168267 2012-12-19T10:20:46Z Re: sales dashboard https://community.qlik.com/t5/QlikView/sales-dashboard/m-p/450844#M168268 <HTML><HEAD></HEAD><BODY><P>Dear Mona,</P><P></P><P>You have to divide tables into 2 parts&nbsp; dimensions ( Masters)&nbsp; &amp; fact (Transactions) and after identify </P><P>common fields between all fact tables and using link table concept you can link all masters with fact </P><P>tables. </P><P></P><P>First gather all requirements from sales depart ments this is necessary because after requirements </P><P>again there can be changes in data model so before design you have document all requirements </P><P>in dash board following charts you can show mainly.</P><P></P><P> 1. Sales Summary </P><P> 2&nbsp; Top 5&nbsp; division wise sales</P><P> 3&nbsp; Daily Net Sales vs Collection</P><P> 4&nbsp; Quarter wise / month /year wise sales </P><P> 5&nbsp; Targets vs Achivements</P><P> 6&nbsp; Collections vs sales </P><P>&nbsp; </P><P>This way you can create dash board&nbsp; ( Tables depend upon u r software for e.g customer master / product master/location master etc. sales fact table / sales return / collection fact etc.)</P><P></P><P>Bye</P><P>Vikas</P></BODY></HTML> Thu, 20 Dec 2012 11:54:42 GMT https://community.qlik.com/t5/QlikView/sales-dashboard/m-p/450844#M168268 vikasmahajan 2012-12-20T11:54:42Z