Exploring Energy Usage Patterns: Excel Data Analysis

README 🔍

Background:

In the era of sustainable energy management, understanding and optimizing energy demand is crucial for both environmental stewardship and efficient resource allocation. To shed light on these vital aspects, I undertook a rigorous data analysis project using Excel, focusing on AusEnergy's energy demand dataset. This dataset encompasses a wide range of factors, including weather conditions, time of year, and consumer behaviour, offering a rich source of insights into energy consumption dynamics.

Goal:

The primary objective of this project was to delve into AusEnergy's energy demand data and address three pivotal questions to drive strategic decision-making:

  1. Understanding Demand Variations Over Time: Through meticulous analysis, the project sought to unravel the temporal patterns in energy demand. This involved identifying peak demand periods, investigating year-on-year fluctuations, and pinpointing recurring seasonal trends.
  2. Identifying Extreme Demand Patterns and Circumstances: The project aimed to identify instances of extreme energy demand, particularly during critical periods influenced by weather conditions. By discerning the circumstances surrounding these peaks, the analysis contributes to the proactive management of energy supply.
  3. Analyzing the Impact of Factors on Demand: This project aimed to illuminate how external factors, such as weather variations and holidays, impact energy demand. The goal was to uncover correlations and insights that can guide energy resource planning and consumption management.

EnergyDemand

Untitled

Untitled

Untitled

Untitled

Untitled

Untitled

Untitled

Untitled

Untitled

Untitled