Data Conversion into Mysql & Visualization in Google Sheet

I successfully completed the "Global CO2 Emission Data Extraction and Conversion" project for the client. The project involved extracting large volumes of data related to global CO2 emissions from a PDF file and converting it into a structured SQL format.

Data Extraction: Extract tabular data from the PDF files containing extensive information on global CO2 emissions.

Data Cleansing: Cleanse and organize the extracted data to ensure accuracy and consistency.

SQL Database Creation: Develop a SQL database schema that accommodates the extracted data.

Data Import: Populate the SQL database with the extracted and cleaned CO2 emission data.

Quality Assurance: Verify the accuracy and completeness of the data in the SQL database.

Data Extraction: Utilized PDF extraction tools to extract tabular data from the PDF files.

Data Cleansing: Performed data cleansing processes to eliminate errors and inconsistencies in the extracted data.

Database Design: Designed a SQL database schema to accommodate data fields such as country, year, emission data, and other relevant variables.

Data Import: Imported the cleaned data into the SQL database using SQL scripts and queries.

Quality Assurance: Conducted rigorous data checks and validation to ensure data integrity and correctness.

A fully populated SQL database containing global CO2 emission data.

SQL scripts and queries used for data import.

A documentation report outlining the data extraction and conversion process.

The project was completed successfully, resulting in a structured SQL database housing comprehensive data on global CO2 emissions. This database can now be used for data analysis, reporting, and decision-making related to environmental and climate initiatives.

I am pleased to have provided a solution that meets the client's needs and enables them to harness the valuable CO2 emission data for their future endeavors.