Pranav Nagawade

Data Science Portfolio

Skilled in Python, Excel, SQL, PowerBI, PowerBI DAX, NumPy, Pandas, Matplotlib, Seaborn, Core Statistics

@PranavNagawade

Project 1

Business 360 - Brick & motor and e-commerce PowerBI Dashboard

Built a Power BI dashboard to analyze AtliQ hardware's sales trends over the globe by gathering data from Excel/CSV files and a SQL database, creating a data model and visualizations in Power BI, and optimizing the report with DAX studio. The dashboard helped AtliQ hardware understand different departments' sales trends and make data-driven decisions.

Project 2

Hotel Reservation Cancellation Analysis Using Python

Conducted in-depth analysis of cancellation rates at City Hotel and Resort Hotel to identify key trends and patterns impacting revenue generation. Utilized data manipulation and visualization tools to provide comprehensive insights into cancellation-related issues. Offered strategic business advice to optimize efficiency and revenue by addressing cancellation rate challenges, demonstrating a commitment to data-driven decision-making and problem-solving.