Professional Excel dashboard showcasing analytical and reporting skills.
This project presents an interactive Excel dashboard analyzing power generation capacity across multiple energy sources, including Coal, Gas, Diesel, Nuclear, Renewable (RES), Hydro, and Lignite. The dashboard provides region-wise, sector-wise, state-wise, and year-wise insights, helping understand capacity distribution, growth trends, and energy mix patterns.
Built using advanced Excel features such as Pivot Tables, slicers, charts, and calculated metrics, this project demonstrates strong skills in data analysis, visualization, and business reporting.
This Excel dashboard analyzes coal power generation capacity across India, highlighting year-wise trends (2017–2024), regional distribution, and sector-wise contribution. It shows steady capacity growth with a 2.41% increase from 2023 to 2024
It shows gas capacity (2.2M) significantly higher than diesel (53.1K), with gas remaining relatively stable while diesel capacity declines sharply (-4.41% average growth). and more