Teck: case study
Teck is one of Canada’s leading mining companies, focused on providing products essential to building a better quality of life for people around the globe. Teck is also the parent company of Neptune Terminals, a significant exporter of Canadian natural resources, namely potash from Saskatchewan and steelmaking coal from the western provinces and has over 50 years in the supply chain industry. Neptune can handle over 23.5 million tonnes of bulk products a year.
Teck has been operating safely and responsibly as a leader among the mining companies with operations and projects in Canada, the United States, Chile and Peru. The company is on a journey of transitioning with digital solutions that support its emerging business processes. Neptune Terminals manages all the export and transportation processes for Teck and Canpotex, one of the world’s largest potash exporters. The technology leadership sought ways to digitally streamline Neptune Terminals’ systems and associated business processes to increase overall efficiency and reduce costs.
The company’s legacy system took too long and didn’t enable its employees to work efficiently. Business analysts processed everything manually using Excel files and other internal applications. They were looking for a solution to help them see the whole data in one chart. Running analyses was tedious, with reports being processed daily, weekly and monthly.
While Excel sheets gave them many advantages but had its own bottlenecks. Our team’s first step was to run an analysis and understand their existing system and ongoing requirements. To maximize the visibility on the operations side, they wanted a really interactive dashboard that could pull up four different types of reports daily, weekly and monthly. We proposed an operational analytics dashboard to improve operational process efficiencies leveraging Microsoft Power BI.
Our team analyzed the Customer’s needs and designed the architecture of the BI solution that would allow the integration of disparate data sources and transform them into actionable reports. Extracting the latest version of data and processing it was a little complex. Since they were using Excel sheets and an internal application to track the latest data version, it took much work for the team to meet the gaps in the report. Our team took the additional responsibility of running queries, getting the latest data version, and finally meeting the report’s gaps.
For operations managers to get the ability to conduct near real-time analytics, we employed the Power BI Desktop application, where calculations were made on the baseline and delivered four different types of reports to cater to the following needs:
The reports gave the Customer better visibility in the operational process, especially while loading and unloading the vessels. The dashboards were improving overall efficiency. The Customer got an overview of costs and was able to use this information for budgeting and reducing expenses. Users could view their KPIs over different periods – daily, weekly, and monthly against the baseline and drill deeper into the reports to identify the efficiencies and inefficiencies. Incident reporting helped them take necessary safety measures and create a safer working environment.
With Power BI, data governance became effortless. Data analysis and collaboration across departments were seamless without worrying about version control.