MINING DATA WAREHOUSE
Mining operators have been using multiple software systems to help manage their mines and supporting processes for some time. These software systems often use smart interfaces to collect data about key aspects of their operation and all typically have their own interface. The software systems can range from production tracking systems, resourcing software, pit condition software, budgeting and forecasting tools, safety systems, CMMS, and operational performance to name a few. The challenge is that these data collection systems have their own interface and the end user finds themselves without a way to access all software systems through a common platform until now. The Mine Data Warehouse Solutions solves this problem by connecting all the discrete software solutions together in a smooth common platform with advanced analytics and reporting capability.
How Does MINE DATA warehousing work?
The Mine Data Warehouse Solution connects to all site software systems, excel spreadsheets and access databases via internal ETLs to open pathways up for the real-time extraction of information. Users simply login to the Mine Data Warehouse Solution and can select any data source to draw data from. The solution contains advanced analytics. The analytics allows for comparison of data from multiple software systems over any time period. Data can be graphed, trended, manipulated in pivot tables, displayed on dashboards, and distributed via reports. Data can be pulled on demand or batched, stored, or pulled with defined calculations ready to be applied. The Mine Data Warehouse Solution provides one common platform to access all information for your site, and can feed existing reporting layers and or dashboards if required.
The Mine Data Warehouse Solution is powered by Optimum software. Optimum has an internal connection capability that allows it to connect to all known software systems, excel spreadsheets, access databases and more. This unique ability allows data from all connected systems to be access directly from within Optimum. Data can be replicated, batched, and stored for speed of recovery, or collected on a pass-through model on user demand. Connections are established managed and supported within Optimum and once established are automatic.
Through a simple windows integrated login, a user can access Optimum from fixed or mobile devices enabling access to any connected software system. With security permissions and privilege settings, access to data can be managed at a user level. Users have the ability to establish favourites, and when authorised, they can also perform basic customisation of analytics views.
With the Mine Data Warehouse Solution comes a range of analytics capability including enabling real-time interactive dashboards, with provision to display users’ specific information, or common department information on dashboards throughout the workplace. Optimum offers capability in trending, graphing, and pivot table analysis to all connected data including the ability to export directly to excel. Common uses for dashboards include department KPI’s, production dashboards, safety dashboards, planning and compliance dashboards and more.
The Mine Data Warehouse Solution drives improvement in productivity and efficiency by reducing the manual handling of data, removing errors, and fast-tracking information to decision makers when they need it. The solution enables complex analysis across multiple systems, visualisation of important data in real-time, and one central location for all information regardless of the original source.
The MPPIglobal team offer the complete approach with a full range of consulting services for the Mine Data Warehouse Solution. We conduct workshops and data mapping exercises to establish important connections. We develop and deploy the architecture required to support the solution, and we provide solution training and support allowing your company to get the most value from your data in a seamless solution deployment.
BENEFITS FOR YOUR COMPANY
- One central location and login to access all site data requirements.
- Real-time data visualisation on interactive dashboards.
- Major productivity and efficiency gains with people not conducting laborious data collection and replication.
- Fully supported solution on robust architecture.
- Analysis capability of data, grids, graphs, trends, run charts, and pareto analysis within the solution.
- Decision support data in the hands of the people who need it.