Weather Report Forecasting & Data Analyst Project

This is a two-week project being organized by HiCounselor

Project Introduction - This project was divide into two modules.

1) Module 1 focused on the cleaning and preparation of a raw weather dataset utilizing Python scripts. This included tasks such as handling null values, removing irrelevant or duplicated data points, transforming data types, and other important sub-tasks and the use of SQL to extract meaningful insights from the now-cleaned data.

2) In Module 2, Power BI was used to create an interactive dashboard based on the cleaned dataset.

The project involved working in a team so me along side my two teammates started project. We used Python scripts to clean a weather dataset and SQL querying to extract insights. The Python scripts addressed issues such as correcting data labels, handling null values, and transforming data types. One of the toughest problems we encountered was correcting inaccurate dates, which required a lot of time and effort to develop a good solution. However, after successfully cleaning and correcting the dataset, we were able to export a clean version for further analysis.

Here is Python script:

Weather-Project-/Weather clean dataset.ipynb at main · Adityamishra2/Weather-Project-Contribute to Adityamishra2/Weather-Project- development by creating an account on GitHub.

After cleaning the weather dataset, we used SQL querying in the next phase to gain important insights from it. We used advanced concepts like aggregate functions, window functions, and virtual tables to extract useful information and answer challenging questions that were asked by the dataset.

I have attached a video in which I demonstrate SQL queries

We then created an interactive dashboard using Power BI based on the cleaned data.

The dashboard displays different measurements like temperature, pressure, rainfall, humidity, heat index, dew points, and more. These metrics cover a time period from 2022 to 2033.

Here is a pdf file that I attached for better demonstration

Weather Dashboard.pdf

You can see the dashboard in a better way with this video link - https://youtu.be/zCtgRx2KwiI

Next project