Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

As the above screen capture indicates, Open Georgia provides public records regarding how/where money is spent in the State.  While there are many avenues to explore on the site, this analysis effort hones in on the salaries/expenses data presented; especially on the local boards of education.  Preparing Open Georgia Test Data walks you through the download/preparation process that can be visualized in the Format & Sample Data for Open Georgia.

 

Want a more complete ELT (not ETL) process, but for now can just hand-swizzle the data to generate a test file by doing X, Y, and Z.  We For this analysis effort, the Hortonworks Sandbox was utilized.  Specifically, version 2.0 was utilized, but every effort, but testing was not done, to ensure the code will run on the 1.3 and 2.1 versions as well.

 We can then just upload the file via Hue to /user/hue/something which has the following format.

...