topic Re: after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls? in QlikView https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726267#M1082411 <HTML><HEAD></HEAD><BODY><P>based on metrics we need to validate in db using queries</P></BODY></HTML> Mon, 07 Jul 2014 15:57:18 GMT vardhancse 2014-07-07T15:57:18Z after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls? https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726261#M1082405 <HTML><HEAD></HEAD><BODY><P>after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls?</P></BODY></HTML> Mon, 07 Jul 2014 13:31:12 GMT https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726261#M1082405 2014-07-07T13:31:12Z Re: after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls? https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726262#M1082406 <HTML><HEAD></HEAD><BODY><P>HI</P><P>Read the Follwing post,How to test your Data Model,</P><P><A href="https://community.qlik.com/docs/DOC-5901">6 ways to Test your QlikView application</A></P><P></P><P>One basing thinhg is cross checking with the data base, By firing Queries at database side...</P></BODY></HTML> Mon, 07 Jul 2014 13:58:06 GMT https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726262#M1082406 sasikanth 2014-07-07T13:58:06Z Re: after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls? https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726263#M1082407 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The two ways I find the most helpful are:</P><P></P><UL><LI>Pick out random examples to check within your application</LI><LI>Look for and interrogate any duplication in the data</LI></UL></BODY></HTML> Mon, 07 Jul 2014 15:03:56 GMT https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726263#M1082407 matthewjbryant 2014-07-07T15:03:56Z Re: after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls? https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726264#M1082408 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I tend to go the pragmatic way about those things:</P><P>=&gt; Your datamodel is "perfect" - good, that is - when it works and the results you get are correct. The "best practices" are all interesting and helpful and can help you make your datamodel slimmer and more efficient in terms of resource_usage - but generally, when it works, you're ok. You can go from there.</P><P>One thing to look at closely is your keyfields - a key in a masterdata_table should always be unique, not so in a transaction_table.</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Mon, 07 Jul 2014 15:09:37 GMT https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726264#M1082408 datanibbler 2014-07-07T15:09:37Z Re: after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls? https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726265#M1082409 <HTML><HEAD></HEAD><BODY><P>once the data model was done, </P><P></P><P>we need to validate the data from the data source</P><P>based on the metrics we can use queries and can can validate the data</P><P>we need to identify the data flow, so that accordingly we can load the data.</P><P>we can use left keep/join so that only relevant data can be loaded.</P><P></P><P>shortly if data was validated from the data source, our data model was good</P></BODY></HTML> Mon, 07 Jul 2014 15:17:44 GMT https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726265#M1082409 vardhancse 2014-07-07T15:17:44Z Re: after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls? https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726266#M1082410 <HTML><HEAD></HEAD><BODY><P>how to validate the data</P></BODY></HTML> Mon, 07 Jul 2014 15:54:57 GMT https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726266#M1082410 2014-07-07T15:54:57Z Re: after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls? https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726267#M1082411 <HTML><HEAD></HEAD><BODY><P>based on metrics we need to validate in db using queries</P></BODY></HTML> Mon, 07 Jul 2014 15:57:18 GMT https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726267#M1082411 vardhancse 2014-07-07T15:57:18Z Re: after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls? https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726268#M1082412 <HTML><HEAD></HEAD><BODY><P>what is meant by metrics u are frequently using that word?</P></BODY></HTML> Tue, 08 Jul 2014 06:08:07 GMT https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726268#M1082412 2014-07-08T06:08:07Z Re: after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls? https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726269#M1082413 <HTML><HEAD></HEAD><BODY><P>metrics are nothing but.</P><P></P><P>These are used expression we will use in the charts for calculations.</P><P></P><P>Agent_No&nbsp;&nbsp;&nbsp;&nbsp; Agent_Name</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ABC</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BCD</P><P></P><P># of agents(Metric)</P></BODY></HTML> Tue, 08 Jul 2014 06:14:44 GMT https://community.qlik.com/t5/QlikView/after-developing-datamodel-how-do-i-came-to-know-that-my-data/m-p/726269#M1082413 vardhancse 2014-07-08T06:14:44Z