Does qlickview expects source data to be dimensionally modelled? No. QlikView works best with raw data and loads individual tables (from different data sources if required) that are then associated within QlikView. There is normally no need to pre-process or pre-aggregate the data. QlikView can connect directly to databases and files, or a data warehouse if you have one. QlikView has its own ETL capabilities if a data warehouse is not in place.
how it identidies facts and dimensions? These do not have to be defined explicitly.
Is app/document satisfies business questions perticular to one subject area e.g. sales or call details ? It can address multiple business areas in a single QVW document as long as there is a single associated data model. Or you can develop specific apps for each subject area. The choice is yours.
Does every document or app will have its own data model? Yes. A data model can contain multiple tables and from multiple data sources, but the tables need to be associated (joined).
or you will have a large data model in qlickview and you can create multiple apps/document based on user analysis? It is possible to create a single large app as long as it has a single data model. If required you can then use the QlikView Publisher to automatically split the app into multiple smaller apps with different user permissions, e.g. one for each sales rep, one for each country etc. QlikView calls this "loop and reduce"
if i have dimensionally modelled bus architecture in place , do i need to create a multiple documents that caters to diff business functions? Not necessarily. QlikView is very flexible in that respect.
can qlickview create a dashboard ( again a super document) that spans across the subject areas to create enterprise view of business? Yes
How business discovery helps CRM and how CRM app can talk to qlickview to get insights for day to day operation?
Most CRM systems, such as SalesForce, have built-in reporting, but it is often not sufficient if a deep insight into the business is required. Business Discovery allows users to ask their own ad hoc questions and easily get the answers they need. QlikView in turn can be integrated into the CRM system. Note that QlikView is a read-only business discovery tool, i.e. out of the box it cannot write back to other systems.
