Adelaide University Internship Experience - Ivy Ling Luo
Welcome Ivy!
Ivy Ling Luo joined our SAcommunity Data Analytics Team for her University of Adelaide SET (Sciences, Engineering and Technology) Internship for her Masters of Computing and Innovation Semester 2, 2024: 22 July 2024 - 18 November 2024.
She is completing a 140 hour internship onsite with SAcommunity at the Connecting Up Office, Infoxchange for 2 days (15 hours) a week for ~10 weeks around her classes finishing her internship on the 15 October 2024.
Ivy returned to Connecting Up as a volunteer on the 16 October 2024 to continue her exploration of Data Analytics in the Team. Thanks Ivy!
Total Hours 171 Joined 13 August 2024 Last Check-in 5 November 2024
Personal Biography
Ivy is in her final semester of Master of Computing and Innovation at the University of Adelaide. She came to Australia on a working holiday visa and has spent her early years in Alice Springs, Northern Territory before moving to Adelaide in February 2023 to pursue her studies.
A passionate coffee enthusiast with a background as a barista, Ivy currently works as a casual retail consultant at Telstra. Her graduate project involves developing a no-code solution designed to assist non-technical users in accessing time series data from a database and visualizing it effectively.
At Connecting Up, Ivy is eager to deepen her understanding of data analytics, enhance her hands-on experience, and expand her professional network. She is particularly interested in mastering tools such as Power BI and Google Analytics to expand her skillset.
Looking ahead, Ivy aims to build a career as a Web Developer or Data Analyst. She is excited about leveraging the knowledge and skills she has acquired through her studies and professional experiences to make meaningful contributions in these fields.
Community Services in Councils Project
Ivy has selected the Mount Barker District Council for her Power BI and Canva council reports, focusing on a database of approximately 382 community services operating in the area. Her reports cover the financial years 2021-2022, 2022-2023, and 2023-2024, along with a four-year comparison from 2020 to 2024. The completed reports can be found >>here.
Ivy has selected the Mount Barker District Council for her Power BI and Canva council reports, focusing on a database of approximately 382 community services operating in the area. Her reports cover the financial years 2021-2022, 2022-2023, and 2023-2024, along with a four-year comparison from 2020 to 2024. The completed reports can be found >>here.
To create the community service data presentation, Ivy utilized instructions from previous interns and returning volunteers, extracting information from Google Analytics and SAcommunity. She employed Power BI and Canva to generate the visualizations. To ensure data integrity, Ivy compared current data with previous years and sought guidance from team leaders and supervisors to update the primary categories.
After finalizing the report, Ivy published the data on the website and introduced it to Mount Barker Council stakeholders for feedback on 29 October 2024. She also sent the report to the Mount Barker Council Community Grants Officer on 4 November 2024 via email and followed up with a phone call on 5 November 2024 to ensure any feedback or concerns were addressed.
Work experience - Internal and External Events, Connections and Networks
Volunteers and interns are encouraged to attend monthly SAcommunity Team meetings, Connecting Up staff meetings, as well as quarterly all-staff Infoxchange Town Hall meetings to understand more about the organisation as a whole.
Volunteers and interns are encouraged to attend monthly SAcommunity Team meetings, Connecting Up staff meetings, as well as quarterly all-staff Infoxchange Town Hall meetings to understand more about the organisation as a whole.
Organisation-wide news, events and projects are communicated through the staff channels, with weekly CEO Updates from David Spriggs. Informal 'Lunch and Learn' educational sessions, and network meetings create connections with staff. Whilst peer-to-peer training or capacity building and telephone techniques training allow for networking with other volunteers. Interns are also given opportunities to attend stakeholder and partner events as they arise.
Relevant meetings and training sessions Ivy has attended include:
Training and Development - Telephone Techniques
Telephone techniques follow on with email and communication techniques, to assist Data Analytics Team members with understanding more about the directory and data collection methods, in data cleaning and updating their individual dataset information, and, in finally introducing and presenting their data reports to council stakeholders.
Connecting Up Staff Meeting 13 August 2024 & 10 September 2024Updates from the Connecting Up Team includes monthly highlights, plans, activities
IX Lunch & Learn Sessions
Launch of the IX Way on 12 August 2024
Jo Davies, Chief Operating Officer & Jenna Bertieri, People and Culture Change Manager presented the launch of the IX Way during a Lunch & Learn session. The IX Way is designed to foster a unified sense of purpose and approach across the organization, guiding our culture, ways of working, interactions, values, and accountability.
A key highlight of the IX Way is the introduction of “Cake and Connect Day,” starting in September. This new initiative aims to encourage social interaction and foster a sense of community by bringing people together in common spaces across various locations. The event will be scheduled at different times throughout the week and month to accommodate hybrid working arrangements, ensuring everyone has the opportunity to participate.
The principles of hybrid work were also emphasized, focusing on balance, teamwork, wellbeing, connection, and ownership. These principles are intended to support employees in managing their work-from-home experiences effectively while maintaining strong team dynamics and personal wellbeing.
A significant takeaway from the session was the emphasis on communication management within Infoxchange. Clear communication practices are essential, including defining the purpose and goals of meetings and utilizing the appropriate formal communication tools. Adherence to branded templates for both internal and external communications was highlighted to ensure consistency in branding and messaging.
Health & Wellbeing Webinar - Foods to Boost Your Mood on 20 August 2024
Elaine Fox, Head of Product and Innovation at Healthworks, provided insightful information on how diet can influence mood during this webinar. She highlighted that a holistic dietary approach can significantly impact our emotional well-being.
Elaine recommended a diet rich in a variety of plant-based or minimally processed foods, such as fruits and vegetables. She suggested incorporating moderate amounts of high-quality proteins, including seafood, lean meats, and dairy products, while limiting the intake of highly processed foods, and shared practical tips for boosting mood through diet, such as consuming five servings of vegetables and two servings of fruits daily, including Omega-3 fats from fish and nuts, and ensuring adequate intake of vitamins and minerals for brain health.
Elaine also addressed the appeal of hyper-palatable foods, which are often high in calories but low in nutritional value. While these foods can offer a temporary mood boost, they are often difficult to resist and can create a cycle of craving and overconsumption. This initial pleasure is frequently followed by a desire to repeat the experience, leading to more consumption of unhealthy foods, which can have long-term effects on overall health and well-being.
Overall, the webinar was valuable for gaining a deeper understanding of how diverse food choices impact health. It encouraged me to reassess my current diet and consider adopting a healthier approach for improved well-being.
Innovation at Infoxchange on 25 September 2024
Jo Davies, Chief Operating Officer at Infoxchange, delivered an insightful presentation on innovation at Infoxchange during this session. She explained that innovation goes beyond creativity and ideas—it spans a range of forms, from incremental to organizational innovation. Jo provided examples for each type: the evolution of razor design as incremental innovation, Airbnb and Netflix for disruptive innovation, and smartphones as radical innovation.
Jo also encouraged attendees to share their examples of innovation. I learned that Andrew Mahar, Infoxchange’s founder, whose innovative approach in the 1990s led to the creation of the first online crisis accommodation register to help people experiencing homelessness find shelter. Similarly, the SAcommunity directory transitioned from printed Yellow Pages to an online format in the 1990s, marking another innovation in that space.
A key takeaway for me was the introduction of the 3 Horizons model, which outlines three stages: Now, Near Term, and Future. Jo mapped Infoxchange’s products and services to each stage and linked it to the 70/20/10 Principle—spending 70% of time and resources on current operations, 20% on learning and growth, and 10% on exploring new ideas and processes. This framework resonated with me as a strategic approach for organizing my own career plans. By applying this model, I can more effectively structure my goals, balance immediate priorities with future aspirations, and reduce uncertainty as I move forward in my career.
IX Community & Cultural Events & Activities
Cake and Connect - R U OK? DAY on 10 September 2024
Attending R U OK? Day provided a meaningful reminder of the importance of staying connected and checking in with those around us. The event emphasized the crucial role of having regular, heartfelt conversations to support anyone going through a challenging time. It reinforced the idea that asking “Are you OK?” should become a natural part of our everyday interactions, ensuring that people feel valued and supported, whether their struggles are big or small.
The Cake and Connect session was both delightful and insightful. Sharing cakes and engaging in casual conversations created a friendly and relaxed atmosphere. On top of that, we picked up some useful tips for boosting our physical and mental health, like getting some morning sunlight and taking a cold shower to invigorate ourselves. These little changes can make a big difference in how we feel day-to-day.
The opportunity to genuinely check in with one another was invaluable. The session was a reminder that reaching out should extend beyond the event itself. It’s essential to check in not only with colleagues but also with our families and friends. The day underscored that genuine care and connection can happen at any time, and that is something we should carry with us every day.
IX Stakeholder Events
Data Catalyst Network (DCN): Brings together people from across sectors, to break cycles of disadvantage through the innovative use of data.
Data Catalyst Network (DCN): Brings together people from across sectors, to break cycles of disadvantage through the innovative use of data.
Participants of the Data Catalyst Network will advance their data maturity while sharing and improving data insights through unique cross-sector partnerships to disrupt disadvantage. As a collective, the network will harness data and knowledge from the not-for-profit community sector, academia, government and business to better use and manage data to improve the lives of people across Australia.
DCN: Working with Government Data on 1 October 2024
Data sharing in educational programs like the Learning for Life initiative by The Smith Family highlights both challenges and opportunities in collaborative efforts to address educational inequality. This program provides long-term support to children from their first year of school through to tertiary education, offering financial aid, mentoring, and practical educational assistance. Anne Hampshire from The Smith Family and David Engelhardt from the South Australian Department of Education shared their experiences with data sharing, emphasizing the importance of partnerships rooted in a shared vision to promote student well-being and equity.
Anne discussed the types of data collected in the Learning for Life program, such as attendance and achievement metrics, which help frontline staff identify areas for targeted support. The program’s use of dashboards to visualize this data is instrumental in tailoring assistance to students’ needs. Ethical considerations, including obtaining consent from families, are a key component of the program's data sharing practices.
David explained that the government’s involvement in the Learning for Life program leverages frameworks like the South Australian Data Sharing Act, which incorporates the "five safes" framework: safe people, projects, settings, data, and outputs. These guidelines ensure that sensitive information is handled securely, enabling researchers and non-government organizations to collaborate effectively. While these frameworks enhance the ability to address educational disparities, David acknowledged the cultural and legal barriers that still exist, particularly for organizations unfamiliar with government data systems. Establishing data sharing protocols often requires significant time and effort, but the growing awareness of public benefits is driving more streamlined and impactful partnerships. Additionally, organizations must be clear about the types of data they need from government agencies to ensure effective collaboration and maximize program outcomes.
Overall, effective data sharing is critical for improving educational outcomes and addressing inequalities. Legal and ethical considerations, such as the need for consent, play a central role in fostering trust and ensuring responsible data handling. Building a collaborative culture around data sharing is essential for enhancing partnerships between governments and non-profits, though it requires navigating complex challenges. As these processes become more streamlined, the potential for positive impact on education continues to grow.
Interns Ivy and Todd with Cameron Brown (right) 17 Sep 2024
Mentor Meeting 17 September 2024
Connecting Up Volunteers and Interns are provided with the opportunity to select staff members from across the wider Infoxchange organisation for an informational mentor meeting. Here they have the opportunity to ask more about staff members job roles and employment journey, and learn about their career and professional development, to gain insights and guidance that can be applied towards their own success.
Volunteers and interns both prepare 5 questions for their mentors and then are encouraged to record 5 aspects they felt were helpful for them to share on their portfolio for both themselves and other volunteers, and Ivy shared her experience with Todd, Guanhua Tao in meeting Cameron Brown Web Developer, Infoxchange.
Meeting Cameron Brown was an enlightening experience that provided me with valuable insights as a graduate entering the IT field. Cameron shared his perspective on the job market, emphasizing that languages and frameworks like Python, JavaScript, React, and PostgreSQL are currently in high demand. He highlighted the importance of soft skills and problem-solving abilities over focusing solely on technical expertise, and he noted that networking and building relationships are often critical in securing jobs.
Cameron stressed the value of building a strong portfolio through real-world projects and internships, with GitHub being an essential platform to showcase practical skills. He also explained that formal qualifications are not necessarily required for success in web development, as hands-on experience and the ability to solve problems are more important. Additionally, Cameron acknowledged the difficulty of staying up to date with every new technology, advising that it’s better to focus on learning what’s relevant to one's role.
The most impactful takeaway from our discussion was Cameron’s advice not to stress about excelling immediately as a new graduate. He emphasized that it’s more important to learn, make mistakes, and ask questions rather than striving for perfection from the start. This perspective was reassuring, as it reminded me that not being proficient in every technical skill is part of the learning process.
Digital Training & DevelopmentVolunteers and interns have access to the Connecting Up Digital Learning Platform providing live webinars and recorded webinars, workshops and webcons presented by subject-matter experts to understand more about a range of technology topics for the not-for-profit sector.
Relevant training sessions were selected, attended, summarised and assessed by Ivy to look at how these sessions can enhance her internship experience have included:
Getting Started with Data: Fundamentals, strategies and setting up quick wins
The webinar began by encouraging attendees to reflect on five key questions ranging from identifying the organization's goals, determining how to achieve those goals to understanding what is needed to reach the goals. It was emphasized that the foundation of data strategy must align with organizational purposes, and all data efforts should ultimately serve these objectives.
Understanding the goals allows organizations to integrate their data strategy with their business strategy. For instance, the example from Mission Australia demonstrated how a well-crafted data strategy and insightful analysis can produce robust and impactful results. A data strategy involves identifying the data, tools, and techniques necessary to answer specific questions.
The next step involves gathering information both internally and externally, reviewing the findings, and reaching consensus. Data review includes confirming the security level and type of data collected to ensure that access is appropriately restricted. Following this, the information from interviews and data reviews is used to pinpoint organizational priorities and identify gaps in the collected data. The final theme of the webinar focused on project objectives, explaining how to address specific problems using the collected data.
My key takeaways from the webinar include the importance of confirming the purpose of data collection, determining the target audience for the data report, and identifying the issues the report will address. Once these goals are established, we can proceed with processing, analyzing, and presenting the data effectively.
Getting Started with Analytics: Tools, Infrastructure & Data
The webinar, presented by Kristen Moeller-Saxone, Data Capability Lead at Infoxchange, and Vivek Katial, Co-Founder and Executive Director at Good Data Institute (GDI), offered practical advice on selecting the right data tools and infrastructure based on an organization’s size and data needs. The session covered a range of tools, from basic options like Google Sheets and Excel for smaller datasets and fewer users to more advanced platforms such as Azure, AWS, Salesforce, and PostgreSQL for handling larger datasets, more users, real-time data needs, and complex analytics.
A significant portion of the webinar focused on the full data project lifecycle. Vivek introduced attendees to the phases of objective setting, data collection, analysis, and action, providing detailed explanations of what each phase entails. This comprehensive overview aimed to equip participants with a clear understanding of the entire data project process. Vivek also highlighted effective strategies for managing messy data, including a simple data cleaning process. The use of AI, particularly ChatGPT, was emphasized to streamline and accelerate data cleaning. Attendees learned how to leverage AI for generating effective formulas in Excel or Google Sheets through clear and structured instructions.
One of the standout aspects of the webinar was the case study presented by GDI, showcasing their real impact measurement project with CaringKids. GDI demonstrated how they used de-identified raw data—including origin and destination addresses, courier costs, and box weight—to calculate the total distance toy boxes traveled. By employing a custom Google Maps function in Google Sheets, GDI was able to visualize the distribution of toy boxes across Australia. This practical example underscored the importance of data visualization in understanding and communicating data insights.
The key takeaway from the session was GDI's recommendation to migrate toy box order forms to a more automated system. This change would reduce the manual data entry workload and enhance data analysis efficiency. GDI provided the necessary technical skills and established a framework for ongoing analysis, ultimately improving the operational capabilities of CaringKids.
Getting Started with Microsoft Power BI for Data Analysis & Visualisation
Chris Olsen, Senior Cloud Solution Architect, and Benny Austin, Cloud Solution Architect at Microsoft, recently presented an insightful webinar on leveraging Power BI for data analysis and visualization.
Chris provided a comprehensive overview of Power BI, explaining its core functions and capabilities. He demonstrated how Power BI connects multiple datasets with just a few clicks, integrating various resources to generate deeper insights. Additionally, Chris highlighted the integration of Copilot, which enhances Power BI’s functionality by allowing users to ask questions in natural language, thereby maximizing its potential.
Benny then walked us through the process of getting started with Power BI, using sample sales data to illustrate its features. He showcased how AI integration within Power BI enables users to ask questions and receive immediate answers, with visualizations automatically adjusting based on the query. Benny also demonstrated how Power BI’s Copilot can generate summaries and highlight key aspects of the dataset. Additionally, he showed that users can provide prompts in natural language to Copilot, which can then create visualizations based on those requests. This feature enhances the user experience by making it easier to generate and customize visualizations without needing to manually configure each one.
My key takeaway from this webinar is the versatility of Power BI. It can be accessed from various devices via its app, allowing for seamless collaboration. Users can annotate visualizations and share snapshots, with dashboards automatically adapting for different platforms—Windows, iOS, and Android. Power BI’s integration with Office apps and the abundance of learning resources available make it a powerful tool for enhancing work efficiency and accessibility.
