Case Studies

Case Studies

Experience has taught us a many things about data management and the typical problems that many companies face when managing their most valuable asset.

  • No consistency and no data flow control mechanisms
  • Complicated data entry systems
  • Data fragmented and in many different formats
  • Remote project areas
  • High staff turn-over compromising the chain of knowledge over the span of the project development

Our solution delivery packages have been designed specifically with these problems in mind and the driving force behind any data management system is that it delivers Always Accurate Data.

The Problem

  1. Costly data management overheads during their expansion from Explorer to Producer
  2. MS Excel based logging system with multiple versions of logging templates
  3. No consistency and no data flow control mechanisms
  4. Fragmented and disconnected data systems meant working with inferior datasets
  5. Geology Managers wasting time compiling, checking and managing data flow control and correcting field data logging errors

The Solution

  • Database Solution: Expedio hosting with client access to system. See Solution Delivery - "Bundle 2"
  • OCRIS Operational Unit (OOU): Expedio implemented a centralised fully hosted OCRIS Operational Unit
  • OCRIS Mobile: Anywhere data logging solution customised with the client’s business rules, validation and formulas, delivered quickly and changes easily applied
  • OCRIS Toolbox: Regular updates using accurate datasets are always available on short notice. Using OCRIS Toolbox site users can now access a variety of summary activity reports, QC analysis tools and strip log functionality to browse, report and export their data on demand
  • OCRIS Logix: A stringent data management process from field logging to data management with a full, demonstrable audit trail
  • Expedio Hosting: Expedio hosts one centralised database and manages all of company A’s project data

The Outcome

  • Scalable Solution : By implementing the OOU the Expedio’s scalable solution will easily grow with the expansion of the project.
  • Data Capture: Field logging process delivering a clean, controlled and rapid flow of data with errors trapped and corrected at the point of data capture by the user.
  • Data Management: Freeing up time for managers to do what they do best, plan, model, interpret and manage their project development, while outsourcing the skills, hosting and IT infrastructure overheads to the experts at Expedio.
  • Support: 24 hour support ensures the client has peace of mind knowing a solution to any data management challenges can be delivered rapidly avoiding any major production issues.

The Problem

  1. Complicated data entry systems
  2. Non-standard assay management system
  3. Geologist and field staff were logging on paper in the pit
  4. Slow turnaround for grade control data users from capture to reconciliation stages
  5. No consistency and no data flow control mechanisms
  6. Non-compliance: A culture of database schema changes to force non-valid data into the database
  7. Non-compliance: Allowing non-valid data into the database compromised the veracity of the dataset and compounded several major issues within the database
  8. Language and cultural barrier to locate the source of their data issues
  9. Several generations of data consultancies had tried and failed to solve large scale issues in the importing, validating, exporting and reporting of the data

The Solution

  • Database solution: A self-managed database solution with support from Expedio. See Solution Delivery - "Bundle 4"
  • OCRIS Mobile: Expedio designed and implemented a robust data capture solution customised with the client’s business rules, validation and formulas. Changes are delivered quickly and easily applied
  • OCRIS Logix: A stringent data management process from field logging to data management with a full, demonstrable audit trail
  • OCRIS Model: Expedio introduced a standardised and secure data management system using Expedio’s own schema design and software configuration optimised for GBIS / Geobank Increased database security controls allowed the company to regain and maintain the veracity of their database
  • Global Experience: Years of experience working around the world meant Expedio was able to address cultural and language barriers by building trust with the onsite staff and deliver on our proposed solutions
  • Custom Validation: Customised rules and views ensured non-valid data would be unable to corrupt the new schema. With these rules in place Expedio was able to validate and audit their entire dataset and correct many historic data issues
  • GBIS/Geobank Optimisation: A decade of experience in optimising GBIS/Geobank systems allowed Expedio to get the most out of the client’s current data managementsoftware

