Portfolio - Soniya Nagdeo

Soniya Nagdeo

Data Aspirant

Resume

1

Excel Project

1

PowerBI Project

1

SQL Project

About Me

Hi, I’m Soniya Nagdeo—a passionate Data Analyst who loves turning numbers into stories that drive results. With experience in tools like Power BI, SQL, Python, and Excel, I create dashboards, analyze trends, and deliver insights that help businesses grow. I’ve worked on exciting projects in e-commerce, hospitality, and finance, improving customer retention, boosting revenue, and streamlining decision-making. During my internships, I helped uncover growth opportunities and built solutions that made data simple and actionable. With certifications from Coursera and Code Basics, I’m always learning and eager to tackle new challenges. I’m looking forward to working with innovative teams to solve problems and make an impact through data. Let’s connect!

Key Skills

Excel

Power Bi

SQL

Python

MySQL

Google Big Query

My Projects

Sales Analytics(FMCG)

Domain/Function: Sales

Revenue Analytics (Hospitality)

Domain/Function: Revenue

Atliq Finance Analytics

Domain/Function: Finance

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Google Data Analytics Certificate

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/soniya-nagdeo-/

Call Me

+91 9111700211

GitHub

https://github.com/soniya18

Excel Project

Sales Analytics(FMCG)

Domain/Function: Sales

Developed two comprehensive reports for the sales team to assess customer performance and gain insights into their market performance in relation 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 to help businesses optimize customer discounts, negotiate effectively, and identify growth opportunities in potential markets.

Key Skills Learned:
1. Pivot Tables
2. Power Query
3. Basic DAX
4. Conditional Formatting
5. Report Beautification
6. Sales Metrics

The report provides actionable insights to enhance sales strategies, improve customer satisfaction, and drive revenue growth, empowering businesses to stay competitive.

PowerBI Project

Revenue Analytics (Hospitality)

Domain/Function: Revenue

AtliQ Grands, a chain of five-star hotels, is losing market share due to competition and poor decision-making. The goal is to implement a data intelligence solution to provide insights and support strategic decisions, helping the company regain its competitive edge.

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling of complex tables

Project Details

The goal is to create a business and data intelligence solution to help AtliQ Grands regain market share and revenue. The project focuses on developing key metrics and a dashboard for better decision-making across sales, marketing, and executive teams.

Key Learning Outcomes:

- Data extraction and transformation techniques
- Development of key revenue and market share metrics
- Dashboard design for user-friendly insights
- Data visualization and reporting
- Stakeholder feedback implementation for dashboard refinement

Live Interactive Dashboard

SQL Project

Atliq Finance Analytics

Domain/Function: Finance

Atliq Hardware is a leading manufacturer and distributor of high-quality hardware products. With a focus on innovation and customer satisfaction, Atliq Hardware offers a wide range of products designed to meet various industry needs. The company is committed to excellence through advanced technology

View Project
Engagement

View Project
on GitHUB

The script is creating a view named "gross sales" by selecting and joining data from multiple tables.

The image shows a SQL script creating a table by combining data from two sources using a `LEFT JOIN` and `UNION` statement for supply chain analysis.

Project Details

The goal of the Atliq Hardware SQL Analysis project is to analyze sales efficiency to provide actionable business insights. The project focuses on developing key metrics and a dashboard for better decision-making across sales, marketing, and executive teams.

Key Learning Outcomes:

- Sales trends & forecasting
- Advanced finance & supply chain analytics
- SQL-driven insights for better decision-making
- Performance optimization using window functions, stored procedures, and database views
- Hands-on experience with user-defined SQL functions

This project enhanced my understanding of data-driven business strategies and strengthened my SQL skills for real-world applications.