Client success stories

With approximately 6,500 employees across six continents, Tronox’s rich diversity, unmatched vertical integration model, and unparalleled operational and technical expertise across the value chain position Tronox as the preeminent titanium dioxide producer in the world. Tronox is listed on the New York Stock Exchange under the ticker symbol TROX.

Tronox mines and processes titanium ore, zircon, and other materials and manufactures titanium dioxide pigment, specialty titanium dioxide products, and high-purity titanium chemicals. Their products add brightness and durability to paints, coatings, inks, plastics, paper, and a vast array of everyday items.

Tronox (a client of Tern Solutions) struggled to report metrics and key performance indicators to the executive team and site managers and therefore required the assistance of a Power BI specialist to build a suite of reports for Finance, Monthly Executive Team meetings, System Health Indicators, and support the Tronox Operations Information Systems (TOIS) team. The existing Power BI reports were slow, complex, and needed to be rebuilt. Automating data refreshes with data quality checks was critical to ensure data was as up-to-date and accurate as possible.

Key areas of focus:

Tern Solutions hired AGER BI as the Power BI experts to consult with Tronox and provide advice on implementing the end-to-end Microsoft solution that would equip the Executive Team and site managers with the necessary reports to monitor metrics and KPIs, assisting with cost-effective and efficient business management.

AGER BI advised creating an Azure SQL database to centralise data from multiple sources, modelled using a star schema methodology to support efficient querying within Power BI. Business rules for reporting were encoded into SQL views to reduce processing load within Power BI, improving performance. SQL Server stored procedures supported data snapshots, while ADF pipelines were used for scheduling daily refreshes and managing ETL operations.

To further modernise and scale the analytics infrastructure, AGER BI also led the migration of ADF pipelines and Azure SQL workloads to Microsoft Fabric. This migration involved:

This transformation allowed Tronox to streamline its modern data platform, benefit from Fabric’s unified architecture, and reduce dependency on fragmented tooling.

A semantic model comprising all relevant datasets was developed to serve as the foundation for Power BI reports—ensuring a single source of truth and eliminating discrepancies in KPI calculations across teams.

These reports empower Tronox to manage projects with greater precision through real-time insights and maintain strong data governance and quality standards. The overall solution has resulted in: