CapSource

Details
Project Title	Automated Insights for Agriculture
Project Topics	Data Management Reporting, Financial Planning & Analysis Research & Development Software Design & Development
Skills & Expertise
Project Synopsis: Challenge/Opportunity	We have a project in the ag-tech (agricultural technologies) space for assisting farmers gain more insights into price and market trends for their crops. We are particularly interested in providing insights for corn and soyabeans, on topics like corn spot prices, futures, acreage, production and stocks.
Project Synopsis: Activities/Actions Required	Some of the key activities are : a. Identifying reliable public data sources that contain relevant information for corn and soyabean farmers. This can include a combination of structured and unstructured datasets b. Setting up scraping / data ingestion and data cleaning pipelines. c. Coming up with various insights on the data d. Using Gen AI to explain the insights in an easy to understand fashion
Project Synopsis: Expected Results	By the end of the project, we would want to come up with a certain number of insights, and have at least 80% be considered relevant by a pilot group of users.

Due Date	Activities	Deliverables	Action
Thu, 08/15/24 12:00 AM UTC	Program Kickoff	No Deliverables No deliverables are required for this action item.
Location: In Person Asynchronous
Mon, 08/26/24 12:00 AM UTC	Student Pre-Kick-off Self-Assessment Form	Required Evaluation Evaluation submission is required.	View

Mon, 09/09/24 12:00 AM UTC	Deep-dive on the Organization Required Deliverable Become familiar with the company’s mission, core competencies, and current portfolio and product offerings. What is their value proposition? Who are the key stakeholders? What are some of the current challenges and needs for data management in the various industries Realogic is a part of? Become familiar with the broad organizational structure and how data are currently managed across the organization. What business decisions are the dashboard data expected to inform? How are progress and success measured and benchmarked? What are the KPI’s and how are they measured, communicated, and used in strategic planning and decision-making?	Required Deliverable Deliverable submission is required.
Guiding Questions: Become familiar with the company’s mission, core competencies, and current portfolio and product offerings. What is their value proposition? Who are the key stakeholders? What are some of the current challenges and needs for data management in the various industries Realogic is a part of? Become familiar with the broad organizational structure and how data are currently managed across the organization. What business decisions are the dashboard data expected to inform? How are progress and success measured and benchmarked? What are the KPI’s and how are they measured, communicated, and used in strategic planning and decision-making? Deliverable Instructions: Infographic overview of the organization and project objectives (internal); questions for industry mentor; Initial thoughts on the type of data analytics that could help make the organization more data-driven.
Wed, 09/18/24 12:00 AM UTC	Student Temperature Check	Required Evaluation Evaluation submission is required.	View

Mon, 10/07/24 12:00 AM UTC	Design prototype dashboard and data-stream Required Deliverable What types of dashboard designs meet the company’s needs? Can you create a draft and define the chart type you suggest the company use? What kind of relationship, composition, distribution, or comparison of data are most useful? What types of visualizations should be used in the dashboard design, and why? Which KPIs should be included, and how are these expected to promote productivity and facilitate a cost-effective working environment? Can you map the dataflow logic that takes into account all dashboard audiences? Several open-ended questions we may want to answer (this is a starting point and should be defined iteratively) Operations: How does the various work distribute between employees, both in terms of handling Crelate (recruiting activities) and in terms of using calls and messages (through RingCentral?). Ideally we could see a method to track effectiveness. Operations: Can we track the effectiveness of our recruiting process? Social Media: How are our engagement levels looking, month to month, across every criteria - likes, shares, comments - for every one of the pages? What seems to affect engagement?	Required Deliverable Deliverable submission is required.
Guiding Questions: What types of dashboard designs meet the company’s needs? Can you create a draft and define the chart type you suggest the company use? What kind of relationship, composition, distribution, or comparison of data are most useful? What types of visualizations should be used in the dashboard design, and why? Which KPIs should be included, and how are these expected to promote productivity and facilitate a cost-effective working environment? Can you map the dataflow logic that takes into account all dashboard audiences? Several open-ended questions we may want to answer (this is a starting point and should be defined iteratively) Operations: How does the various work distribute between employees, both in terms of handling Crelate (recruiting activities) and in terms of using calls and messages (through RingCentral?). Ideally we could see a method to track effectiveness. Operations: Can we track the effectiveness of our recruiting process? Social Media: How are our engagement levels looking, month to month, across every criteria - likes, shares, comments - for every one of the pages? What seems to affect engagement? Deliverable Instructions: Prototype Dashboard and Dataflow Map
Wed, 10/23/24 12:00 AM UTC	Temperature Check #2	Required Evaluation Evaluation submission is required.	View

