Using Data Analysis & Visualisation to Drive Social Impact

AN INTRODUCTION TO POWER BI
CREATED BY:
Adriana Mendieta, Jenny Riley
Are your reports creating cut-through? Does your impact speak for itself? If not, it’s time to harness data technology to help you track and drive social impact.
With dataset examples from community programs, learn how you can make your work stand out using Power BI to improve reporting, support data-driven decision making, and see impact in real-time.
Note: 15% discount applies for non-profits, Australian Evaluation Society members, and students.

Course information

  • Mode: Online
  • Pre-requisites: basic Excel
  • Cost: $1200 AUD
  • Start date: 5 November 2021
  • Duration: 6 weeks
  • Intensity: 3-4 hours per week
Enrol
Register your interest

What our learners say

"The course was very comprehensive and the 'learning by doing' methodology has enabled me to feel as though I have been able to grasp some elements of the course to utilise in my work."

PBI Course Participant

December 2019

Adriana was an excellent presenter and communicator, and this course is a perfect introduction to Power BI for staff working on impact reporting.

PBI Course Participant

December 2019

"The trainers and assistants were clearly very experienced educators and subject matter experts."

PBI Course Participant

December 2019

Find out More & Enrol Today

Course overview

This course isn’t just about creating great reports. It’s about getting the right information to the right audience to make strategic, evidence-based decisions. 

Join us to learn how to effectively use data to create meaningful reports in Power BI using real-world social impact data and examples.

Starting with hands-on exercises in the familiar MS Excel environment, we’ll build your knowledge of data filtering and aggregation. With these foundations, we’ll use Power BI to create stunning reports and learn best practices for choosing data visuals for driving strategic decision-making and improving your communications. You’ll practice pulling data from multiple sources, learning to use Power Query to transform data into coherent datasets as well as the basic concepts for using Power Pivot on data models. Finally, you’ll learn how to easily publish and share your reports with your stakeholders.

learning outcomes

By the end of this course, you will be able to:
  • Recognise Power BI’s main components and functions
  • Understand and use basic data modelling terminology and principles
  • Understand how data aggregation & filtering work and apply these concepts to create visualisations
  • Use basic data relationships concepts to create visualisations
  • Connect external data sources like Excel and websites to Power BI Desktop
  • Create compelling reports and visualisations in Power BI Desktop
  • Publish reports in Power BI Service

Course inclusions

  • Great mix of content including text, images, videos and interactivities
  • Learning to suit your schedule including hands-on practical application of the content through exercises using social datasets
  • Suite of resources including course cheat sheets, our guide to selecting visualisations, and course summary slides
  • Access to an experienced PBI developer and mentor during weekly live virtual sessions
  • Online discussions with PBI mentors and peers about social impact reporting needs and solutions
  • Indefinite access to the course content post formal course conclusion
Want to know if this course is right for you? You can contact our Academy team on info@clearhorizonacademy.com or (+61) 3 9425 7777 to find out more. Or, check out our FAQs page.

Course facilitators

Join us to build your skills and create greater impact today!

Register your interest
Enrol now

Who is this course for?

This course is for evaluation and impact professionals and program managers who need to analyse and visualise data. This is a beginner’s level course. Participants will need a basic knowledge of MS Excel and access to a laptop with Windows 7 or 10 operational system and Excel 2016 or later.
CHA Icons-67

MEL Professionals

Monitoring and Evaluation Managers, Officers, Project Managers and Consultants responsible for activity and impact reporting.

Dash Teal Icon-100

Data and Reporting experts

Data analysis and reporting Officers, Managers and Consultants looking to provide social impact reports and real-time data.

more COURSES​

CLEAR HORIZON ACADEMY

  • (+61) 3 9425 7777
  • Email us
  • 132B Gwynne Street, Cremorne, 3121, VIC

INFORMATION

Learning

Help

Sign up to our Newsletter

The Clear Horizon Academy is a learning initiative of Clear Horizon.

We acknowledge the Traditional Custodians of the lands on which Clear Horizon is located and where we conduct our business. We pay our respects to Elders, past, present and emerging. Clear Horizon is deeply committed to honouring Indigenous peoples’ unique cultural and spiritual relationships to the land, waters and seas; and to transforming evaluation practice to uphold and reflect Indigenous values.
Join Waitlist We will inform you when the product arrives in stock. Please leave your valid email address below.
Jess Dart sq

Dr Jess Dart

FounDING DIRECTOR & PRINCIPAL CONSULTANT

Inventor of practical methodologies and highly demanded facilitator, Jess navigates complexity with comfort and helps her clients to become clear about their desired outcomes and how to get there.

Recipient of the 2018 AES Award for outstanding contribution to evaluation, Jess has over 25 years experience in evaluating and designing social change initiatives and strategies in Australia and overseas.

In October 2005, Jess founded Clear Horizon Consulting and is now CEO. She is also a board member of the Australasian Evaluation society.

Jess is passionate about developing and designing real world evaluation and strategy for social justice and sustainability. She particularly works with systems change interventions, large scale strategy and social innovation. After completing her PhD she co-authored the Most Significant Change (MSC) guide alongside Dr Rick Davies, which is now translated into 12 different languages.

MSC is well suited to evaluation in the complex emergent context. The latest innovation by Jess, Collaborative Outcomes Reporting (COR), is a collaborative form of impact evaluation.

Jess is also an active mum and has two teenage boys. In a quiet moment, she loves reading far-future science fiction and enjoys long distance running.

Please provide your information
before downloading pdf file