My Volunteer Experience - Jacinta Jiawei Qi
Welcome Jacinta!
Jacinta Jiawei Qi joined our SAcommunity Team as a volunteer, beginning with the team this year on the 23 August 2024. She attends for ~4 hours a week onsite at the Connecting Up office, Infoxchange around her university studies and other commitments.
Total Hours 40 Joined 23 August 2024 Last Check-in 15 November 2024
I. Personal Biography
Jacinta Jiawei Qi is a second year Master student of Data Science at the University of Adelaide. She has a Bachelor in Jurisprudence from Shanghai International Studies University and a Masters in Accounting from Kent State University, Ohio. Jacinta has previously worked as an accountant and tax consultant in both China and the US. Being fascinated at how AI and software can improve the efficiency and accuracy of the daily work, she chose to study Data Science to further her interests in the analytics field. She is currently interning at Brentnalls SA Chartered Accountants and Advisers focusing on optimizing and automating their workpaper processing procedures.
Jacinta is undertaking volunteering at Infoxchange to gain some practical work experience in Australia. To both further her understanding of the local work culture, and to make new networks and connections in Adelaide. She aims to utilise her existing skill-set to work on further exploring SAcommunity's open data, and to investigate other tools and automation in the Data Analytics program to improve efficiencies for the team.
Jacinta’s career goal is become a data analyst or software engineer combining her accounting and information technology knowledge. She is eager to keep exploring how software and AI can change the world, applying the knowledge into actual use and improving or creating something that could benefit the company or even the whole community.
II. Community Services in Council Project
Jacinta has selected Burnside Council for her Powe Bi council reports, utilizing a database of approximately 225 community services operating in the area for the financial year 2022-2023.
Creating community service information data presentations involves several key steps. Jacinta began by cleaning and validating raw CSV files extracted from Google Analytics 4 and SAcommunity, utilizing both Excel functions and manual cross-checking to transform the data. Once cleaned, the data was compiled into comprehensive Excel files and summarized to highlight key trends.
Burnside Council Year 2022-2023 Report
Insights from Google Analytics and SAcommunity data were further visualized in Power BI, revealing data anomalies and areas needing correction. The database was then updated, and reports were re-created to reflect the improved information accurately.