Mon, 11/04/24 12:00 AM UTC	Define Needs & Select KPI’s Required Deliverable Who will work with the KPIs featured in the dashboard? What kind of information will they need? Do you need to present your dashboard to C-level management or other employees? What technologies are used to support the dashboard? Are you creating a dashboard for daily operational tasks or do you need to showcase the strategic performance of long-term goals? What is the best viable way to present the information? What metrics should be presented in the dashboard? How do they align to specific short-term objectives or more long-term goals? How do the metrics add value?	Required Deliverable Deliverable submission is required.
Guiding Questions: Who will work with the KPIs featured in the dashboard? What kind of information will they need? Do you need to present your dashboard to C-level management or other employees? What technologies are used to support the dashboard? Are you creating a dashboard for daily operational tasks or do you need to showcase the strategic performance of long-term goals? What is the best viable way to present the information? What metrics should be presented in the dashboard? How do they align to specific short-term objectives or more long-term goals? How do the metrics add value? Deliverable Instructions: KPI inventory, map of goal/objectives alignment, dashboard usage map or table
Fri, 12/06/24 12:00 AM UTC	Create KPI Dashboard Template & Map of Dataflow Logistics Required Deliverable What are the most effective ways for creating powerful data visualizations in the dashboard environment? How can you effectively and parsimoniously use a combination of designs, colors, etc., and create a dashboard useful to different audience segments? Can you align your visualizations with brand standards? What additional insights can be gleaned from the dashboard? What recommendations do you have for integrating the dashboard into daily operations and decision-making frameworks? Can you create user stories to illustrate how the dashboard can be used to gain business insights and inform high-quality decision-making?	Required Deliverable Deliverable submission is required.
Guiding Questions: What are the most effective ways for creating powerful data visualizations in the dashboard environment? How can you effectively and parsimoniously use a combination of designs, colors, etc., and create a dashboard useful to different audience segments? Can you align your visualizations with brand standards? What additional insights can be gleaned from the dashboard? What recommendations do you have for integrating the dashboard into daily operations and decision-making frameworks? Can you create user stories to illustrate how the dashboard can be used to gain business insights and inform high-quality decision-making? Deliverable Instructions: Dashboard, User stories, Recommendations
Fri, 12/06/24 12:00 AM UTC	Student Post-Engagement Self-Assessment Form	Required Evaluation Evaluation submission is required.	View

Fri, 12/06/24 12:00 AM UTC	Student Post-Engagement Peer Assessment Form	Required Evaluation Evaluation submission is required.	View

Guiding Questions:

What types of dashboard designs meet the company’s needs?
Can you create a draft and define the chart type you suggest the company use?
What kind of relationship, composition, distribution, or comparison of data are most useful? What types of visualizations should be used in the dashboard design, and why?
Which KPIs should be included, and how are these expected to promote productivity and facilitate a cost-effective working environment?
Can you map the dataflow logic that takes into account all dashboard audiences?

Several open-ended questions we may want to answer (this is a starting point and should be defined iteratively)

Operations: How does the various work distribute between employees, both in terms of handling Crelate (recruiting activities) and in terms of using calls and messages (through RingCentral?). Ideally we could see a method to track effectiveness.
Operations: Can we track the effectiveness of our recruiting process?
Social Media: How are our engagement levels looking, month to month, across every criteria - likes, shares, comments - for every one of the pages? What seems to affect engagement?

Deliverable Instructions:

Prototype Dashboard and Dataflow Map

Project Title: Automated Insights for Agriculture

OneByZero.ai

Project Timeline

Program Managers

Teams

ProgramsGraduate Business Analytics Consulting Program (Fall 2024)ProjectsAutomated Insights for Agriculture

Project Title: Automated Insights for Agriculture

OneByZero.ai

Project Timeline

Program Managers

Teams