Data Reporting and Visuals for Software

Closed
AgSights
Elora, Ontario, Canada
Manager of Research and Innovation
(1)
2
Preferred learners
Anywhere
Academic experience
Categories
Data analysis Market research Product or service launch Sales strategy Information technology
Skills
data visualization data analysis, story telling, visualization data analysis, programming, and design programming in java program development
Project scope
What is the main goal for this project?

Our product inventory, production and sales tracking software, bioLinks, is the area of our business that students would focus on. The goal will be to devise and implement one or multiple data visualization and reporting tools that help our current and prospective clients create more value and run their business more efficiently.

Example reports/visuals that our clients are currently interested in are:

  • A report that helps clients understand the margin of their products- this report would help clients understand what products are more profitable and help them address pricing.
  • Seasonal sale trends- how do the sales of different products vary over the year. This could allow comparisons between the client's Sales Reps ore between sales in the Current Year vs a Previous Year
  • An overview of partially filled orders to understand what products they were short on for each order- For example a client could have received an online order from a customer for 10 different products but they only have 9 of these products in inventory. Our client would like to be able to view these partially filled orders to better understand what is missing in them so that when that product is in inventory they can complete the order. This could reveal short comings where our client could understand that consistently they are short on a product.
  • Inventory levels over the past 6 months for their different products- Note the average client would sell 100 different products, but the range could be from 10 - 1000+ products per client
  • Inventory/sales projections- as clients use bioLinks more and more this data visualization system could understand their past sales and inventories to make projection reports on what their sales and inventories could be for each product.

In general, the data visualization system/tool would be customizable by the client. For example, a client could use the tool to see their total sales projections for the next 6 months today but could change this to just for the next 3 months.

About the company
2 - 10 employees
Agriculture, Technology

AgSights is a member cooperative that has been in business since 1993. We focus on bridging intelligence among producers, retailers, and consumers to bring 3 core values to agri-food businesses and their products; integrity, trust and value. AgSights designs, builds and supports innovative software solutions stemming from our customer needs.