Portfolio - Harsh Sawant

Harsh Sawant

Data Aspirant

Resume

1

Excel Project

2

PowerBI Projects

About Me

Welcome to my portfolio website! 📊 As an aspiring data analyst, I bring a passion for unraveling the stories hidden within vast datasets using the powerful trio of SQL, Python, and Excel, with a touch of visualization magic through Power BI. Armed with a Bachelor's degree in Artificial Intelligence and Data Science, my journey is defined by a relentless pursuit of understanding and leveraging data's potential.While my formal career journey is in its nascent stages, my portfolio stands as a testament to my prowess. Dive into a showcase of meticulously executed business projects that transcend the theoretical realm, offering a glimpse into my analytical finesse. Every project is a testament to my commitment to excellence, blending theoretical knowledge with a hands-on approach.I thrive on transforming raw data into actionable insights, and my dedication to continuous learning ensures I stay at the forefront of industry trends.

Key Skills

Python

SQL

PowerBI

Tableau

My Projects

Excel: Dynamic Financial Insights

Business 360 - E-cmomerce Sales Analytics

Hotel Chain Business Analysis

Awards & Certificate

IBM Professional Data Analyst

AWS Hands on Cloud Computing

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/harsh-sawant-0ba557222/

Call Me

+91 9172590972

GitHub

https://github.com/harshsawant1121

Excel Project

Excel: Dynamic Financial Insights

Created two reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer performance report : Provides net sales performance of each customer across years

Quarter wise report : Provides Quarter wise Net sales , COGS , Gross Margin and GM% according to various regions.

Project Details

In this project I created sales report using Excel Pivot tables and Power Query which will allow organization to identify potential business expansions opportunities in various countries. Performed ETL and Data modelling using Power Query. Also did data cleaning and Data Normalization . Studied various sales terms like gross margin , net sales , COGS . Also created P & L report for the organization by adding month wise as well as quarter wise data analysis.

PowerBI Project

Business 360 - E-cmomerce Sales Analytics

"Built global sales analysis for HS Technologies using Power BI, optimizing performance by 5%. Projected 10% revenue increase and 20% cut in data-related expenses. Explore the impact on my portfolio."

View Project
Engagement

View Project
on GitHUB

🖌This is homepage which consists of various views like info , Finance , Sales , Marketing , Supply chain , Executive view and Support Page.

💰 Finance View: Delve into P&L Statement, pinpoint top/bottom products/customers by Net Sales, track Net Sales performance over time,

Project Details

Revolutionizing Global Sales Analysis: Overhauling a multi-functional Power BI dashboard, I spearheaded the transformation of HS Technologies' sales trend analysis across the global market. Managing an extensive dataset exceeding 40 lakh rows, I meticulously designed and implemented an advanced data model and visualizations in PowerBI.The impact of this project extends beyond enhanced analytics. Through the implementation of strategic improvements, our efforts are projected to result in a remarkable 10% acceleration in revenue and a substantial 20% reduction in data-related expenses. By leveraging cutting-edge data visualization techniques and performance optimization tools, this project stands as a testament to my ability to drive meaningful outcomes in the realm of business intelligence.

Live Interactive Dashboard

PowerBI Project

Hotel Chain Business Analysis

The project gives business insights to the stakeholder and managers👨‍💻.Used filters like city and room types to watch ups and downs in the business also based on month data and week data filters . Also provided the category wise data filters also which will help deep dive in the Data Visualization

View Project
Engagement

View Project
on GitHUB

This is the homepage and the main page of the Report. It contains all information peroidically about all the hotels in India.

It is another page which consist of average rating and city wise revenue, occupancy% ,booking % etc.

Project Details

I have created a project on Hotel Sales Insight of a company 🏨 . This company has several hotels in various cities of Inida. I used Power-Bi for creating the Powerful and Insightful dashboard for the stakeholder . I used Mysql for basic Data analysis 📈 .I came across financial terms like Revpar and Adr which were futher used for creating KPI(Key Performance Indicators).