QlikView for Data Engineers Explained with Architecture
source link: https://www.analyticsvidhya.com/blog/2022/08/qlikview-for-data-engineers-explained-with-architecture/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
This article was published as a part of the Data Science Blogathon.
Introduction
QlikView is a popular enterprise discovery platform that enables all users in an organization to perform self-service BI. With QlikView, you can analyze and visualize data and their relationships and use these analyzes to make decisions. It Supports various data sources, including the relational database. If any data source is too large for QlikView’s memory, it can connect to that data source directly. QlikView compresses data and keeps it in memory so that it can be used by multiple users immediately for analysis purposes.
- Since QlikView stores data in memory, aggregation can be done quickly because we do not need to store pre-calculated aggregate values.
- QlikView compresses the data to 10% of the original size.
- QlikView automatically finds the relationship between data as soon as it is fed into it. There is no need to configure the relationship between datasets.
- With QlikView, direct and indirect lookups will work thanks to the data association feature.
- Relationships between data items are shown as colors instead of arrows or lines.
- Dynamic graphic tables and graphs
- Create your expert systems
- Create new tables by merging data from different sources
- Statistical analysis and performance
- Get snapshots of data relationships
- Presentation based on
QlikView Architecture Overview
- QlikView server
- Publisher of QlikView
- QlikView desktop
QlikView desktop
- QlikView Desktop is a Windows-based, wizard-driven tool through which users can develop the GUI and data model of QlikView applications. It also makes it easy for users to manipulate datasets using a SQL-like scripting language. Using QlikView Desktop, data can be transformed, read, and shared between different QlikView applications.
- Users can choose their data representation modes in QlikView Desktop. User interface details files are saved with a .qvw extension. However, if the files do not contain UI details, the file extension will be changed to .qvd.
QlikView server
- So you need a server, which is QlikView Server, to host all the developed QlikView applications. Once applications are hosted, only those applications are available to end users. QlikView Server communicates between the server and the client as a desktop, web browser, or mobile. QlikView Server is responsible for serving datasets from the backend to end users.
- QlikView Server has many features such as data management, security, data distribution, scaling, etc.
Publisher of QlikView
QlikView Administration Console
QlikView user access
QlikView Directory Service Connector
How does QlikView work?
Front end:
Rear end:
QlikView’s three-tier architecture
Load layer
- This layer connects to various data sources to retrieve and save it to QlikView data files (QVD files). It can connect to a database using an ODBC, OLEDB connection, or any third-party tool like Salesforce to retrieve data.
- A QVD file contains data extracted from QlikView. It reads QVD files 10 to 100 times faster. It, therefore, increases the data loading speed and reduces the load on database servers. Incremental loading is also possible for QVD files, and you can also consolidate data from different QlikView applications into a single QVD file.
Transformation layer
Presentation layer
Conclusion
- QlikView compresses data and keeps it in memory so that it can be used by multiple users immediately for analysis purposes.
- These are the 3 levels in the QlikView architecture – Load (extract and QVD layer), Transformation (QlikMart layer), Presentation
-
QlikView is a Windows-based application. The QlikView architecture is divided between different roles. Its frontend allows us to visualize the processed data, while its backend provides the security of QlikView documents.
-
QlikView can analyze and grasp the big picture, find connections between data and provide insight into the data. QlikView works just like the human brain. Like the human brain, QlikView provides associative links between processed data.
The media shown in this article is not owned by Analytics Vidhya and is used at the Author’s discretion.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK