Understanding formulas and Pivot Tables for Calculated measures in ActivityInfo
Interested in more webinars and material on M&E? Sign up for our newsletter!
About the webinar
The “Pivot tables and Calculated measures for data analysis with ActivityInfo” webinars is a series of three sessions addressed to new and older users of ActivityInfo who wish to get introduced to the built in analysis tools of the platform or dive into more advanced features such as the calculated measures.
The first session is an introductory session ideal for beginners who wish to get acquainted with pivot tables and formulas in ActivityInfo. It is highly recommended to attend this session, if you wish to continue to the second part where we will be discussing advanced data analysis with calculated measures in pivot tables. The third and final session will give you the opportunity to raise questions to our team regarding what you have learnt.
In this foundational session, participants dive into the fundamental concepts of data analysis, focusing on formulas and pivot tables. By mastering these, you gain a strong foundation for understanding and leveraging calculated measures to derive valuable insights from your data.
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
View the presentation slides of the Webinar.
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
Is this Webinar for me?
- Do you wish to get started with data analysis in ActivityInfo?
- Would you like to expand your knowledge on ActivityInfo and work on more advanced analysis using formulas?
- Do you want to take your data analysis and reporting skills to the next level using the tools available in the platform?
Then, watch our Webinar!
About the trainers
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.