Global Energy ETL and Business Intelligence Dashboard

An end-to-end ETL and Business Intelligence project analyzing 24 years of global energy trends across 20 countries using Tableau Prep and Tableau Dashboards.

Overview

This project was built to analyze long-term trends in global energy production, consumption, pricing, and emissions across major economies. The workflow combines data preparation in Tableau Prep with dashboard development in Tableau to create analytics-ready datasets and interactive visualizations.

The project covers energy-related indicators such as electricity capacity, renewable vs. non-renewable energy consumption, energy price and index trends, and CO₂ emissions by source.

Objectives

• Consolidate multi-country energy datasets into a unified structure
• Clean, transform, and pivot raw data for downstream analysis
• Build interactive dashboards to support comparative energy analysis
• Surface business and policy-relevant insights on energy sustainability and market trends

Dataset

The dataset spans 24 years of energy-related data across 20 countries, including:

• Australia
• Brazil
• Canada
• China
• Denmark
• Finland
• France
• Germany
• Hungary
• India
• Italy
• Japan
• New Zealand
• Russia
• Singapore
• Spain
• Sweden
• Turkey
• United Kingdom
• United States

The project integrates multiple energy metrics related to:

• Electricity capacity
• Renewable and non-renewable energy consumption
• Energy prices and indexes
• Imports, exports, and domestic consumption
• CO₂ emissions by source

Tech Stack

• Tableau
• Tableau Prep
• ETL
• Data Visualization
• Business Intelligence
• CSV
• Excel

Project Workflow

1. Data Collection

Country-level energy datasets were collected and stored as individual CSV files.

2. Data Preparation

Using Tableau Prep, the raw files were:

• combined into a single workflow
• cleaned and standardized
• validated for consistency
• pivoted into an analysis-ready format

3. Data Output

The transformed output was exported into processed files for dashboard development.

4. Dashboard Development

Interactive dashboards were built in Tableau to analyze major global energy trends and country-level comparisons.

Dashboards Included

1. Electricity Capacity and Mix

Analyzes country-level electricity capacity trends and the evolution of energy mix over time.

2. Renewable vs. Non-Renewable Energy Consumption

Compares renewable and non-renewable energy consumption patterns across countries and years.

3. Energy Price and Index Trends

Examines price movement and energy index changes over time across major economies.

4. CO₂ Emissions Trend Dashboard

Highlights emissions trends by source and supports cross-country sustainability analysis.

Key Insights

• China showed strong growth in electricity capacity, especially in solar, wind, and combustible fuels
• The United States demonstrated more stable growth patterns with steady renewable adoption
• Renewable energy adoption patterns varied significantly across developed and emerging markets
• Energy prices and indexes reflected different macroeconomic and policy environments
• CO₂ emissions trends highlighted major differences in energy transition progress across countries

Repository Structure

.
├── assets/
│   ├── dashboard-screenshots/
│   └── architecture/
├── dashboards/
├── data/
│   ├── raw/
│   └── processed/
├── tableau-prep/
└── reports/