I'm Yegana and this is my portfolio.
SQL Project based on Udemy courses dataset. Data Exploration
SQL Project based on Udemy Courses Dataset. Objective: Data Cleaning
Removing currency signs.
Removing courses with null or missing data in subscribers column.
Removing courses with invalid or negative values in price column.
Converting the date into standard format.
Tableau Project based on Netflix dataset
Python Project: Password Generator
MS Excel Project
In my recent MS Excel project, I worked with a large data set to clean and transform it, and create meaningful visualizations to gain insights and support decision-making.
To begin, I used a combination of formulas and tools to clean and structure the data. I removed duplicates, corrected spelling errors. I also used the "IF" function to categorize data based on certain criteria and remove any unwanted data.
Next, I created visualizations using pivot tables to analyse the cleaned data. I used pivot tables to summarize data, calculate averages, and compare different data sets. I also created pivot charts to make the visualizations more engaging and easier to understand.
Throughout the project, I paid close attention to detail and accuracy, ensuring that the data was organized in a clear and concise manner, and the visualizations were easy to interpret. By doing so, I was able to provide meaningful insights and recommendations to stakeholders, enabling them to make informed decisions based on the data.
Overall, this MS Excel project demonstrates my ability to work with large data sets, clean and structure data using a variety of tools and formulas, and create engaging visualizations to communicate insights effectively.