Grains Research and Development Corporation (GRDC)
GRDC is one of the world's leading grains research organisations, responsible for planning, investing and overseeing research and development, delivering improvements in production, sustainability and profitability across the Australian grains industry. To achieve the GRDC's mission and vision, the Corporation is involved in numerous innovative researches with industry needs and undertakes lots of corresponding projects. The GRDC's research portfolio covers 25 leviable crops spanning temperate and tropical cereals, oilseeds and pulses, worth over $7 billion a year in farm production, alone.
Project Summarisation and Reporting System
GRDC required real-time project summaries and a business reporting system to help collect, publish and maintain information that was imperative for their business.
Problems: Like many other businesses, GRDC used to handle project data by using Microsoft Excel spreadsheet. It is convenient and handy at the beginning. Time past, the project data accumulated, data complexity increased, information sharing became a problem. And there are more problems came out.
- It becomes harder and harder to maintain these project data.
- It is hard to update or generate report as necessary from existing spreadsheet.
- There is problem to share information with other users.
- Version control is a problem.
Working with Aglign Consulting, iCAN developed a web-based interface SQL database for project management and reporting database system. The database helped GRDC utilise the research projects data. It greatly improved the quality of research data information share and utilisation within the industry. The system allows for future knowledge base extension. The major features of system are:
- Access to database anywhere anytime via web-based interface
- Strong reference management - allowing user input new reference wording and administrator to define new reference wording for system
- Templates based form design - allow administrator to change forms easily if business logic change
Conclusion: This is typical business data management case study. All businesses have their own legacy data management system either in Spreadsheet, Access Database or other smaller database system. Due to business growth, the data and data complexity increase. People find it is getting harder and harder to maintain data, share the information. This is situations a lot of people and businesses faces. Then you need to talk to a proper IT consultant and get the data migrate into new database with flexible structure and easy management system. ICAN has expertise on customised database design and development. We help you to move business forward with all precious data together.