Sagar Soni

Data Analyst

[email protected] +91 7874677836

Resume

Hello, I am

Sagar Soni.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

📊 Data Analyst from Civil Engineering

🔎 Transforming raw data into actionable insights with a passion for machine learning, algorithms, and AI advancements. 🚀

🌱 Excited to work in dynamic startup environments, where curiosity and innovation drive impactful solutions. A lifelong learner, always ready for new data science challenges. 💡

Turning numbers into narratives and insights into action! 📈✨

Key Skills

Python

MySQL

My Projects

Sales Analytics

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: FMCG

Provide Insights to Revenue Team in Hospitality Domain

Domain/Function: Hospitality

HR Analytics - provide employee's working preference insight

Domain/Function: HR Analytics

Provide Insights to Management in Consumer Goods Domain

Hotel Domain Analysis Using Python

My Experience

Hashtag Infosystem - Data Analyst - Nov/22 - Dec/23

Improved reporting efficiency by 25% by migrating to BI dashboards.
We have utilized advanced Excel functions like VLOOKUP, SUMIFS, and Pivot Tables for reporting.
Achieved 15% time savings by implementing VBA Recording.
Boosted stakeholder understanding by 40% with Power BI dashboards.

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.

Mail Me

[email protected]

https://www.linkedin.com/in/sagar7502/

Call Me

+91 7874677836

GitHub

https://github.com/Sagar8902

Excel Project

Sales Analytics

Made two reports for the sales and marketing teams. These reports will help them see how well customers are doing and how their market performance compares to their targets

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years.

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using Excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: FMCG

AtliQ Hardware is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exist in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make info

View Project
Engagement

View Project
on GitHUB

Other Tools

sql

excel

An executive perspective of the dashboard that provides a comprehensive overview of the entire business.

Data modeling involving 10+ tables

Project Details

In this project, the goal is to create one report that could be used by stakeholders from sales, marketing, finance, and executive teams. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Project video

Live Interactive Dashboard

PowerBI Project

Provide Insights to Revenue Team in Hospitality Domain

Domain/Function: Hospitality

As a passionate learner and aspiring Data Analyst, I took on the challenge to revamp the revenue strategy of India's prestigious AtliQ Grands 5-star hotel chain. 🌟

View Project
Engagement

View Project
on GitHUB

Other Tools

sql

excel

The hotel industry is dynamic, and AtliQ Grands is facing revenue challenges. My role was to analyze data and provide crucial insights to drive effect

Project Details

🔍 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗦𝗰𝗼𝗽𝗲:
The hotel industry is dynamic, and AtliQ Grands is facing revenue challenges. My role was to analyze data and provide crucial insights to drive effective decision-making.

🔍 𝗞𝗲𝘆 𝗥𝗲𝘃𝗲𝗹𝗮𝘁𝗶𝗼𝗻𝘀:
📊 Total Revenue: A whopping 1.71Bn! 💰
🏙️ Highest Revenue City: Mumbai (40% of Total Revenue)
⭐ Top-rated City: Delhi, with an average rating of 3.8
🏨 Luxury vs. Business: Luxury category reigns supreme, generating 1053M
🏞️ Star Performer: AtliQ Exotica property raking in 320M revenue
🛏️ Room Class Leader: Elite rooms, preferred by many guests
📈 Platform Power: Makeyourtrip generates the highest revenue
🏨 Hotel Performance: AtliQ Exotica crowned with 320M in revenue, while AtliQ Seasons stood at 66M.
📈 RevPAR Showdown: AtliQ Exotica leading with 7.8k RevPAR, and AtliQ Grands at 6.5k.
💵 ADR: AtliQ Seasons triumphed with an ADR of 16.6k, whereas AtliQ Blu was at 11.9k.

Project video

Live Interactive Dashboard

PowerBI Project

HR Analytics - provide employee's working preference insight

Domain/Function: HR Analytics

This will enable HR to quickly grasp each employee's working status, including their presence, sick leave percentage, and work-from-home percentage on a month-to-month basis.

View Project
Engagement

