Date: Saturday, June 21, 2025
Venue: Kaizen Laboratory, IE-ME Building, Magsaysay Avenue , University of the Philippines, Diliman, Q.C.
Unlock the power of Excel in our comprehensive workshop, Demystifying Predictive and Prescriptive Analytics Algorithms Using Excel.
Dive deep into advanced Excel functionalities like formulas, dashboards, data tables, Goal Seek, and Solver.
Master predictive analytics by classifying spam with Naïve Bayes, developing movie recommender systems, conducting market basket analysis, and optimizing store locations using cluster analysis.
Explore prescriptive analytics through basic optimization examples and a real-world case study on facilities location in the Philippines.
How You Will Benefit
– Gain practical skills to transform complex data into actionable insights, enhancing your decision-making and analytical capabilities.
Who Should Attend
– Consultants, Business analysts, Statisticians, Data Scientists, Operations Research Analysts, Educators, Analytics Practitioners, Managers, and other
What You Will Learn
– Learn how to solve predictive and prescriptive analytics problems solely in Excel.
Pre-requisites
– Intermediate knowledge of Excel
Why learn Predictive and Prescriptive Analytics in Excel?
Intuitive Interface
Excel’s intuitive interface allows users to implement machine learning and optimization techniques with straightforward formulas and built-in tools like Solver, reducing the learning curve.
Deeper learning
Machine learning algorithms are often referred to as “black boxes,” but solving them in Excel can demystify their inner workings.
Registration Fees*
Early Bird (on or before May 31, 2025)
ORSP Member click here
Non Member click here
Regular (June 1 to 11, 2025)
Member click here
Non Member click here
Fee includes materials, use of computer lab, am/pm snacks and lunch
Payment Details :
Operations Research Society of the Philippines, Inc. (do not abbreviate).
Banco de Oro Savings Account Number: 00151 0028 666
Gcash 0917 863 4196 (Marie Shella Mariscal)
Course Outline
Objective: Empower participants with the knowledge and skills to effectively utilize Excel for predictive and prescriptive analytics, transforming data into valuable insights for better decision-making.
Excel Functionalities
– Advanced Formulas
– Dashboards
– Data Tables
– Goal Seek and Excel Solver
Predictive Analytics
– Classifying spam using Naïve Bayes algorithm
– Developing a movie recommender system using Collaborative Filtering
– Conducting market basket analysis for a grocery store.
– Optimizing store location using cluster analysis.
Prescriptive Analytics
– Basic optimization examples
– Philippines facilities location case study
To register, please visit www.orsp.org.ph or contact secretariat @ secretariat@orsp.org.ph or viber number +639278775219