Understanding formulas and Pivot Tables for Calculated measures in ActivityInfo

About the Webinar

This is the first session of the series “Pivot tables and Calculated measures for data analysis with ActivityInfo”. It is a one-hour session ideal for professionals who who to get introduced to the built in analysis tools of the ActivityInfo platform and dive into more advanced data analysis features such as the calculated measures.

In summary, we explore:

• Designing a pivot table using ActivityInfo
• Using formulas in ActivityInfo
• Calculated measures in ActivityInfo
• Adding a filter to a pivot table

There will also be a Q&A session, so make sure to bring your questions!

In order to best prepare for this session, we recommend studying the following documentation:

• How to create a pivot table using ActivityInfo
• Using formulas in ActivityInfo
• Tutorial: Add a calculated measure
• Adding a filter to a pivot table

List of sessions

Evaluation in humanitarian assistance:

1. Understanding formulas and Pivot Tables for Calculated measures in ActivityInfo (July 26th)
2. Discover the power of Calculated measures in ActivityInfo (August 2nd)
3. Unleashing data insights - Office hour session on Calculated measures in ActivityInfo (August 9th)

Is this Webinar for me?

• Do you wish to get started with data analysis in ActivityInfo and expand your knowledge on more advanced analysis using formulas?

Then, join our webinar!

About the Trainers and ActivityInfo

Mr. Jeric Kison earned his Bachelor's Degree from York University in Canada and his MBA from the University of Oxford in the United Kingdom. He has worked with NGOs and governments across four continents on strategy and evaluation for nine years. Before joining ActivityInfo he worked as a Monitoring & Evaluation Officer at Pilipinas Shell Foundation, Inc., where he led a project to develop an organizational M&E System which included the roll-out of ActivityInfo as the organization’s new information management system. Today, Jeric is working as a Customer Success Director in the ActivityInfo team bringing together his experience on the ground and passion for data to help our customers achieve success with ActivityInfo.

Victoria Manya has a diverse background and extensive expertise in data-driven impact, project evaluation, and organizational learning. She holds a Master's degree in local development strategies from Erasmus University in the Netherlands and is currently pursuing a Ph.D. at the African Studies Center at Leiden University. With over ten years of experience, Victoria has collaborated with NGOs, law firms, SaaS companies, tech-enabled startups, higher institutions, and governments across three continents, specializing in research, policy, strategy, knowledge valorization, evaluation, customer education, and learning for development. Her previous roles as a knowledge valorization manager at the INCLUDE platform and as an Organizational Learning Advisor at Sthrive B.V. involved delivering high- quality M&E reports, trainings, ensuring practical knowledge management, and moderating learning platforms, respectively. Today, as a Customer Education Specialist at ActivityInfo, Victoria leverages her experience and understanding of data leverage to assist customers in successfully deploying ActivityInfo.

ActivityInfo is an information management platform perfect for monitoring and evaluation, humanitarian coordination and case management. For more than a decade, the ActivityInfo team has been supporting humanitarian operations and development programmes worldwide catering for emerging needs for data collection and analysis. UN agencies, INGOS and NGOs use the platform to centralize and standardize data collection, display the impact of their activities while maintaining complete control on data access and changes. Originally developed for UNICEF’s emergency program in eastern DRC, ActivityInfo is a service provided by BeDataDriven a company based in The Hague, Netherlands.