topic QlikView vs. Access for Linking Excel files & data model in QlikView https://community.qlik.com/t5/QlikView/QlikView-vs-Access-for-Linking-Excel-files-data-model/m-p/736986#M674805 <HTML><HEAD></HEAD><BODY><P>I've had a few people tell me they build their associations &amp; keys in&nbsp; Access database first (data model), and then only bring into QlikView once the data is just right and links &amp; associations are already made. </P><P></P><P>I don't know anything about Access, and have serveral months of experience using QlikView. In my time, I have not found any reason to move my data from Excel files into Access first. I find through scripting in QlikView I am able to aheive what I need. I trust those who told me that, they are pretty tech savy. However, I wanted to get feedback from this community and those experienced with Access.</P><P></P><P>Is there any advantage to building queries first in Access and then moving the data to QlikView, or do you prefer to do all your data modeling in the QlikView Script?</P><P></P><P>If helpful, the original source files are monthly results that are available first in Excel (CSV) files.</P></BODY></HTML> Thu, 24 Jul 2014 04:53:06 GMT 2014-07-24T04:53:06Z QlikView vs. Access for Linking Excel files & data model https://community.qlik.com/t5/QlikView/QlikView-vs-Access-for-Linking-Excel-files-data-model/m-p/736986#M674805 <HTML><HEAD></HEAD><BODY><P>I've had a few people tell me they build their associations &amp; keys in&nbsp; Access database first (data model), and then only bring into QlikView once the data is just right and links &amp; associations are already made. </P><P></P><P>I don't know anything about Access, and have serveral months of experience using QlikView. In my time, I have not found any reason to move my data from Excel files into Access first. I find through scripting in QlikView I am able to aheive what I need. I trust those who told me that, they are pretty tech savy. However, I wanted to get feedback from this community and those experienced with Access.</P><P></P><P>Is there any advantage to building queries first in Access and then moving the data to QlikView, or do you prefer to do all your data modeling in the QlikView Script?</P><P></P><P>If helpful, the original source files are monthly results that are available first in Excel (CSV) files.</P></BODY></HTML> Thu, 24 Jul 2014 04:53:06 GMT https://community.qlik.com/t5/QlikView/QlikView-vs-Access-for-Linking-Excel-files-data-model/m-p/736986#M674805 2014-07-24T04:53:06Z