World Energy Consumption Dashboard(TABLEAU)
World Energy Consumption
@kaggle.deremmy_world_energy_consumption_dashboardtableau
World Energy Consumption
@kaggle.deremmy_world_energy_consumption_dashboardtableau
In this work, i will be analyzing the several types of energy consumption across the globe ranging from Solar, Solar Electricity, Wind, Oil Electricity, Nuclear, Hydro, Gas, Coal and Fossil Fuel; in comparison with trends across various countries and continental regions.
I will be analyzing the top producers of various energy consumption in respect to the total population usage of each consumption alternatives as preferred by their various final consumers.
CREATE TABLE world_energy_consumption (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" DOUBLE,
"coal_prod_change_twh" DOUBLE,
"gas_prod_change_pct" DOUBLE,
"gas_prod_change_twh" DOUBLE,
"oil_prod_change_pct" DOUBLE,
"oil_prod_change_twh" DOUBLE,
"energy_cons_change_pct" DOUBLE,
"energy_cons_change_twh" DOUBLE,
"biofuel_share_elec" DOUBLE,
"biofuel_elec_per_capita" DOUBLE,
"biofuel_cons_change_pct" DOUBLE,
"biofuel_share_energy" DOUBLE,
"biofuel_cons_change_twh" DOUBLE,
"biofuel_consumption" DOUBLE,
"biofuel_cons_per_capita" DOUBLE,
"carbon_intensity_elec" DOUBLE,
"coal_share_elec" DOUBLE,
"coal_cons_change_pct" DOUBLE,
"coal_share_energy" DOUBLE,
"coal_cons_change_twh" DOUBLE,
"coal_consumption" DOUBLE,
"coal_elec_per_capita" DOUBLE,
"coal_cons_per_capita" DOUBLE,
"coal_production" DOUBLE,
"coal_prod_per_capita" DOUBLE,
"electricity_generation" DOUBLE,
"biofuel_electricity" DOUBLE,
"coal_electricity" DOUBLE,
"fossil_electricity" DOUBLE,
"gas_electricity" DOUBLE,
"hydro_electricity" DOUBLE,
"nuclear_electricity" DOUBLE,
"oil_electricity" DOUBLE,
"other_renewable_electricity" DOUBLE,
"other_renewable_exc_biofuel_electricity" DOUBLE,
"renewables_electricity" DOUBLE,
"solar_electricity" DOUBLE,
"wind_electricity" DOUBLE,
"energy_per_gdp" DOUBLE,
"energy_per_capita" DOUBLE,
"fossil_cons_change_pct" DOUBLE,
"fossil_share_energy" DOUBLE,
"fossil_cons_change_twh" DOUBLE,
"fossil_fuel_consumption" DOUBLE,
"fossil_energy_per_capita" DOUBLE,
"fossil_cons_per_capita" DOUBLE,
"fossil_share_elec" DOUBLE,
"gas_share_elec" DOUBLE,
"gas_cons_change_pct" DOUBLE,
"gas_share_energy" DOUBLE,
"gas_cons_change_twh" DOUBLE,
"gas_consumption" DOUBLE,
"gas_elec_per_capita" DOUBLE,
"gas_energy_per_capita" DOUBLE,
"gas_production" DOUBLE,
"gas_prod_per_capita" DOUBLE,
"hydro_share_elec" DOUBLE,
"hydro_cons_change_pct" DOUBLE,
"hydro_share_energy" DOUBLE,
"hydro_cons_change_twh" DOUBLE,
"hydro_consumption" DOUBLE,
"hydro_elec_per_capita" DOUBLE,
"hydro_energy_per_capita" DOUBLE,
"low_carbon_share_elec" DOUBLE,
"low_carbon_electricity" DOUBLE,
"low_carbon_elec_per_capita" DOUBLE,
"low_carbon_cons_change_pct" DOUBLE,
"low_carbon_share_energy" DOUBLE,
"low_carbon_cons_change_twh" DOUBLE,
"low_carbon_consumption" DOUBLE,
"low_carbon_energy_per_capita" DOUBLE,
"nuclear_share_elec" DOUBLE,
"nuclear_cons_change_pct" DOUBLE,
"nuclear_share_energy" DOUBLE,
"nuclear_cons_change_twh" DOUBLE,
"nuclear_consumption" DOUBLE,
"nuclear_elec_per_capita" DOUBLE,
"nuclear_energy_per_capita" DOUBLE,
"oil_share_elec" DOUBLE,
"oil_cons_change_pct" DOUBLE,
"oil_share_energy" DOUBLE,
"oil_cons_change_twh" DOUBLE,
"oil_consumption" DOUBLE,
"oil_elec_per_capita" DOUBLE,
"oil_energy_per_capita" DOUBLE,
"oil_production" DOUBLE,
"oil_prod_per_capita" DOUBLE,
"other_renewables_elec_per_capita" DOUBLE,
"other_renewables_share_elec" DOUBLE,
"other_renewables_cons_change_pct" DOUBLE,
"other_renewables_share_energy" DOUBLE,
"other_renewables_cons_change_twh" DOUBLE,
"other_renewable_consumption" DOUBLE,
"other_renewables_energy_per_capita" DOUBLE,
"per_capita_electricity" DOUBLE,
"population" DOUBLE,
"primary_energy_consumption" DOUBLE
);
Anyone who has the link will be able to view this.