🎯 Business Objective:

To monitor and optimize fuel consumption for generators by tracking usage in liters and tons, identifying periods of zero consumption, and analyzing peak demand periods for better resource planning.The goal is to support operational planning, cost reduction, and downtime analysis. 

Tools Used:

Power BI, Power Query, DAX. 

❓ Key Business Questions Asked

• What is the total and average fuel consumption per day, month, quarter, and year?

• Are there days with no consumption (i.e., zero-operation days), and how often do they occur?

• Which months or quarters show above-average consumption, and when is fuel demand highest?

• What is the most fuel-consuming day during the tracked period?

📊 Main KPIs Tracked:

•  Total Fuel Consumption (Liters & Tons)

•  Average Daily Consumption

•  Number of Days with Zero Consumption

•  % of Zero-Consumption Days

•  Most Consumptive Day (Peak Usage)

•  Consumption Trend vs. Average

•  Highest zero-consumption day

•  Seasonal and annual usage trends

Steps Taken for Analysis

1. Data Cleaning

   • Checked for missing or incorrect fuel values

   • Unified units (liters and tons)

   • Added date hierarchies for yearly, quarterly, and monthly grouping

2. KPI Setup

   • Calculated total fuel in liters and tons

   • Computed average daily fuel consumption

   • Flagged days with 0 consumption

   • Counted zero-consumption days and their percentages across all periods

3. Trend Comparison

   • Calculated average benchmarks

   • Compared actual usage against averages for each month and quarter

   • Highlighted periods of excessive or reduced usage

4. Peak Day Detection

   • Extracted the day with the highest fuel consumption

   • Extracted the day with the most extended zero-consumption

✅ Key Takeaways

• Certain quarters and months consistently exceeded the average consumption, requiring proactive fuel supply planning

• Significant number of zero-consumption days detected — indicating either planned downtime, data gaps, or operational inefficiencies

• Peak fuel usage days provide insight into critical demand events

• Root cause analysis allowed for identifying high-usage patterns by specific time segments

• The dashboard provides a strategic tool for fuel cost control and generator efficiency monitoring

🎯 Business Impact:

• Enables informed decision-making on fuel supply and usage

•  Detects operational inactivity or unusual patterns

•  Supports proactive planning during high-demand periods

•  Helps reduce waste, cost, and unplanned generator downtime