Portfolio - Sagar Soni | Codebasics

Powered by
Codebasics Bootcamp

Sagar Soni

Data Analyst

Resume

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

Data Analyst with 3 years of experience, proficient in Advanced Excel, Looker Studio, MySQL, and Python. Aspiring AI & Automation Specialist with a strong passion for innovation, process optimisation, and growth in data science.

Key Skills

Python

MySQL

MS Excel

Looker Studio

My Projects

Sales Analytics

Sales Analytics

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

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

Domain/Function: FMCG

PowerBI Project

Provide Insights to Revenue Team in Hospitality Domain

Provide Insights to Revenue Team in Hospitality Domain

Domain/Function: Hospitality

PowerBI Project

HR Analytics - provide employee's working preference insight

HR Analytics - provide employee's working preference insight

Domain/Function: HR Analytics

PowerBI Project

Provide Insights to Management in Consumer Goods Domain

Provide Insights to Management in Consumer Goods Domain

Hotel Domain Analysis Using Python

Hotel Domain Analysis Using Python

My Experience

Eminent Paper Industries LLP - (JAN/24 - NOW)
MIS & Data Analyst (Google sheet, Looker Studio, App Script)

Build and manage reporting systems in Google Sheets to support organisational targets.
Maintain employee performance scoring systems for productivity tracking.
Analyse data using advanced Google Sheets functions to generate meaningful insights.
Create custom systems using Google Workspace tools to streamline workflows.
Develop interactive dashboards in Looker Studio for data-driven decision-making.
Automate workflows using Google Apps Script.
Use AI tools (Gemini, ChatGPT, Botpress, NotebookLM) to streamline and optimise processes.

Hashtag Infosystem - (NOV/22 - DEC/23)
Data Analyst (MS Excel, Power BI)

Developed periodic reports using Pivot Tables in Excel and dashboards in Power BI to track key metrics and trends.
Utilised advanced Excel functions—including LOOKUPs, IFs, SUMIFs, COUNTIFs, and FILTER—for detailed data analysis.
Created interactive Power BI reports to deliver clear insights for decision-making.
Maintained and organised data systematically in structured folders for easy access and retrieval.
Delivered accurate and timely data to various departments based on their specific requirements.

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]

LinkedIn

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

Sales Analytics

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

Sales Analytics

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

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

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

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

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

Provide Insights to Revenue Team in Hospitality Domain

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

Provide Insights to Revenue Team in Hospitality Domain

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

HR Analytics - provide employee's working preference insight

➡ 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 Analytics - provide employee's working preference insight

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

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.

View Project
Engagement

View Project
on GitHUB

Provide Insights to Management in Consumer Goods Domain

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

Provide Insights to Management in Consumer Goods Domain

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

Hotel Domain Analysis Using Python

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

Hotel Domain Analysis Using Python

🔥 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.