MIP Logo

Coal and Metal Production Dashboard

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here

My Power BI dashboard is designed to provide a comprehensive view of total production across coal, minerals, and commodities, allowing users to analyze trends, identify opportunities, and assess market dynamics.

At the top of the dashboard, users will find three interactive buttons:
Total Production of Coal, Total Production of Minerals, and Total Production of Commodities.
These buttons enable quick and seamless navigation, dynamically changing the four primary charts displayed below it.

The first chart illustrates Total Production by Year, showcasing trends over time and helping users identify peaks and troughs in production. Next, the Total Production by Countries chart provides a geographic perspective, highlighting which countries are leading in production and where opportunities for growth may exist.

In addition to these time and geographic analyses, the dashboard includes a chart for Total Production by Facilities, offering insights into production capacities at various facilities, and a chart for Total Production by Type of Facilities, which helps users understand the distribution of production across different facility types.

To deepen the analysis, three following bar charts address some questions:

1.How Many Facilities Produce Each Primary Commodity Type?

2.What Is the Total Production Volume for Each Coal Material?

3.Is There Any Surplus or Deficit in the Production of Coal Materials?

These questions encourage users to delve into the specifics of coal production, highlighting not only the facilities involved but also the volumes produced and whether production meets market demand. For instance, our analysis of surplus and deficit provides an opportunity to explore production efficiencies and align strategies to market needs.

Share this post