Community Service Statistics by Council


Volunteer Sophie Hood, Hang Zhang and Stathis Avramis

Community service data summaries for councils
Volunteers have used the Power BI data visualisation tool to present SAcommunity web analytics reports for local councils. These whole of South Australia and council-based analytic summaries on community service information demands, provide an indication of community needs in the area for partner councils of SAcommunity.



All SAcommunity Records Power BI Report
Community Service Organisations, organised by Suburbs, Subject Headings, and in a geographically referenced information format (Maps)
~ Prepared by Volunteer Stathis


Tech Tools Used and Report Access Formats
Canva PDF
- provides a one page visual summary on community services within a council area
Power BI Export - PDF
- provides a three page (static) snapshot summary of community service data presented in Power BI
Power BI Embedded Report
- provides dynamic interactive visualisation of community service data 



SA Councils List
There are 69 SA Councils and 6 Aboriginal and Outback Communities in South Australia listed on the LGA SA councils list.

Adelaide Council (City of Adelaide) ~ Prepared by Volunteer Stathis

Adelaide Hills Council
   
~Prepared by Volunteer Stathis Avramis & Renu Bala

Adelaide Plains Council  ~Prepared by Volunteer  Hang Zhang, Stathis Avramis & Renu Bala

Alexandrina Council ~Prepared by Volunteer Hang Zhang & Stathis Avramis

APY Lands (Anangu Pitjantjatjara Yankunytjatjara) ~Prepared by Volunteer Stathis Avramis & Renu Bala

Barossa Council ~Prepared by Volunteer Hang Zhang & Renu Bala, Thea Shiye Jin

Barunga West Council ~Prepared by Volunteer Stathis Avramis & Jesslyn Danli

Berri Barmera Council ~Prepared by Hang Zhang

Burnside Council (City of Burnside) ~Prepared by Volunteer Sophie Hood & Stathis Avramis

Campbelltown City Council 
~Prepared by Volunteer Sophie Hood & Renu Bala & Ziqi Xu

Ceduna Council (District Council of Ceduna) ~Prepared by Volunteer Stathis Avramis

Charles Sturt Council (City of Charles Sturt) ~Prepared by Volunteer Stathis Avramis & Natasha Kwan

Clare and Gilbert Valleys Council 
~Prepared by Volunteer Hang Zhang & Jesslyn Danli

Cleve Council (District Council of Cleve) ~Prepared by Volunteer Hang Zhang & Jesslyn Danli

Coober Pedy Council (District Council of Coober Pedy) ~Prepared by Volunteer Hang Zhang, Renu Bala & Jesslyn Danli

Coorong District Council - Prepared by Volunteer Stathis Avramis & Jesslyn Danli

Copper Coast Council ~ Prepared by Volunteer Hang Zhang & Jesslyn Danli

Elliston Council (District Council of Elliston) ~ Prepared by Volunteer Renu Bala & Julia Koh

Flinders Ranges Council - Prepared by Volunteer Hang Zhang & Julia Koh

Franklin Harbour Council (District Council of Franklin Harbour)

Gawler (Town of Gawler) - Prepared by Volunteer Stathis Avramis

Gerard Community Council

Goyder Council (Regional Council of Goyder) ~ Prepared by Stathis Aramis & Jesslyn Danli

Grant Council (District Council of Grant) ~ Prepared by Jesslyn Danli
 

Holdfast Bay (City of Holdfast Bay) ~ Prepared by Volunteer Renu Bala, Julia Koh, Daisy Fangqiang Shan

Kangaroo Island Council ~ Prepared by Volunteer Renu Bala 

Karoonda East Murray Council (District Council of Karoonda East Murray)

Kimba Council (District Council of Kimba) ~ Prepared by Volunteer Jesslyn Danli

Kingston District Council ~ Prepared by Jesslyn Danli

Light Regional Council ~Prepared by Volunteer Stathis Avramis & Julia Koh

Lower Eyre Peninsula (District Council of Lower Eyre Peninsula)

Loxton Waikerie Council (District Council of Loxton Waikerie) ~Prepared by Volunteer Stathis Avramis & Renu Bala

Maralinga Tjarutja Community Inc 

Marion Council (City of Marion) ~ Prepared by Volunteer Stathis Avramis & Navodani Thennakoon

Mid-Murray Council~ Prepared by Volunteer Erin

Mitcham Council (City of Mitcham) ~Prepared by Volunteer Stathis Avramis

Mount Barker District Council ~ Prepared by Volunteer Sophie Hood & Stathis Avramis, initiated by Nirupama Amarakoon

Mount Gambier Council (City of Mount Gambier) ~ Prepared by Volunteer Stathis Avramis & Renu Bala

Mount Remarkable Council (District Council of Mount Remarkable) 

Murray Bridge Council (Rural City of Murray Bridge)

Naracoorte Lucindale Council ~ Prepared by Jesslyn Danli

Nepabunna Community Council

Northern Areas Council

Norwood, Payneham & St Peters (City of Norwood, Payneham & St Peters) ~Prepared by Volunteer Stathis Avramis

