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.
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.
All SAcommunity Records Power BI Report
Community Service Organisations, organised by Suburbs, Subject Headings, and in a geographically referenced information format (Maps)
Adelaide Council (City of Adelaide)
Adelaide Hills Council
Adelaide Plains Council
Alexandrina Council
APY Lands (Anangu Pitjantjatjara Yankunytjatjara)
Barossa Council
Barunga West Council
Burnside Council (City of Burnside)
Campbelltown City Council
Ceduna Council (District Council of Ceduna)
Charles Sturt Council (City of Charles Sturt)
Clare and Gilbert Valleys Council
Cleve Council (District Council of Cleve)
Coober Pedy Council (District Council of Coober Pedy)
Coorong District Council
Copper Coast Council
Elliston Council (District Council of Elliston)
Flinders Ranges Council
Franklin Harbour Council (District Council of Franklin Harbour)
Gawler (Town of Gawler)
Gerard Community Council
Goyder Council (Regional Council of Goyder)
Grant Council (District Council of Grant)
Holdfast Bay (City of Holdfast Bay)
Kangaroo Island Council ~ Prepared by Volunteer Renu Bala
Karoonda East Murray Council (District Council of Karoonda East Murray)
Kimba Council (District Council of Kimba)
Kingston District Council
Light Regional Council
Lower Eyre Peninsula (District Council of Lower Eyre Peninsula)
Loxton Waikerie Council (District Council of Loxton Waikerie)
Maralinga Tjarutja Community Inc
Marion Council (City of Marion)
Mid-Murray Council
Mitcham Council (City of Mitcham)
Mount Barker District Council
Mount Gambier Council (City of Mount Gambier)
Mount Remarkable Council (District Council of Mount Remarkable)
Murray Bridge Council (Rural City of Murray Bridge)
Naracoorte Lucindale Council
Nepabunna Community Council
Northern Areas Council
Norwood, Payneham & St Peters (City of Norwood, Payneham & St Peters)
Onkaparinga Council (City of Onkaparinga)
Orroroo Carrieton Council (District Council of Orroroo Carrieton)
Outback Communities Authority
Peterborough Council (District Council of Peterborough)
Playford Council (City of Playford)
Port Adelaide Enfield (City of Port Adelaide Enfield)
Port Augusta City Council
Port Lincoln Council (City of Port Lincoln)
Port Pirie Regional Council
Prospect Council (City of Prospect)
Renmark Paringa Council
Robe Council (District Council of Robe)
Roxby Downs Council (Municipal Council of Roxby Downs)
Salisbury Council (City of Salisbury)
Southern Mallee District Council
Streaky Bay Council (District Council of Streaky Bay)
Tatiara District Council
Tea Tree Gully Council (City of Tea Tree Gully)
Tumby Bay Council (District Council of Tumby Bay)
Unley Council (City of Unley)
Victor Harbor Council (City of Victor Harbor)
Wakefield Regional Council
Walkerville Council (Town of Walkerville)
Wattle Range Council
West Torrens Council (City of West Torrens)
Whyalla Council (City of Whyalla)
Wudinna District Council
Yalata Community
Yankalilla (District Council of Yankalilla)
Yorke Peninsula Council
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.
