Upcoming Training
Local Data Resources
When: 1 May 2025, 1pm - 3.30pm
Where: The Kollective, 145 17th Ave, Tauranga
Join the Community Insights team to find out about CI Social Data and resources created specifically for Tauranga and the Western Bay of Plenty.
Specifically designed for groups working in the community & social services space, come along for a hands-on workshop to find out how you can access good local data.
This workshop is suited for all abilities – you don’t need data skills to participate or get something out of the workshop.
Using the latest Census 2023 data to explore and discover the answers to questions like:
● How many rangatahi aged 14 - 19 years live in our rohe (area of work/interest)?
● What is the average household income in my suburb? How does this compare to other areas in the WBOP? Which areas have pockets of people who are really struggling financially?
● What is the ethnic makeup of our area?
Bring your laptop, and gain confidence in navigating your way around the dashboards and other data resources we have available.
Excel - Intermediate
When: 8 May, 9.30am - 1.30pm
Where: The Kollective, 145 17th Ave, Tauranga
This Excel training is for intermediate users who know their way around a spreadsheet and want to take their skills to the next level.
What you will learn about:
Find and replace
Work with Auto-fill
Text Functions
Protecting and sharing a workbook
Hyperlinks
Formulas
Functions
Charts
Chart Dashboards
Please bring your laptop for a hands-on workshop facilitated by the very experienced Cathi Barker from Software Solutions.
Spaces are limited to 8 per workshop, book now to secure your space.
Introduction to Power BI (Level 1)
When: 12 June 2025, 9.30am - 1.30pm
Where: The Kollective, 145 17th Ave, Tauranga
Join us to being your journey visualising data with this Level 1, Introduction to Power BI.
This workshop will introduce you to Microsoft’s Power BI tool for connecting and analysing data. In this hands-on workshop, you will learn:
the essential methods of connecting to data correctly
transforming that data so that you will have a data set that is easy to get real insights and valuable information
how to get data from a variety of sources including text/csv, Excel and database files and bring that data into Power BI.
transform data using the Power Query editor including pivoting, transposing, splitting, duplicating, merging, appending, replacing, formatting, applying functions and creating parameter queries and dynamic lists in preparation for reporting and visualisations.
Spaces are limited to 8 per workshop, book now to secure your space.
Power BI (Level 2)
Reports & Visualisations
When: 3 July 2025, 9.30am - 1.30pm
Where: The Kollective, 145 17th Ave, Tauranga
This workshop follows on from the Introduction to Power BI (Level 1) training and will introduce you to the Microsoft’s Power BI report visualisations.
In this hands- on workshop you will learn:
the essential methods of creating and formatting visuals
how to create, manage and format action buttons, cards, multi-row cards, slicers, tables, maps, decomposition trees, matrices, charts (including scatter, pie, donut, waterfall, ribbon and bar charts), smart narratives, Q&A buttons and more
to set up reports for easy navigation, interaction via a mobile device
to publish to a Power BI service for easy access by others
Spaces are limited to 8 per workshop, book now to secure your space.
Introduction to Excel
When: To be confirmed, 3 hr workshop
Where: The Kollective, 145 17th Ave, Tauranga
Never used Excel before, or have you taught yourself but know there must be a better way?
This session will take you through the basics from how to create and use spreadsheets in Excel, to showing you shortcuts and give you an understanding of the key tools including:
Finding your way around a spreadsheet
Working with columns and rows
Data ranges
Formatting
Filtering
Basic Formulas
Shortcuts and tips
Bring your laptop along with Excel loaded and ready to go for a very hands on workshop.
Collecting & Presenting Data Using Google Forms
When: To be confirmed, 3 hr workshop
Where: The Kollective, 145 17th Ave, Tauranga
Learn how you can save time by using Google forms for registrations, feedback and evaluations. We will then take you through how to present the data visually with graphs and charts.
This workshop will cover:
What types of questions to include
Linking QR codes to Google forms
Transforming data collected into basic charts to present to your board and funders
You will need access to a gmail account prior to attending the workshop. Please contact us if you need assistance with setting this up.
Please bring your own laptop as this is a very hands on workshop.
Annual Reporting Correctly and Creatively
When: To be confirmed, 2.5 hr workshop
Where: The Kollective, 145 17th Ave, Tauranga
Use your annual report to tell the story of your organisation using your data correctly and creatively.
Liz Flaherty works with data and knows how the social sector works. Richard Dey from William Buck, Chartered Accountants, knows the mechanics of annual reporting from a financial perspective.
Together they can help you to use your data creatively and correctly, so your annual report will meet all requirements and also tell a story that will interest your members, clients and funders.
Data Storytelling
When: To be confirmed, 3 hour workshop
Where: The Kollective, 145 17th Ave, Tauranga
A follow-up workshop to the Local Data resources workshop.
Now that you know how to find the data that is relevant to your mahi (work), this Data Storytelling workshop will provide participants with the skills and knowledge to effectively communicate data stories.
Through interactive activities and hands-on exercises, participants will practice:
identifying relevant data
framing data so key insights are revealed (story forming)
communicating these insights using narrative and visual elements (story telling)
It is recommended that you attend a Local Data Resources workshop prior to attending this workshop. Alternatively, let us know when you register so we can organise time with someone from the Community Insights team prior to this workshop.
Bring your laptop for a hands-on workshop.
Get in touch!
Get in touch with the Community Insights team to talk with us about your data needs, questions or ideas. We’ll support your organisation to build your skills and expertise in using both your own and relevant external data to enhance and grow your work in our community.
Call us: 07 987 0920
Visit us: The Kollective – 145 17th Ave, Tauranga
Mail: DX BOX HP40007, Tauranga 3112
Terms of use and privacy policy
