Portfolio - Devesh chaudhari | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Devesh chaudhari

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Me

Welcome to my world of data-driven insights! I am an aspiring Data Analyst with a passion for unraveling the hidden stories within data. Armed with proficiency in Excel, Power BI, SQL, and Python, I possess the analytical tools to transform raw data into actionable knowledge.
While my academic journey started with a Bachelor's degree in Electronics & Telecommunications, but I soon realized my knack for data analysis. It's like solving puzzles, but with numbers and information!
Even though I haven't worked in a big company yet, I've taken on a bunch of cool business projects. Check 'em out in my portfolio below. They'll show you how I turn data into insights that can boost businesses.
I'd love for you to explore my portfolio and see how I can make data work magic for you. Let's team up and create data-driven success stories together!

Key

Skills

SQL

Python

Machine Learning

My

Projects

Sales Analytics Report

Sales Analytics Report

Transformed sales data into actionable insights, producing detailed net sales reports and profit/loss analyses for improved product performance and data-driven business strategy optimization.

Business Insights 360

Business Insights 360

Project: Business Insights 360 - Empowering AtliQ Technologies with comprehensive financial, sales, marketing, and supply chain analytics for data-driven growth.

Early Detection of Pulmonary Lung Fibrosis

Early Detection of Pulmonary Lung Fibrosis

Built a predictive model using medical data and CT scans of patients to assess lung function decline and FVC (Forced Vital Capacity) values, enhancing patient care.

Product Sales Analysis

Product Sales Analysis

Utilized SQL expertise skills for in-depth sales, supply chain reports, and ad-hoc analysis, driving data-driven insights and operational optimization.

Awards

& Certificate

Python (Basics)

Python (Basics)

SQL (Intermediate)

SQL (Intermediate)

Data Visualization With Python

Data Visualization With Python

Contact Me

Email

[email protected]

Github

https://github.com/Devesh252

Linkedin

https://www.linkedin.com/in/devesh-chaudhari-5b03731a5/

Call

+91 7057815333

Devesh chaudhari

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics Report

Transformed sales data into actionable insights, producing detailed net sales reports and profit/loss analyses for improved product performance and data-driven business strategy optimization.

View Project
on GitHUB

Sales Analytics Report

Year-wise Market Net Sales vs. Target for In-Depth Performance Analysis.

Sales Analytics Report

Fiscal Year P&L by Quarter with Year-on-Year Comparison.

Project Details

This project aimed to empower AtliQ Hardware Company, specializing in hardware sales, with data-driven insights. It involved creating essential sales reports, including Customer Net sales Performance, Market Performance vs. Target, Net Sales by Division Level, New Product Analysis, Top/Bottom 10 Product Analysis, etc. Additionally, we generated key finance reports, such as the Profit & Loss (P&L) report, P&L by Fiscal Year, Gross Margin Analysis, etc. Leveraging Excel's analytical capabilities, these reports offered a comprehensive view of sales performance and financial health. They facilitated informed decision-making, resource allocation, and strategic planning, ultimately guiding AtliQ Hardware towards sustained growth in the competitive hardware market.

PowerBI Project

Business Insights 360

Project: Business Insights 360 - Empowering AtliQ Technologies with comprehensive financial, sales, marketing, and supply chain analytics for data-driven growth.

View Project
Engagement

View Project
on GitHUB

Business Insights 360

Employed data modeling techniques to construct a central star schema, placing fact tables at the core and surrounding them with dimensions.

Business Insights 360

Analyze marketing trends, unit economics, and customer insights for data-driven strategy optimization and growth maximization.

Project Details

This comprehensive initiative was undertaken to empower AtliQ Technologies Hardware with a holistic view of their business across multiple dimensions.
Finance View:- Master financial performance with dynamic analysis. Monitor net sales and detailed profit and loss statements for informed decision-making.
Sales View:- Explore customer and product performance, visualize Net Sales and Gross Margin for data-driven sales strategies.
Marketing View:- Evaluate marketing trends, unit economics, and customer insights for growth-focused marketing strategies.
Supply Chain View:- Analyze Forecast Accuracy and Net Error to enhance sales accuracy and operational efficiency.
Executive View:- Provide leadership with strategic decision support, profit maximization opportunities, customer-centric insights, and market expansion strategies. Foster a data-driven culture.
This project was Empowering AtliQ Tech with a 360° business view, driving data-driven growth and smart decision-making.

Live Interactive Dashboard

Early Detection of Pulmonary Lung Fibrosis

Built a predictive model using medical data and CT scans of patients to assess lung function decline and FVC (Forced Vital Capacity) values, enhancing patient care.

View Project
on GitHUB

Early Detection of Pulmonary Lung Fibrosis

Data visualization with Pandas: bar chart for patient age distribution and scatter plot correlating FVC with age for smokers/ex-smokers.

Early Detection of Pulmonary Lung Fibrosis

We Build a ResNet50 model to extract features from CT scan and utilized an XGBoost Regressor to predict FVC values, yielding remarkable result.

Project Details

Our project is all about creating a smart model to predict the FVC(Force vital capacity) value and how lung function declines in people with pulmonary fibrosis. We gathered lots of information, like patient details, medical records, and lung CT scans.
We cleaned and organized the data to make sense of it. We also made special features to understand how lung health changes over time.
Using Machine learning algorithm, we made a smart model that can predict FVC Value & how someone's lung function might get worse. This helps doctors make better choices for patient care.
We integrated medical data and CT scans using ResNet-50 to extract critical features. XGBoost Regressor then predicted Forced Vital Capacity (FVC) values, achieving an impressive R-squared error of 0.98 and a mean absolute error of 0.00033.
We aim to contribute to early detection and proactive care, improving the lives of those impacted by this challenging condition.

SQL Project

Product Sales Analysis

Utilized SQL expertise skills for in-depth sales, supply chain reports, and ad-hoc analysis, driving data-driven insights and operational optimization.

View Project
Engagement

View Project
on GitHUB

Product Sales Analysis

Created the stored procedure to get top n number of customers based on their net sales.

Product Sales Analysis

Created the supply chain report and calculated the forecast accuracy for both fiscal year 2020 and 2021.

Project Details

Developed comprehensive sales reports, supply chain reports, and ad-hoc analyses using SQL.
Leveraged SQL skills in joins, subqueries, CTEs, views, stored procedures, and functions to create impactful reports and analyses.
Delivered data-driven insights to enhancing decision-making and optimized business operations.