The Outcome

  • Data Capture : Field logging process delivering a clean, controlled and rapid flow of data with errors trapped and corrected at the point of capture by the user.
  • Export Data on Demand: Users can generate ready to use data on demand in standard formats for each production department in addition to automated mailouts of QC data results.
  • Dataset Control: Validation rules, views and security permissions.
  • Data Management: By outsourcing the development and support to Expedio, onsite staff can now focus on the day to day data management. The data managers can now provide clean, valid and effective data to the Geologist, Engineers, Metallurgists and Surveyors onsite.

The Problem

  1. Difficulties with data flow and data management
  2. Data was fragmented and in many different formats
  3. A non-observational style of geological logging was causing delays and hindering data flow
  4. 3 month delays to use collected data lead to frustrated geologists and management

The Solution

  • Self Managed Database: Expedio introduced a self-managed database solution and provide support. See Solution Delivery - "Bundle 4"
  • Data Logging: Expedio implemented a data logging solution that could be used offline with a standardised interface that adjusted the logging style of the geologists to an observational technique. This technique reduced logging time as geologists were no longer adjusting logs to fit standard geological blocks
  • OCRIS Logix: A stringent data management process that streamlined the workflow of uploading data from the field logger to the production database
  • OCRIS Model: Expedio’s single interface data management solution integrated with our anywhere logging software centralised and standardised all company data
  • OCRIS Operational Unit (OOU): Expedio implemented a centralised fully hosted OCRIS Operational Unit
  • Data Management: Expedio removed the frustration of waiting months for valid usable data. Data is now usable within hours of it being collected in the field. This allowed for the collection of analytics on production which identified inefficiencies that could be addressed. Centralising and standardising the data provided Logging Geologist, Geology Supervisor, Plant Operators, Plant Supervisors, Diamond Pickers, Resource Modellers and Mining Engineers access to the most current data set as required
  • GBIS/Geobank Optimisation: A decade of experience in optimising GBIS/Geobank systems allowed Expedio to get the most out of the client’s current data managementsoftware

The Outcome

  • Support : OCRIS Logix was delivered to the client onsite, with remote support by Expedio.
  • Robust System: The self-managed system has required little to no maintenance since its implementation over 5 years ago.
  • Validated Data: A single source of validated data ensured all departments are using the latest reliable and accurate data sets.
  • Reporting: Data is now available to all departments within hours of collection, management can now act decisively regarding their resource and production in real time.

The Problem

  1. Remote project areas
  2. Limited communications was providing major issue with data transfer from site to office
  3. Limited IT infrastructure onsite
  4. Personnel with limited data management knowledge and experience
  5. A non-centralised database onsite was causing incomplete datasets
  6. MS Excel based logging system with multiple versions of logging templates causing delays in compilation, validation and loading to the database resulting in recent fieldwork being unavailable on short demand to the data stakeholders
  7. No data flow control mechanism

The Solution

  • Database Solution: Expedio hosting with routine extracts and reports to client. See Solution Delivery - "Bundle 1"
  • OCRIS Mobile: Expedio implemented a robust data capture solution customised with the client’s business rules, validation and formulas. Implementation and training took place onsite
  • Expedio hosted: Expedio hosts one centralised database and manages all of company D’s project data. Hosting the database in Perth at Expedio eliminated the need for Company D to upgrade the IT infrastructure onsite
  • Updates & Reporting: Expedio now provides regular updates through small data packages in the company's required format to all departments onsite ensuring the most current and accurate datasets are always available

The Outcome

  • Data Capture : Field logging process delivering a clean, controlled and rapid flow of data with errors trapped and corrected at the point of capture by the user. The system has resulted in short turnaround times from the point of data collection to clean accurate datasets being made available to all stakeholders providing time savings and cost efficiencies for the client.
  • Hosting: A hosted database solution in conjunction with OCRIS Logix and OCRIS Mobile, delivers accurate and valid data to head office and remote locations. Having one centralised database allows Expedio to provide delivery of accurate summary statistics for exploration giving Company D the tools to accurately budget current and future exploration targets. Required skills, software and IT infrastructure overheads have been outsourced to Expedio.

