A step-by-step guide about Vivien her assignment
Each new development started with finding and extracting the right data via Python scripts. All existing reports were also updated through scheduled script runs. Therefore, it was important for Vivien to check the runs daily and perform potential bug fixes.
Raw data tables
Once the data was correctly loaded into the SQL database, Vivien wrote reusable queries to clean, combine and transform the raw data tables. This process took place in a separate environment to not affect reports that were already live.
Using Spotfire, Vivien displayed the integrated data sources in clean and accessible reports. Especially important: filters! This allowed the reports to cater to many stakeholders by being able to customise the output.
At the end of every sprint, Vivien and the other developers demonstrated their work to key stakeholders to get their input. Once the stakeholder accepted the increment, it was time to move the new developments to the production environment.
With the release of new developments, many ideas were sparked for more
features. Back to the start! It is important to communicate what is realistic with the available data and tooling and to keep the added business value in mind.