1) Data Access Layer:
QlikView Adopts Multiple Data Sources.
The QlikView Data Access layer supports heterogeneous data sources to load the data. Unlike all other reporting tools QlikView Data can be sourced from different databases using standard ODBC, OLEDB and JDBC drivers such as Oracle, spreadsheets and web pages (HTML, XML, etc.).
For most data sources, a connection is made using a wizard that simplifies the connection process and allows the application designer control over how data is read. The different formats of files can be supported are xlsx, csv, xml, qvd, qvx, qvw etc. QlikView provides a platform to query the data from data sources in such a way that QlikView user can retrieve only the required data attributes.
2) Data Extract Layer:
Extraction leads to less burden on Data Sources.
Connecting the QlikView to heterogenous data sources seamlessly results in network traffic and performance issues. As we know, QlikView is developed with the ideology of In-memory. It is ideal to connect to the data sources and fetch the relevant tables, and store it as a single repository. Accessing the same repository results high speed of performance in terms of accessing the data and exploring the analysis.
We can extract the same repository and store it in a separate QlikView accessible file. i.e. QVD file, which is the most optimized file format. QlikView can also extract the same data in different formats viz., csv, xlsx, etc. using the store command.
We can do incremental extract to store the live data from Database to QlikView accessible files, using the Incremental load functionality. Instead of loading millions of historical records from a transactional Database every time, the incremental load improves the performance of QlikView application by pulling out only newly added, updated records and appending it to the existing repository.
3) Business Model/ Business Logic Layer:
A Model is an Engine for BI Application.
The extracted data from Data Extract layer is a live and raw data. It needs to undergo different transformations and aggregation process to be analyzed by an end user. We build different logical relationships between different data sets to explore the data further.
The aggregation of the data sets by different KPI metrics and associating the different tables to have a meaningful model resides in this layer. All business requirements will be modeled with different transformations, and association functionalities.
Building Fact tables, Link tables and Dimension tables brings forward the most optimal business model. In most developments, 60% of the time needs to be spent on perfecting the data model. If you ensure that you invest that time, then you have a far greater chance of success in your QlikView projects.
4) Graphical Presentation Layer:
Interactive Visualization brings Rich Analysis.
Ever used QlikView? QlikView makes it very quick to pull in data and present it in an interactive way with rich visualization objects. Once the data is modeled, the QlikView user can explore the data with more sophisticated and real time analysis. QlikView is a good visualization tool with many graphical objects that explores, manipulates, aggregates the data with a wide variety of analytical functionalities.
As QlikView has a great feature of association, it drills downs, and slices the data based on the user selections. The graphical presentation would be quite user friendly with different attributes. The user can view a major analysis based on the different field selections; it slices the data and explores the analysis based on the user customizations.
The other interesting functionalities in QlikView has are Ad-hoc reporting, comparative analysis, Forecasting analysis, Time-trend analysis (Year on Year, Month on Month, and Quarter on Quarter).
5) User Access Layer:
Secured Access over multiple devices.
The QVS is a server-side product, which handles all the client/server communication between a QlikView client (i.e. Desktop, IE plugin, AJAX or Mobile) and the server. It includes a Management Console for providing Administrator access to control all aspects of the server deployments including security, clustering, distribution etc. The web server’s user portal is known as “Access Point”. The QVS handles client authorization against existing directory providers (e.g. AD, eDirectory) and also performs read and write access to ACLs for QVW documents.
The QlikView Publisher is a server-side product that performs the tasks like scheduling reloads and publishing the QlikView documents on the Access point. There are several methods supported by QlikView to distribute the application. The application can be distributed over different platforms like, over the internet, Intranet, and cloud platforms.
QlikView Management Console (QMC) provides building of distribution and security access layers. It provides a platform to set security authentication permissions for Admin and User levels. Also gives a security access on data based on the user accessibility. All these kind of security layers can be defined in QMC. Based on the defined credentials, a User will be able to access the reports, and dashboards pertaining to his accessibility of the data. The data level security access can be achieved by Section Access functionality. ‘Access Point’ is a web URL from where the User enters in to the QlikView application by giving authentication credentials.
Developer Qlik View, Qlik Sense and Tableau
Suman is working as a Developer (QlikView, QlikSense and Tableau) for the past two years, involved in development of Business Intelligence (BI) solutions. Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses and Performance optimization of the BI applications. He has expertise in complex data modelling, designing the scorecard dashboards, Ad-hoc reporting and building KPI’s. In the past two years, he has worked in several domains viz., Financial, Sales, Transportation, Insurance, Media, Healthcare, Telecom, Hospitality, Retail and Crime Analytics.
Developer Qlik View - Qlik Sense
Mahender is working as a Developer (QlikView and QlikSense) for the past two years, involved in end-to-end implementation of Business Intelligence (BI) projects, especially in modeling, designing scorecards, KPIs, reports, and dashboards. He was also involved in QlikView Server Architecture, Testing and Deployment of QlikView / Qlik Sense applications. In the past two years, he has worked in several domains viz., Financial, Sales, Transportation, Healthcare, Telecom, Retail, Insurance and Media.