SAcommunity Data Analytics Team - Internship or Placement Position Description
Data Analytics Team
Interns Deekshitha Goud Podeti, Joy Meixuan Liao and Shrushti Rajendra Ladage
Brief Placement/Internship Overview and Details
Placement name/group:
About the organisation (brief overview)
Established in 1981, SAcommunity is a free community information service supported by the Government of South Australia and provided at Connecting Up, a TechSoup Global Network partner and the Adelaide division of Infoxchange, a not-for-profit social enterprise, that has been delivering technology for social justice for over 37 years.
Established in 1981, SAcommunity is a free community information service supported by the Government of South Australia and provided at Connecting Up, a TechSoup Global Network partner and the Adelaide division of Infoxchange, a not-for-profit social enterprise, that has been delivering technology for social justice for over 37 years.
Activity Dates:
Tuesdays or Wednesdays or Fridays, mornings or afternoons or whole days are available onsite at the office
Location:
Connecting Up, Level 1, 25 Leigh Street Adelaide SA 5000
Contact:
Position: Community Service Directory Manager / Community Information and Volunteer/Intern Coordinator
Phone: 08 7095 2233
Email: cmcintyre@infoxchange.org
Specific Requirements:
Interview, Reference Checks, Police Check
About the organisation (detailed overview)
Infoxchange https://www.infoxchange.org/au is a not-for-profit social enterprise that has been delivering technology for social justice since 1989. With over 140 staff across Australia, with branches in Melbourne, Brisbane and Adelaide, we tackle the biggest social challenges through the smart and creative use of technology.
Connecting Up https://www.connectingup.org is a service of Infoxchange based in Adelaide, and provides a variety of technology-based information, products, training and services for the not-for-profit sector in Australia and New Zealand. A member of the TechSoup Global Network, http://www.techsoup.org/ all partners are leading civil society organisations and manage a range of capacity building programs in their countries.
Established in 1981, SAcommunity https://sacommunity.org is a free, online community information service supported by the Government of South Australia https://www.sa.gov.au/topics/about-sa/directories/community and provided onsite at Connecting Up, a service of Infoxchange.
Data Analytics Team and Website Rebuild Team
Shrushti Rajendra Ladage, Joe Xanqiao Zhang, Deekshitha Goud Podeti, Rex Porter, Stathis Avramis, Joy Meixuan Liao, Robert Quoc Huy Tran, Yong Kheng Beh, Charmi Divecha
Placement Overview (Activity Scope)
About the Database
The SAcommunity Community Information Directory is an online CiviCRM database consisting of ~15,500 records receiving ~1,7000,000 views a year. This continually maintained, summarised and structured data is held under a Creative Commons Attribution License for public benefit.
About the Project
Students as part of the Data Analytics Team prepare, clean, and create reports, dashboards and maps on community record data, presented using Power BI and Canva and published on the SAcommunity Statistics webpage, investigating service types, availability and demand over time.
Project roles and responsibilities
Students select one or more councils (or electorates, as available) and utilise data subset exports from the SAcommunity database and Google Analytics. Students’ clean data and prepare multiple reports for the council(s) or electorate(s), as available up to the current calendar/financial year using documented instructions, given templates, tools and platforms; Office365 (Outlook, Excel, Teams), CiviCRM database, Google Analytics, Python, GitHub, Power BI and Canva.
Interns Deekshitha Goud Podeti, Joy Meixuan Liao and Shrushti Rajendra Ladage with staff member Kristen Moeller-Saxone, Data Capability Lead Infoxchange, Melbourne
Activity Deliverables What is the deliverable? (brief overview)
What is the Data Content?
The Data comprises of community information records which describe resources that meet the information needs of a community and include details of: Organisations (associations, groups and clubs); Programs or services (childcare, food assistance), Events (annual fairs, shows and festivals) and Other resources (facilities, sports centres, swimming pools).
Why is the Data Significant?
Community Information documents and reflects life, the directory provides a contact list of organisational information in a classified order, indexed and summarised in brief format reflecting community services available for the public. Community services and services demand are impacted by and emulated in the changes in social conditions, economic development, demographics, and cultural diversity of the population they serve.
Who is the Directory Database for?
Information is available on the website for the public and community service organisations, to discover ‘who is doing what, where’ in the not-for-profit sector, with data exports used by government, councils and public libraries for referrals (assistance), communication (e-campaigns), consultation (community engagement, partnerships) and research.
How can I have impact?
Data reports allow data-driven insights to reveal community patterns, trends and relationships. This supports decision-makers in councils, government, or public libraries to understand more about the community services operating in their area and their residents’ needs. Whilst the practice of producing reports and subsequent data cleansing improves the quality of database information for all stakeholders, as any updates, changes and anomalies found and corrected for the report are applied to the online directory database.
Please find following links for further information:
Roles and positions available and the benefits for volunteers and interns
including opportunities to access:
Interns Deekshitha Goud Podeti, Joy Meixuan Liao and Shrushti Rajendra Ladage with staff member Kristen Moeller-Saxone, Data Capability Lead Infoxchange, Melbourne
Activity Deliverables What is the deliverable? (brief overview)
Produce and publish SAcommunity data reports and insights to complete the current calendar/financial year for one or more councils or electorate areas by the end of the placement/internship (determined by number of financial years required and council/electorate dataset(s) size)
What is the deliverable and benefit for me? (detailed overview)
Standardised calendar and financial year data reports for services in the local government council or electorate up to the present year are created in Power BI and Canva and published on the SAcommunity statistics webpage and introduced by email and phone along with data exports to the stakeholder.
Given templates for a Power BI dashboard presenting year-to-year comparison on available data to date (i.e. 6-year comparison), map visualisation on services/categories and paragraph on data insights (GA4 Analytics Insights: Analytics Advisor) aside social/economic considerations.
Reports are attributed to the student creator on the website. Student reports are publicly available, and present a tangible case-study, providing evidence of their work and demonstrable skills for future employers.
Activity Outcomes
- Understand the importance of accurate community information in data reporting
- Learn more about the community and not-for-profit sector
- Practice information and digital literacy skills
- Learn basic skills and tools (CiviCRM database, Google Analytics) for accessing and assessing data
- Learn basic skills and tools (Power BI, Canva) for presenting and summarising data
- Create, prepare, assess and publish data reports on the website for stakeholders
Activity Requirements
Skills Required:
- Interest in or knowledge of Data Analysis
- Interest in or knowledge of the Community and Not-for-Profit sector
- Information literacy and digital literacy skills
- Capable of being self-motivated and proactive
- Able to actively engage in a range of opportunities including meetings, workplace events, activities and training sessions
- Capable of following staff directions, abiding by workplace policies and procedures
- Able to work under general supervision, effectively communicate and collaborate with staff and team members
- Able to work as a member of a team and build positive and productive working relationships
