The QlikView Governance Dashboard
The QlikView Governance Dashboard is a QlikView Application that delivers a comprehensive view of any QlikView deployment by visualising efficiency and effectiveness. It allows QlikView and IT professionals to discover how your QlikView deployment is being use by focusing on managing and understanding the QV environment. The information learned can help you introduce a more manageable and repeatable process when developing QV apps as well as address data lineage and answer impact analysis type questions. All of this allows you to maximize data governance and optimize your QlikView investment.
The QlikView Governance Dashboard is comprised of 2 components; Firstly a QlikView Expressor run-time processing application which is used to scan and extract valuable meta-data from your QlikView deployment. The second part is a QlikView dashboard application that presents the collected meta-data in a easy to use and beautifully visualised view.
Here is overview of some of the information that can be found within the application.
- A Summary showing key findings such as counts and info on QlikView files, recurring labels and expressions, sizes, number of tables, row counts, number of fields and sheet objects.
- File Details documenting information on the QlikView files, including details such as the document name, extension, file path, size, last load date and author.
- A QVW Overview detailing the QlikView applications housed within the QV deployment, including various counts relating to usage, data sources, objects, tables and fields.
- QVD details providing change analysis, the time and dates that the QVDs are refreshed, QVDs size change and information on the number of rows.
- Details on Sheet Objects, object types, object names and definitions in each QV application.
- Data Lineage showing visibility of the data sources and the data flow between the data sources, the QVD files and the QV applications.
And the best thing about the QlikView Governance Dashboard is that it’s completely free!! Contact your Qlik Partner or contact me directly for more information.
That’s it for this post, there are plenty more useful QlikView resources out there so please feel free to post them in a comment below.