Hi Sharath,
1)First of all any project will start from Bidding stage,means POC(Proof of concept) means how we will client show data with his template data.
2)Once project is assigned to our company then we will have a Technical documentation (In that we mentioned H/w ,s/w and all software's versions and data model Star schema or Snow flake schema..etc)
3)Coming to Dashboard as per your requirement
first you need to analyze /create one excel sheet which tables need to use in dash board and which columns will useful and take a data model from u r data base team
-->Use Inline load as per u r requirement
-->complete most of calculations in Script only (reduce calculations in Expressions)
-->Reduce Macros usage
-->Try to compare developed dashboard with other KPI's we call it as Regression testing in Qlikview
-->Date filters are more important in Dashboard,Master calendar
-->keep in mind to remove connectivity between different sheets(Means if u change one filter value in sheet 1 will not reflect change in sheet 2...)
....etc
if u need some more explanation deeply send u r mobile number i will call u and explain.