Onkaparinga Council (City of Onkaparinga) ~ Prepared by Putri Kamaluddin

Orroroo Carrieton Council (District Council of Orroroo Carrieton)

Outback Communities Authority

Peterborough Council (District Council of Peterborough) ~ In progress by Sarthak Jain

Playford Council (City of Playford) ~ Prepared by Volunteer Stathis Avramis

Port Adelaide Enfield (City of Port Adelaide Enfield) ~ Prepared by Volunteer Stathis Avramis

Port Augusta City Council ~ Prepared by Volunteer Renu Bala

Port Lincoln Council (City of Port Lincoln) ~Prepared by Volunteer Stathis Avramis & Renu Bala

Port Pirie Regional CouncilPrepared by Volunteer Stathis Avramis

Prospect Council (City of Prospect) ~Prepared by Volunteer Stathis Avramis

Renmark Paringa Council ~Prepared by Volunteer Stathis Avramis

Robe Council (District Council of Robe) ~ Prepared by Govinda Gurung

Roxby Downs Council (Municipal Council of Roxby Downs) ~ Prepared by Volunteer Waleed Sayeed

Salisbury Council (City of Salisbury) ~Prepared by Volunteer Stathis Avramis

Southern Mallee District Council ~ Prepared by Volunteer Tanvi Srivastava

Streaky Bay Council (District Council of Streaky Bay)

Tatiara District Council ~Prepared by Volunteer Govinda Gurung

Tea Tree Gully Council
 (City of Tea Tree Gully) 
~Prepared by Volunteer Stathis Avramis & Ziqi Xu

Tumby Bay Council (District Council of Tumby Bay) ~Prepared by Volunteer Julia Koh

Unley Council
 (City of Unley) ~Prepared by Volunteer Stathis Avramis

Victor Harbor Council (City of Victor Harbor) ~Prepared by Volunteer Jesslyn Danli

Wakefield Regional Council ~ Prepared by Jesslyn Danli

Walkerville Council (Town of Walkerville) ~Prepared by Volunteer Ziqi Xu

Wattle Range Council

West Torrens Council (City of West Torrens) ~Prepared by Volunteer Renu Bala

Whyalla Council (City of Whyalla) ~ Prepared by Blake Kennison & In progress by Camille Sze Pui Ko 

Wudinna District Council

Yalata Community

Yankalilla (District Council of Yankalilla)

Yorke Peninsula Council ~ In progress by Yang Jiao
 


Intern Millicent Jesslyn Danli, Volunteer Ziqi Xu and Intern Julia Koh

Legend

Count by Primary Category
- refers to number of organisations/services in the council listed under this category
i.e. Primary category is Recreation, Count of Primary Category 107
e.g. 107 services listed in a council area are indexed under the primary heading/category 'Recreation'
 - Percentage of Sessions by Primary Category
i.e. Primary category is recreation, percentage of all sessions/visits in council area means that 40% of visits are for services indexed under recreation for this council

Sessions by Organisation
- refers to number of sessions (a count of the number of user visits to an entry/listing on the site) 
e.g. 682 visits to the Child & Family Health Service - Port Lincoln in FY 2019-2020
- Organisations - Percentage of Total Sessions
i.e. 13.91% of all visits to services in Port Lincoln were to the Child & Family Health Service listing

Sessions defined by Google Analytics refer to 'the period of time a user is active on your site or app. By default, if a user is inactive for 30 minutes or more, any future activity is attributed to a new session. Users that leave your site and return within 30 minutes are counted as part of the original session.'

Organisations by primary category - slicer view

- refers to services listed as operating in a council area as indexed by their primary category for example: lists all those services indexed under 'community organisation & development'
i.e. Slicer view allows filtering of the report under each category with the embedded link 


Volunteer Nirupama Amarakoon and Volunteer Stathis Avramis

Acknowledgements

Thank you to volunteers Nirupama Amarakoon who initiated this project and tools starting with Mt Barker Council data in August 2020 and to Stathis Avramis who has seen this project through from its start in mid-2020, solving some IT coding challenges in the exports to producing step-by-step training documentation, teaching our team by early 2021. Stathis now onboards and trains all members of our data team, including Hang Zhang (started February 2021 - 16 May 2022), Sophie Hood (an established volunteer who rejoined this project in March 2021 - Aug 2021) and Renu Bala (our former intern who rejoined as a volunteer in June 2021 - 23 March 2022) who have joined in this project to use the tools, formulas and data to realise a project that has become a new ongoing volunteer program.

We would also like to thank our interns Julia Koh, Jesslyn Danli and volunteers Blake Kennison, Ziqi Xu who have started in July 2022 also with the guidance of Stathis Avramis.

The Data Analytics program not only allows us to indicate community service demand for council decision-making, it provides another tool to undertake the ongoing data cleansing needed to ensure that records are complete and correct within the database, providing councils, libraries, government and the general public with accurate data exports. 

 

 

The SAcommunity website is licensed under a
Creative Commons Attribution 3.0 Australia Licence. © Copyright