The Problem

  1. High staff turn-over compromising the chain of knowledge over the span of the project development
  2. Full time data management role not required
  3. No consistency and no data flow control mechanisms
  4. Difficulties with data capture and data management
  5. Data was fragmented and in many different formats

The Solution

  • Database Solution: Expedio hosting with client access to system. See Solution Delivery - "Bundle 2"
  • OCRIS Mobile: Expedio implemented OCRIS Mobile, anywhere data logging solution, customised with the client’s business rules, validation and formulas, with any changes delivered quickly and easily
  • OCRIS Logix: A stringent data management processes with rigorous principles that produces world’s best data management practices from field logging to compliance reporting with a full, demonstrable audit trail
  • OCRIS Model: Expedio’s own database schema and security allowed the company to maintain control of the database. Custom validation rules and views ensured non valid data would be unable to corrupt the data set.
  • Expedio hosted: Expedio hosts the client database and provides a mirror copy to the company’s corporate and site offices with full interrogation and reporting tools for the users
  • Updates & Reporting: Users have access to the digital data system, with a variety of summary activity reports, QC analysis tools and strip log functionality to browse, report and export their data on demand

The Outcome

  • Data Capture : Field logging process delivering a clean, controlled and rapid flow of data with errors trapped and corrected at the point of capture by the user. The system has resulted in short turnaround times from the point of data collection to clean accurate datasets being made available to all stakeholders providing time savings and cost efficiencies for the client.
  • Hosting: A hosted database solution in conjunction with OCRIS Logix and OCRIS Mobile, delivers accurate and valid data to head office and remote locations. Having one centralised database allows Expedio to provide delivery of accurate summary statistics for exploration giving Company D the tools to accurately budget current and future exploration targets. Required skills, software and IT infrastructure overheads have been outsourced to Expedio.
  • Reliability: Expedio have performed the data management and hosting role for more than 12 years spanning a period where everything about this project had changed hands, from the owners and management to the geologists and field assistants. Expedio have remained the data custodians, consistently delivered clean and accurate data and implemented training for each new staff member as required.

The Problem

  1. MS Excel based logging system was struggling to keep data consistent with the multiple versions of logging templates
  2. No data flow control mechanisms
  3. Fragmented data that was stored in many different formats including CSV, Access, Mapinfo and AcQuire
  4. A non-centralised database was causing incomplete datasets to be used in resource estimation reporting. Some lab results were not being used as they were only located during Expedio’s migration process
  5. Historic data from several previous project owners had created unconformity in the dataset. Local grid conversions have been mismanaged and not correctly implemented to the collar coordinate data
  6. Lack of in house skills and IT infrastructure

The Solution

  • Database Solution: Expedio hosting with routine extracts and reports to client. See Solution Delivery - "Bundle 1"
  • OCRIS Operational Unit (OOU): Expedio implemented a centralised fully hosted OCRIS Operational Unit
  • OCRIS Mobile: Anywhere data logging solution customised with the client’s business rules, validation and formulas
  • OCRIS Toolbox: Consolidated all data into one database. Using OCRIS Toolbox users can now access a variety of summary activity reports, QC analysis tools and strip log functionality to browse, report and export their data on demand
  • OCRIS Logix: A stringent data management processes with rigorous principles that produces world’s best data management practices from field logging to compliance reporting with a full, demonstrable audit trail
  • Expedio hosted: Expedio hosts one centralised database and manages all of their project data

The Outcome

  • Scalable Solution : By implementing the OOU the Expedio’s scalable solution will easily grow with the global expansion of the company.
  • Data Capture: Field logging process delivering a clean, controlled and rapid flow of data with errors trapped and corrected at the point of data capture by the user.
  • Data Management: Regular updates using accurate datasets are always available on short notice, freeing up time for managers to do what they do best, plan, model, interpret and manage their project development, while outsourcing the skills, hosting and IT infrastructure overheads to the experts at Expedio.
  • Support: 24 hour support ensures the client has peace of mind knowing a solution to any data management challenges can be delivered rapidly avoiding any major issues.

The OCRIS Operational Unit helps you manage your data.