Virus data model

[markperrone]

This is from the Johns Hopkins site on github.

https://github.com/CSSEGISandData/COVID-19

This takes the raw data across the five categories for US and rest of the world.  One issue with the data is the cumulative stats which is good but having the new daily stats I found to be more useful.  I tried Pentaho and Power BI but Alteryx was the only tool that could run cleanly and very fast.  🙌

The remaining issue was to get these two workflows to run in sequence.  I could have done events but would rather setup a macro(?).  Still researching.

Anyway, flows are attached and need to be in the same folder.  The files are processed in the same folder. Two files will be output - virusdata.csv (fact) and countrys.csv (dimension).  I tried to get a country demographic file but JH data didn't use standard country names but that's a battle for another day.

[Qiu]

@markperrone 
Nice work.
if your question is about the sequencing of two workflow.

You can search the Chain App in here.
or we can use the dynamic input to supply the path rather the input tool itself.