Harsh Koli

Leveraged analytical skills using MySQL for data retrieval and manipulation. Utilized Jupyter Notebooks for data exploration and visualization. Proficient in Power BI for creating interactive dashboards and reports, effectively communicating insights to stakeholders.

MARATHON EDA-Python(Jupyter)  

• This dataset contains two centuries of marathon data.Using pandas for data cleaning, after which there were two data sets formed where the distance was either 50km or 50mi and the year in which the marathon they ran was 2020, the two datasets formed were of two countries i.e. India and USA.
• Using matplotlib and seaborn graphs were plotted such as count of which races were more between 50 km and 50miles and also, the proportion of male female in that race.

HOTEL BOOKINGS DATA CLEANING AND EDA-Python(Jupyter)

• The analysis of hotel bookings cancellations as well as other factors that have no bearing on their business and yearly revenue Generation are the main topics of this Project.
• Aggregated and visualized the data by using pandas, matplotlib and seaborn.

NASHVILLE HOUSING DATA CLEANING – MySQL

• Various data cleaning tasks standardizing date formats, populating missing data, splitting addresses, standardizing values, Removing duplicates and dropping unused columns.

HR ANALYTICS DASHBOARD–Power BI

• Created a dashboard with Power Bi that helps to know the attrition by Age, Education, Salary slab, Job role, Years at Company and also by the gender.
• Performed data cleaning in power query and used DAX to create new formulas.

• SQL -MySQL for Data Analytics and Business Intelligence.
• Microsoft Power BI Desktop for Business Intelligence