Introduction
My name is Nathalie Colgrave. I work in Finance supporting CSIRO Data61. Data School was my introduction to coding. Prior to Data School, monthly reports were compiled via manipulation in excel through cell referencing as well as usuage of functions such as vlookup.
My Project
My project, Financial Reportincg, involves saving data downloaded from the SAP system as a CSV file into RStudio. Through coding, R allows for the manipulation of a large data frame to extract financial summaries. We are also able to create lower level reports allowing the user to drill down to project level to see what makes up the summary. There are various users that reference the report at different levels. The program director refers to the highest summary level. The group and initiative leaders reference the report at initiative/group and project level.
Preliminary results
Tables| Initiative | YTDActual | AnnualPlan |
|---|---|---|
| Data Science Application | 283690 | 254917 |
| Environmental & Biological | 123799 | 287823 |
| Industrial Device Optimisation | 0 | 148983 |
| Industrial Transformation | 527627 | 799143 |
| Initiative to be advised | 434381 | 622798 |
| Machine Learning | 88515 | 0 |
| Natural Hazards and Infrastructure | 326362 | 1231666 |
| Risklab | 159080 | 323400 |
| Transport and Logistics | 162609 | 364000 |
Images from a file
Figure 1: Yet another gapminder plot
My Digital Toolbox
Digital Toolbox introduced to and applied have included:
R - dplyr, ggplot.
Introduction to Shiny has triggered some thinking about applying the interactive tool into monthly reporting via use of buttons to select various categories.
Favourite tool
The ability to summarise financial information via running script has and will continue to have a significant impact on my role.
Although I didn’t get to a stage of presenting useful graphs at this point, what I did learn in data school puts me in a position to further work on building informative visuals in the short to medium term. This includes using slack, bit bucket and git hub as tools. Not just R.
No prizes for guessing mine:
My time went …
Tidying data as well as problem solving were the two areas that took the most time. The process of problem solving introduced me to new highs and lows with the buzz of “getting in” and the frustration of finishing the session not having “worked it out”
Next steps
I look forward to further build on the monthly finance report. I would be keen to further explore “Shiny”. I have been thinking of volunteering as a helper. Although my skills are ok as opposed to very good, I would promote the attitude that success is about your ability to be brave and expose what you don’t know which is part of the process of getting help. Succeeding is heavily reliant on working with others as well as persistent and committment.
My Data School Experience
I have enjoyed: being exposed to a new challenge and meeting a bunch of really nice, dedicated group of people. I have already applied the skills I have learned in data school with allocation reports, pulling out proposals in O2D as well as the monthly financial summary.