Portfolio - soham joshi | Codebasics

Powered by
Codebasics DA Bootcamp

soham joshi

Data Aspirant

EMAIL

[email protected]

PHONE

+91 7067288399

Download CV

About Me

As an aspiring Data Analyst with a BBA in Finance from Indore Institute of Management & Research, I bring a unique blend of analytical thinking, business acumen, and a deep interest in data-driven decision-making. During my academic journey, I developed a strong foundation in financial management, Data analytics which naturally led me to explore the dynamic world of data.
I have equipped myself with practical skills in Excel, SQL, Python, Power BI to analyze and visualize complex datasets. Through personal projects and online certifications, I have worked on extracting actionable insights from real-world financial and operational data, optimizing reporting processes, and presenting findings in a clear and compelling manner.
What sets me apart is my ability to bridge the gap between financial concepts and technical analysis. I thrive in environments that challenge me to ask the right questions, explore data with curiosity, and contribute meaning.

1

Excel Project

1

PowerBI Project

2

SQL Projects

1

Python Project

Key Skills

Excel(Advance)

SQL

Power Bi

Python

Google Sheets

Financial Analysis & Reporting

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

SQL Beginner to Advanced For Data Professionals

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

Python: Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Data Engineering Basics for Data Analysts

AI Automation for Data Professionals

Data Analytics Job Simulation

Data Analytics Job Simulation

Data Visualisation: Empowering Business with Effective Insights

Data Visualisation: Empowering Business with Effective Insights

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]

Call Me

+91 7067288399

LinkedIn

https://www.linkedin.com/in/soham-joshi-87b99227b/

GitHub

https://github.com/SohamJoshi07

Excel Project

Financing Model for a Refined Edible Oil Manufacturing Unit.

Domain/Function: Financial Modelling

🚀 Overview: Developed a comprehensive financial model and management input analysis for a proposed Refined Edible Oil Manufacturing Plant with a total project cost of ₹210–225 Cr. The plant is designed to process Palm Oil (1.8 Lakh TPA), Mustard Oil (45,000 TPA), and Soft Oils (90,000 TPA).

View Project
on GitHUB

Financing Model for a Refined Edible Oil Manufacturing Unit.

This image shows a project cost breakdown and fund requirement schedule across six dates, detailing expenses, their percentages, and funding sources.

Financing Model for a Refined Edible Oil Manufacturing Unit.

This image shows a projected cash flow statement (2023–2031) detailing sources and uses of funds, with yearly opening, surplus/deficit,

Project Details

Designed a dynamic financial model in Excel to evaluate project feasibility, incorporating cost estimation, revenue projections, and
loan repayment schedules using advanced formulas and macros.
Generated automated Profit & Loss, Balance Sheet, and Cash Flow Statements, enabling clear financial forecasting and investment
planning for stakeholders.
Conducted ratio analysis, working capital planning, and interest during construction (IDC) calculations to support strategic decision
making and ensure financial viability.

SQL Project

Retail Sales Analysis

Domain/Function: Retail Business Intelligence

This SQL-based project focuses on analyzing retail sales data, ideal for beginners aiming to develop foundational data analysis skills. It involves creating and managing a retail database, performing exploratory data analysis (EDA), cleaning the dataset, and answering key business questions.

View Project
on GitHUB

Retail Sales Analysis

SQL script for setting up a retail sales database with a table storing transaction ID, date, time, customer info, category, quantity, and sales data.

Retail Sales Analysis

This image shows SQL queries for data exploration and cleaning, including record counts, category checks, null value detection.

Project Details

This project is designed to demonstrate SQL skills and techniques typically used by data analysts to explore, clean, and analyze retail sales data. The project involves setting up a retail sales database, performing exploratory data analysis (EDA), and answering specific business questions through SQL queries. This project is ideal for those who are starting their journey in data analysis and want to build a solid foundation in SQL.

Python Project

Nova Voice Assistant

Domain/Function: Voice-Enabled Virtual Assistant

Developed a Python-based voice assistant using Speech Recognition and pyttsx3 to implement speech-to-text and text-to-speech (TTS) functionalities for interactive user communication.

View Project
on GitHUB

Nova Voice Assistant

Python script using speech recognition and text-to-speech to fetch and speak top 5 news headlines via a News API, handling errors and null responses.

Nova Voice Assistant

Python command processor that opens websites, plays songs, or fetches news based on voice commands using conditionals and text-to-speech responses.

Project Details

🎙️ Nova: Voice-Controlled Virtual Assistant in Python Nova is a simple yet effective voice-controlled personal assistant built in Python. It uses speech recognition and text-to-speech to interact with users, process commands, and perform actions like opening websites, playing music, and reading out the latest news.

🔧 Features Wake Word Activation: Listens for the wake word "nova" to start interaction. Speech Recognition: Converts your voice commands to text using Google's speech recognition. Text-to-Speech (TTS): Responds back using a natural-sounding voice via pyttsx3. News Reader: Fetches and reads top headlines using News API. Music Playback: Plays predefined songs via YouTube links from the local musiclibrary.py. Web Control: Opens commonly used websites like Google, YouTube, Facebook, etc.

PowerBI Project

Business Insights for AtliQ Hardware

Domain/Function: AtliQ360: Unified Business Dashboard

This Power BI project delivers a 360-degree business intelligence platform for AtliQ Hardware, designed to empower leadership and department heads with actionable, cross-functional insights.

Business Insights for AtliQ Hardware

A Power BI dashboard homepage for AtliQ Hardware offering views for Finance, Sales, Marketing, Supply Chain, and Executive insights in one place.

Business Insights for AtliQ Hardware

This is a Microsoft Power BI dashboard displaying business insights, including sales data, revenue, and market trends.

Project Details

This Power BI project for AtliQ Hardware provides a centralized analytics solution integrating Finance, Sales, Marketing, Supply Chain, and Executive views. Each department-specific dashboard delivers deep insights through interactive visuals, KPIs, and trends, enabling leadership to monitor performance and align strategy. The Executive View offers a high-level summary, while the Finance View tracks profit, cost, and margins. The Sales View highlights regional and category-wise trends. The Marketing View analyzes campaign effectiveness and lead conversion. The Supply Chain View monitors inventory, supplier performance, and logistics. This cross-functional tool improves decision-making, operational efficiency, and long-term planning.

Live Interactive Dashboard

SQL Project

COVID-19 Global Impact Analysis using SQL & Tableau

Domain/Function: Healthcare Analytics

Analyzed global COVID-19 data using SQL to explore infection, death, and vaccination trends. Built interactive Tableau dashboards to visualize key insights, enabling data-driven understanding of pandemic impact across regions and time.

View Project
on GitHUB

COVID-19 Global Impact Analysis using SQL & Tableau

This screenshot shows SQL queries analyzing COVID-19 data, including death percentage and infection rate by location, using the CovidDeaths$ table.

COVID-19 Global Impact Analysis using SQL & Tableau

This Tableau dashboard visualizes COVID-19 global stats, death count by continent, infection percentage by country, and infection trends over time.

Project Details

Conducted an exploratory data analysis of global COVID-19 data using SQL to examine trends in total cases, deaths, and vaccinations. Performed data cleaning, transformation, and aggregation to calculate key metrics such as death percentage, infection rate, and vaccination coverage. Utilized advanced SQL functions like CTEs, window functions, and temporary tables for in-depth analysis. Created views for seamless integration with Tableau, where interactive dashboards were built to visualize pandemic trends across countries and continents. The project provided actionable insights into the healthcare impact of COVID-19 and showcased skills in data analysis, public health analytics, and business intelligence reporting.