Dataset research report
Energy Transition Mix research report
A reproducible data report with schema notes, generated chart evidence, suggested follow-up questions, and export-ready Helix queries.
Executive Summary
Regional renewable generation and grid transition dataset for testing time series, area charts, grouped bars, heatmaps, and emissions comparisons.
Research Context
Energy Transition Mix: 40 rows by 9 columns. These exploratory charts are generated automatically from the data - open the dataset in Helix to ask your own questions.
Data Profile
Chart Evidence
These views are generated from the dataset profile. Each chart is paired with a Helix query so it can be opened, adjusted, and exported.
Correlation of numeric columns
Pearson correlation between numeric columns.
Open and export this chartFollow-Up Queries
- line chart of renewable_share_pct over year by region
- stacked area chart of solar_twh wind_twh and hydro_twh over year
- grouped bar comparing battery_storage_gwh by region and year
- scatter renewable_share_pct vs grid_emissions_mtco2 coloured by region
- correlation heatmap of renewable generation demand storage and emissions
- top regions by total solar_twh in 2025
Preview Rows
| # | yearinteger | regiontext | solar_twhfloat | wind_twhfloat | hydro_twhfloat | battery_storage_gwhfloat | electricity_demand_twhfloat | grid_emissions_mtco2float |
|---|---|---|---|---|---|---|---|---|
| 1 | 2016 | North America | 32 | 62 | 110 | 4 | 420 | 354.4 |
| 2 | 2016 | Europe | 43.5 | 67.2 | 133 | 5.5 | 516 | 417.3 |
| 3 | 2016 | Asia Pacific | 52.7 | 70.3 | 151.5 | 7 | 612 | 480.2 |
| 4 | 2016 | Latin America | 59.4 | 75 | 164.8 | 8.5 | 708 | 543.1 |
| 5 | 2017 | North America | 40.7 | 65.2 | 112.9 | 4 | 442 | 341.4 |
| 6 | 2017 | Europe | 50.7 | 69 | 134 | 5.5 | 540.5 | 402.6 |
Data Dictionary
- year date Calendar year for the observation
- region categorical Energy market region
- solar_twh float Solar generation in terawatt-hours
- wind_twh float Wind generation in terawatt-hours
- hydro_twh float Hydro generation in terawatt-hours
- battery_storage_gwh float Grid-scale battery storage in gigawatt-hours
- electricity_demand_twh float Regional electricity demand in terawatt-hours
- grid_emissions_mtco2 float Grid emissions in million metric tons CO2
- renewable_share_pct float Renewable generation share of demand
Method And Limits
- Load the catalog entry and preview rows from the processed dataset file.
- Infer numeric, categorical, time, and location fields from real columns.
- Generate a small set of defensive Plotly chart specifications from that profile.
- Expose each chart idea as a query link so the report can be rerun or exported in Helix.
This report is intentionally reproducible. It uses the local catalog metadata and generated chart specifications rather than claiming external conclusions beyond the dataset.