View Project
on GitHUB

Other Tools

excel

➡ We're rocking a solid 91.55% overall attendance rate! 🚀 ➡WFH days clock in at around 11.15%, showing we've got a nice balance between office and re

HR has faced challenges in organizing employee attendance and work data across multiple Excel sheets. As a data analyst, I streamline this process by

Project Details

🔍 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗦𝗰𝗼𝗽𝗲:

👉 HR has faced challenges in organizing employee attendance and work data across multiple Excel sheets. As a data analyst, I streamline this process by consolidating all relevant information into a single, easily accessible format.

👉 This will enable HR to quickly grasp each employee's working status, including their presence, sick leave percentage, and work-from-home percentage on a month-to-month basis.

🔍 Key findings:

➡ We're rocking a solid 91.55% overall attendance rate! 🚀
➡WFH days clock in at around 11.15%, showing we've got a nice balance between office and remote work. 🏠💼
➡Sick leave? Barely a blip at 1.18%! Our team's staying healthy and on point. 💪
➡Peak presence: 📆 Mondays are the busiest days, and Fridays are more relaxed. Typical start-of-week hustle!
➡WFH favorites: 🚀 Fridays! are the top choice for working from home.
➡Sick day trend: 🛌sick days are most common at the start of the week like Monday and Tuesday

👉 These insight

Project video

Live Interactive Dashboard

SQL Project

Provide Insights to Management in Consumer Goods Domain

View Project
Engagement

View Project
on GitHUB

➡️ Command on SQL Syntax: The more I practiced SQL, the more comfortable I became with syntaxes like Common Table Expressions and window functions.

In my role as a Data Analyst, I have contributed to uncovering valuable insights for Atliq Hardware.

Project Details

The challenge was set against Atliq Hardware's need for better insights to make quick and informed decisions. They aimed to expand their data analytics team, led by Tony Sharma, who sought candidates proficient in technical and soft skills through a SQL challenge.

In my role as a Data Analyst, I have contributed to uncovering valuable insights for Atliq Hardware.

Here are three key lessons I've learned:

➡️ Command on SQL Syntax: The more I practiced SQL, the more comfortable I became with syntaxes like Common Table Expressions and window functions.

➡️ Turning Queries into Visuals: I have learned how to turn SQL queries into
easy-to-understand visuals like charts and graphs, making complex data more accessible.

➡️Improving Presentation Skills: Presenting findings clearly and concisely has been crucial. Effective communication has been key to driving discussions and influencing decisions.

Python Project

Hotel Domain Analysis Using Python

Addressing stiff competition and declining revenue at Atliq Grands, I utilized Python to conduct an in-depth exploration of the hotel domain, offering actionable insights for boosting customer retention and revenue growth.

View Project
Engagement

View Project
on GitHUB

🚀 Project Highlights: ➡️ Data Cleaning: Rectified missing values and outliers. ➡️ Data Transformation: Introduced new columns like occupancy.

🔥 Skills Developed: ➡️ Proficiency in Python: Expertise in data analysis, cleaning, transformation, and visualization.

Project Details

🚀 Project Highlights:
➡️ Data Cleaning: Rectified missing values and
outliers.
➡️ Data Transformation: Introduced new columns like occupancy%.
➡️ Insights Generation: Explored crucial questions such
as average occupancy rates, weekday versus weekend occupancy, city-wise
revenue, monthly revenue trends, and platform-specific revenue analysis.

🔥 Skills Developed:
➡️ Proficiency in Python: Expertise in data analysis,
cleaning, transformation, and visualization.
➡️ Data Visualization: Utilized Matplotlib to craft
engaging charts and graphs.
➡️ Pandas Basics: Mastered techniques for data
manipulation such as groupby, concat, merge, handling NA values, and CSV file
processing.

💡 Key Findings:
➡️ Revenue Leaders: Mumbai emerged as the top earner
with 669M INR; May recorded the highest revenue at 581.93M INR.
➡️ Customer Preferences: Presidential rooms received
the highest rating of 3.69; Delhi showcased an average rating of 3.78.