/DataViz_Softec-24

Repo for Data Visualization Competition: Analyzing global carbon emissions with Python, SQL, and Power BI

Primary LanguageJupyter Notebook

Data Visualization Competition: Carbon Emissions Analysis - Softec'24

This repository contains the submission for the Data Visualization Competition focused on analyzing carbon emissions data. The competition involves two rounds: the first round involves data loading, preparation, ETL process, feature engineering, and table reshaping, while the second round involves creating interactive dashboards based on the features designed in round one.

Tools Used

Microsoft SQL Server Python Power BI Visual Studio SQL Server Integration Services (SSIS)

Folder Structure

  • ETL: Contains scripts and files related to the Extract, Transform, Load (ETL) process for Round 1.
  • Visualization: Includes .pbix files for generating visualizations and charts based on the analyzed data.
  • python_script: Contains Python scripts for data processing tasks.
  • DB Creation.sql: SQL script for creating database tables and structures.
  • Global_Carbon_Budget.xlsx: Excel file with data related to the global carbon budget.
  • National_Fossil_Carbon_Emissions.xlsx: Excel file with data on national fossil carbon emissions.
  • README.md: This file provides an overview of the project and its structure.
  • Regions.xlsx: Excel file with data on different regions.
  • readme.docx: Word document with additional documentation or instructions.

Installation

  1. Clone the repository:
    git clone https://github.com/asadali27232/DatViz_Softec-24.git
    

Screenshots

Alt Text 1 Alt Text 1 Alt Text 1 Alt Text 1 Alt Text 1 Alt Text 1

Credits

This project was developed by Asad Ali in participation with Muhammad Haroom Shahzad for the Data Visualization Competition under the team name Visualizers.

📫 Let's Connect

WhatsApp Email LinkedIn Facebook Twitter Personal Website