-
Gain confidence using Power BI, starting from the very basics and progressing to intermediate skills, fast.
-
Learn to clean and transform your XLSForm-based data seamlessly in Power Bi.
-
Interactivity: Implementing elements that users can click, filter, or manipulate, providing a dynamic experience.
Getting Started in Power BI
Does your data come from KoBoToolbox, ODK, Ona, or another XLSForm-based data collection software? If so, this course will teach you how to use Power BI to visualise your data!
This course is designed for teams who do humanitarian, development and third-sector surveys.
Does your team struggle with transforming raw survey data into actionable visuals?
Are the voices and needs of the very people you serve getting lost in spreadsheets?
Effective humanitarian work depends on data, yes - but if we collect data and can’t visualise it in a way that encourages and allows engagement and decision-making, it means we miss out on that effectiveness!
Do any of the following sound familiar to you?
You are looking for a simple way to create dashboards and reports from your data.
You need more customisation than is offered on KoboToolbox reports.
You would like to have a live connection to your data.
You are still using Excel to clean, analyse and visualise your data.
Maybe you're a...
M&E Officer or specialist
working with data generated by XLS Form-based data collection software.
Research or reporting officers
who need to create engaging and repeatable visual reports from their data.
Programme manager or coordinator
who want to develop "data for decision making" solutions for their projects.
Information Management/ICT Lead
looking for a good way to upskill a diverse and global team.
Partner Organisation
that wants to excel at professional data management for better service delivery to beneficiaries and accountability to donors.
You're in the right place. And I'm going help you gain confidence using Power BI, starting from the very basics and progressing to intermediate skills, fast.
You'll learn to clean and transform your XLSForm-based data seamlessly in PowerBI.
By the end of the course, you'll be able to create engaging and interactive visualisatinos and unlock insights from your data.
This course will walk you and your team members through 3.5 hours of LIVE training split over 7 modules to learn beginner to intermediate dashboard design skills like:
What do former students say?
"Must-have session..."
~Ye Min
"I have applied new KoBo techniques in the work. I did not know and did not use cascade selection before joining KoBo coaching session. Now I can use this method for our endline survey. Other techniques also very useful and will apply it in my work. This session is a must have for anyone who wants to really improve their KoBo skill."
"Enthusiastic and educational"
~Grant
"It was enthusiastic and educative. I learned a lot during this coaching. Now I can import data from Kobo to Excel and use numbers easily. Also I am create cascade question easily thanks to this coaching. I will tell [my colleagues] that there are still a lot of tricks that we do not know even though we use Kobo from long time."
"I can't express my gratitude..."
~Anthony
"I can't express my gratitude to you how I have benefitted through your online videos. I'm now one of key persons at our Campus in Electronic Survey, Design and Implementation. Only that they don't know that all I have is as a result of many people including you. Thank you."
"Janna got me started in mobile data collection..."
~Mustapha
"Please let Janna and her cute baby know I appreciate their work. Their video tutorials got me started with mobile data collection."
Plus You'll be backed by a Risk-Free 30-Day Guarantee
Look, you work in the social sector and so do I. So let me be upfront with you.
Data collection is crucial. It's the foundational skill for good data analysis and decision-making. It's crucial for running good programmes. It's crucial for making an impact. It's crucial for keeping your existing funding and securing new funding.
But the capacity to actually use the software well is almost more important than the software itself. Mastering Form Design in KoboToolbox is created specifically for addressing this capacity gap, especially for remote and local teams. Your investment into the data-literacy and data-capacity of your global teams and partners is a good one.
But I want to make double-sure you know it’s a good investment. If you (or one of your team) starts the course, does the first two modules (where you'll complete an audit of your existing forms and get into the nitty-gritty of validation equations), and still don't think the course is right for you, then just email me, show me you've put in the work, and we'll refund your investment.
*Photo Credit: Image by Carina Chen from Pixabay
Frequently Asked Questions
-
How much time do I need to take the course?
You'll get access to modules and lessons on a weekly basis.
It might take you approximately 2-5 hours per week to complete the course.
There are about 8 hours of video-teaching in total, which doesn't include you actually putting those topics to use, doing the practice, doing the assignments, or implementing it into your own work. So keep that in mind as you're planning your time.
-
What is required for certification?
I'm so excited to get students certified! If a student would like a certificate at the end of the course, then there are three basic requirements:
1) You achieve a 70% passing grade on each module quiz
2) You submit the assignment for each module and receive a passing grade (but don't worry - I'll help you get there!!)
3) You participate at least once in the discussion sections in each module, either leaving your own thoughts/comments/questions or helping someone else out.
There are two deadlines in the course (because I've talked to so many students who keep telling me that deadlines help them actually ACHIEVE and get things done):
1) 16th June 2024 - all tests and assignments for Modules 1, 2, and 3 are due
2) 14th July 2024 - all tests and assignments for Modules 4, 5, and 6 are due
Let's be honest, life happens. So if you're going to run into problems with the deadlines, then email me for help. -
Do I need good internet access to the course?
Yes. The course is video-based and runs on the Thinkific Platform online, so access to internet is necessary for accessing the course materials.
If you have some staff that do not have good access to internet, there are alternative ways of delivering the course material, which can be arranged. -
What language is the course in?
The course is taught in English, however has been designed with the knowledge that almost all learners may speak English as a second language.
Written materials, captions, and video-based step-by-step tutorials are used to explain all concepts.
If you have capacity-building needs in another language, please get in touch directly at [email protected]
Multi-lingual training resources are in the plan for the future. -
What if I can't afford the course?
Depending on the size of your organisation and the availability of funding for professional development, you might not be able to afford the course.
If you work for a local or national organisation, with less than $100,000 annual turnover, you may be eligible for subsidized access, so please email [email protected]
Otherwise, if you cannot afford the full fee, please email [email protected] to explain your circumstances and a subsidy may be possible, depending on your international funding partnerships.
If you work for a larger company or international NGO or donor, and would like to subsidize access for staff of small/local organisations, social enterprises, governments, or students who have self-selected that they want and need this course, please do get in touch directly at [email protected] -
Can I pay for someone else to take this course?
Yes! In the spirit of the social sector, by all means, please enable smaller and local organisations to access this course by either subsidizing their fee or paying the full amount on their behalf. Please contact [email protected] for help in arranging this.
-
How can I pay for the course?
If you use the payment method through this website, it allows you to pay by credit card or PayPal.
Most organisations prefer to receive an invoice and pay by bank transfer. If this is your preferred method of payment, please contact directly [email protected].
If you are a team based in a field location, and a headquarters office will pay for your access, please email [email protected] and cc the relevant contact who will arrange payment by bank transfer. -
If I pay for 6-pack or 25-pack access, how will those 6 or 25 people gain access to the course?
If you want to sign up multiple participants, we have discounts for groups of 6 or more and 25 or more. Please email [email protected].
-
Can I pay by invoice?
Yes you can! If you'd like to receive an invoice for your purchase and pay by bank transfer please email [email protected].
Still "thinking about it"?
You should give Mastering Form Design in KoboToolbox a try if you or your organisation is motivated by any of the following:
Mobile data collection being used across all your teams (no more silos!)
If you're like many organisations, you probably have "pockets" of data skills - a team here or a partner there that's really great, and then a lot of other teams or partners that are struggling to keep up. If they know you're investing in them, and know they have the support they need...then what might be possible?
Look, I've worked both at field level as well as from a support-office location. I know it's hard to get consistent skills-training across multiple locations! It was one of the main reasons this course was created! If you're committed to investing not just in "beginner" skills for your teams, but also in necessary skills to actually take data to the next level...then this course is aligned in purpose with you
"Localisation" is one of your core approaches.
I'm not going to share with you the necessity or benefit of allowing more response to be driven by local teams. But from my own experience, I know it's hard to get some funding on board with localisation. One big reason is the apparent lack of accountability. Without data skills in the local team - we can't start improving that local-level accountability. Putting those skills where they're needed will continue to put power where it's most useful.
"Capacity Building" that actually matters.
I was on the phone with a guy a couple years ago, from a local organisation, and he voiced to me his frustration that the capacity building he was actually receiving was stuff he didn't really need or want. What he wanted was support for information management. That was one of my earliest conversations that solidified why Humanitarian Data Solutions needed to exist, and why training in Information Management skills was what to invest energy in. Because it's capacity building in a topic that doesn't frequently get supported with good training.
There are too many capacity building courses that don't make a difference in day-to-day operations. Mastering Form Design in KoboToolbox is practical, driven by feedback from local staff themselves from around the world, and hopefully aligns with a strong capacity building approach.
I personally cannot wait to support you and your team members and partners over the next 6 weeks in advancing your KoboToolbox skills...
Being introduced to "ODK" (what KoboToolbox is built on) many years ago literally changed my life.
I've experienced first hand what it feels like to be scrambling without enough data, and how "icky" it felt to report numbers and impact that weren't reflective of reality.
On the other hand, I've also experienced the flip side, where we had so much GOOD (and TIMELY) data, that our existing programmes were super-responsive to those we served, and donors wanted to expand their partnerships with us.
But it takes time, effort, and investment into your people to make "good data" happen. I would love it if you and your partners would join me in Mastering Form Design for KoboToolbox.
I look forward to meeting you personally inside Mastering Form Design.
ALL my best,
Janna
