You can reach me: Linkedin
Skill: SQL, Excel, Power BI,Tableau, Python, Numpy, Pandas, Web Scraping , Plotly, Data Science, Machine Learning, Scikit-learn.
PROJECTS
1. Exploratory Data Analysis and Visualization of Chicago Divvy bicycle sharing dataset (View , Blog)
- Analyzed Divvy bicycle dataset from Kaggle for 9.3 million+ trips containing 23 columns using Pandas
- Created visualizations (sunburst plots, geo heatmaps, etc.) using Seaborn , Plotly & Folium
- Discovered 99.9% of the rides are subscribers only and 5-10 min rides are the most frequent rides
2. Scraped Amazonโs Top Rated Book details using Requests & BeautifulSoup4 (View ,Blog)
- Scraped top rated books in each genre from Amazon.in website using Requests and BeautifulSoup4
- Extracted data such as book topic, book name, book url, author name, pricing, rating, star rating etc
- Stored data consisting of 1700 rows x 8 columns and into top_rated_books.csv using Pandas
3. Business 360 - Brick & mortar and e-commerce (View)
- Designed a multi-view dashboard in Power BI , gathering sales data from 2 different data sources (MySQL and Excel)
with more than 1M records and performed data modelling.
- Optimised with DAX Studio, resulting in a 5% performance boost and projected 10% revenue growth.
4. Bookshop Analysis Using Excel and Tableau ( Deskboard )
- Analyzed the dataset of 59 books containing different sheets using Pivot Tables,Vlookup in Excel
- Loaded the dataset in tableau and created a dashboard having map, bar plot, packed bubbles etc
- Discovered that the United States has the highest no. of Authors, SciFi is the most popular Book Genre
๐ฑ Iโm currently learning Data Science and Machine Learning
๐จโ๐ป All of my projects are available at Jovian Profile
๐ I regularly write articles on Medium
๐ฌ Ask me about MySQL, Python, Statistics, Web scrapping, EDA, Machine Learning
๐ซ How to reach me renuverma55@gmail.com