General_Hospital_Qlik_Healthcare_Solutions_Logo_1.jpgHave you ever had to continually generate fake data sets that you could use to perform training with, do workshops with, do demo applications from or use as examples when learning new features/functions/visuals?

 

Well that's pretty much the life of the Qlik Healthcare Solution Architect team. So we decided to solve that problem for me and any others that may face the same issue.

 

We utilized a combination of data generated by Mockaroo as well as other data sources to form the base files of a fictitious health system we are calling General Hospital.

 

The goal of the project is to grow this to include many other resources that surround it like additional data sets, workshops, and applications.

 

How can you play along? Glad you asked.

 

Want to see a walkthrough video of everything and how this can be used? Watch this session on the Qlik General Hospital: Qlik Technical Thursday - November.

 

If you want to practice your Data Modeling skills you will want to download the base CSV files. Click here to get the base CSV data set:

 

If you want to have some example code that pulls the base CSV files and implements various data modeling techniques to see one approach we have prepared a QlikView and a Qlik Sense solution you can download:

Click here to get the QlikView application that will load the base CSV files and create Layer 2 versions of the tables.

Click here to get the Qlik Sense application that will load the base CSV files and create Layer 2 versions of the tables.

 

If you want to skip the data modeling step and jump right into visualizing by using the layer 2 data, we have prepared both a CSV and QVD version of the data for you:

Click here to get the Layer 2 CSV files.

Click here to get the Layer 2 QVD files.

 

But wait there's more! We have already built very basic load scripts for you to load the Layer 2 QVD data files in both QlikView and Qlik Sense if you want to start there:

Click here to get the QlikView application that will load the Layer 2 QVD files.

Click here to get the Qlik Sense application that will load the Layer 2 QVD files.

 

Just because we love you ... we have also created several image files that you can download to utilize for your own resources.

Click here to get the base General Hospital image

Click here to get the General Hospital Logo image

Click here to get an image of the General Hospital data model