Business Challenges

• Lack of a standardized format for data integration and reporting
• Limited visibility into operational processes
• Lack of a mechanism for forecasting exports and imports of individual commodities based on historical data, market growth and economy parameters

Key Deliverables

• TCG Digital developed a set of dashboards with full drill-down and analytics capabilities. The dashboards showcased information related to export-import trends across different commodities, regions, months, and ports

Project Impact and Outcomes

After successful completion of the project, the team at the Ministry could:

• Define, design and develop processes to acquire data from different sources and load it into the enterprise data warehouse (EDW) environment
• Design an architecture capable of handling multiple and ever-expanding lists of data files sent by source systems
• Leverage public-facing dashboards that displayed trade statistics at a very granular level
• Leverage forecasting dashboards to inspect different commodities and assess growth

TCG Digital’s proprietary advanced analytics platform, tcg mcube was the solution used for all the data source connections, ETL, data storage, vizualisation, and advanced analytics