Qlik

Qlik (pronounced "click") Sense is a data analytics platform, hosted by the UW School of Medicine and Public Health. It allows users to interact with data through visualizations, filterable reports, and other formats. 

Institutional data will be made available through the SMPH Qlik platform, including data from campus, UWHealth, and additional SMPH-specific data sources. This will include HR, financial, facilities, and educational data. Research data will, at this time, be limited to research administration. 

Dashboards and reports will be created in Qlik Sense by SMPH IT, as well as by developers from other units within SMPH, giving groups the freedom to build to their own needs and specifications.


Qlik

Release Timeline

DateMilestones
Feb-May 2019

First developers added to Qlik Dev Environment

Building of baseline security groups

Building of baseline Qlik data sets (QVDs)

May 2019

Innaugural developer-to-developer demo

Testing of security roles in Qlik Test Environment

First Qlik apps moved into Qlik Test Environment

June 2019

Launch of twice-monthly Qlik Developer Open Labs

Testing of security roles in Qlik Production Environment

Summer 2019First Qlik apps promoted to Qlik Production Environment


FAQ

Direct Qlik access is limited to known users at this time. As we move toward release of the Test and Production environments we will update this with additional information.


SMPH is providing 3 Qlik environments:

  1. Production: This is where applications that are tested and ready to use will live. Most end users will only see the Production environment.
  2. Test: This is where power users help test Qlik applications that are being prepared for moving to Production. 
  3. Development: This is where development of new Qlik Sense apps and work to update existing apps will take place. Only Qlik developers will have access to the development environment. 

Learn more about roles in each environment in SMPH Qlik Sense.


To get started as a developer:

  • You must have completed your HIPAA security training (usually handled within your first days of employment and updated annually). 
  • Send an email to support@med.wisc.edu 
    • This will be a relatively simple process if you are working with a unit that already has at least one developer established.
    • If you are the first developer for a new unit that would like to would like to start development, we will discuss the right person to fill the role of Stream Admin for your unit. Learn more about roles in SMPH Qlik Sense.
  • We will take you through steps to review a data agreement, and provide materials to start getting up to speed in Qlik Sense.


We are preparing a fillable form to initiate a conversation for something you'd like to see in Qlik. In the meantime, please send an email to support@med.wisc.edu to get started. If your idea has SMPH-wide appeal, we will discuss collaborative development options.

Learn more about what it takes to get an idea to production.


SMPH IT will be creating a default UW Qlik Theme. In the meantime, review the recommendations provided by Qlik on how to create apps that meet accessibility standards.




The core data to be used in Qlik enterprise reporting will be stored in files called QVDs. A QVD (QlikView Data) file is a file containing a table of data exported from Qlik Sense. QVD is a native Qlik format and can only be written to and read by Qlik Sense. See Qlik Data Overview.docx for more information on just how this works.



RESOURCES

Qlik Sense App Development Community

New to Qlik Sense

Qlik Sense App Development

Qlik Sense Enterprise Documents

Top 10 Qlik Sense Enterprise Visualization Best Practices

Mike Tarallo's User Page

Tutorials / videos available on Box

  • For everyone starting with Qlik - 
    • Qlik Basics Tutorial  (This sample app is available in the "Everyone" stream in the enterprise Development environment. Please make your own copy to work with by right-clicking on the App, and choosing "Duplicate". A copy should appear in your Work area. Alternatively, if you have Qlik Desktop installed you can download the Beginner's tutorial.qvf file in Box.) 

Qlik Help Tips YouTube Playlist

https://www.youtube.com/playlist?list=PLkRFvjyuHFvJzisE2CizLezYenmn6DpBz