Portfolio - Yash Shrikant Nagansure | Codebasics

Powered by
Codebasics DA Bootcamp

Yash Shrikant Nagansure

Data Analyst

EMAIL

[email protected]

About Me

Hi, I'm an aspiring Data Analyst with a degree in Computer Engineering and a strong interest in working with data. While I haven’t had a full-time job yet, I’ve completed several business-related projects that show how I can turn data into useful insights. You can check them out in my portfolio below.
I enjoy exploring data, finding patterns, and helping people make better decisions using tools like Excel, Power BI, SQL, and Python. Over time, I’ve realized that solving problems with data is something I’m naturally good at and it’s what I love doing most.
Now, I’m looking for an opportunity to grow, learn, and use my skills to add value to a team. If you’re looking for someone who’s curious, hardworking, and ready to start their journey in data, I’d love to connect.

1

Excel Project

1

PowerBI Project

1

SQL Project

Key Skills

Excel

PowerBI

SQL

Python

My Projects

My Experience

Fresher

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

Let's Work Together!

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.

EMAIL

[email protected]

LinkedIn

https://www.linkedin.com/in/yash-nagansure/

GitHub

https://github.com/nagansureyash

Excel Project

Sales Analytics(FMCG)

Domain/Function: FMCG

Created 2 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

Other Tools

Data Modeling

Power Query

Data Visualization

Sales Analytics(FMCG)

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

Sales Analytics(FMCG)

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 designed an interactive sales report using Excel Pivot Tables, aimed at helping businesses make smarter, data-driven decisions.

The report empowers businesses to:

Identify optimal customer discounts

Negotiate more effectively with consumers

Spot growth opportunities in high-potential countries

It delivers actionable insights and strategic recommendations to boost revenue, improve customer satisfaction, and refine sales strategies.

🔍 What I Worked On:
Built dynamic Pivot Tables for insightful data summaries

Used Power Query to clean and transform data efficiently

Applied Basic DAX to perform custom calculations

Enhanced visuals with Conditional Formatting and Report Beautification

Focused on key Sales Domain Metrics to drive meaningful conclusions

PowerBI Project

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

Domain/Function: Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares, a fast-growing electronics company, relied heavily on Excel for reporting. I built an advanced Power BI solution to transform static data into interactive dashboards, enabling real-time insights and smarter, data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

Other Tools

Data Modeling

Data Visualization

Power Query

DAX

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

User-empathetic landing page as a part of dashboard design.

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

Data modelling involving 10+ tables.

Project Details

The goal of this project was to build a single, unified report catering to stakeholders from Sales, Marketing, Finance, and the Executive Team — all in one place.

🔍 Key Focus Areas:

Robust data modeling with 10+ tables

User-focused report design for easy navigation

Drillable insights to support deeper analysis

💡 What I Learned:

Power Query (basic to advanced transformations)

DAX (from simple measures to complex calculations)

Visual best practices & dashboard design principles

Implementing bookmarks, publishing to Power BI Service, and acting on stakeholder feedback

Working with cross-functional business metrics (Sales, Marketing, Finance & Supply Chain)

This project strengthened my ability to build impactful, scalable, and interactive BI solutions tailored to real business needs.

Live Interactive Dashboard

SQL Project

MySQL Project in the Consumer Goods Domain

Domain/Function: Consumer Goods Domain

Completed Codebasics Challenge #4 – a SQL project in the consumer goods domain. Used subqueries, joins, CTEs, window functions, and CASE statements to extract key metrics like Gross Profit, Contribution %, and top-selling products.

View Project
Engagement

View Project
on GitHUB

MySQL Project in the Consumer Goods Domain

This Query compares product counts by segment for 2020 and 2021 showing growth differences, with Accessories having the highest increase of 34 product

MySQL Project in the Consumer Goods Domain

The output displays month-wise gross sales for the years 2019 and 2020, with the highest sales recorded in November 2019 at 15.23 million.

Project Details

This project is part of Codebasics Challenge #4, focused on solving a real-world business case for Atliq Hardware, a fictional consumer goods company. The objective was to help the management team make better, data-driven decisions by analyzing their sales and financial data using SQL. I applied key SQL concepts like subqueries, multiple joins, CTEs, window functions, and CASE statements to extract meaningful insights. The analysis covered important metrics such as Gross Profit, Contribution %, best-selling products, average gross sales, and manufacturing costs. This project not only strengthened my technical skills but also improved my ability to translate data into actionable insights.