Portfolio - Lokesh Bhangale

Excel Project

Sales Analytics and Financial Report

I had the privilege of working on a Sales Analytics and Financial Report project. Delving into the numbers of the company, this project expanded my analytical horizons, unlocking valuable insights through financial and sales report analysis.

View Project
Engagement

View Project
on GitHUB

Customer performance report according to year

Data consists of year and quarters for parameters like Net Sales, COGS, Gross Margin, Gross Margin %

Project Details

📊 In this project I leverage the power of Excel and utilized Power Query for data cleaning and transformation, merging tables for comprehensive insights, and implemented Power Pivot for robust data modeling and creating essential measures. To enhance the visual impact, I incorporated conditional formatting techniques for visually engaging representations.
I have learned the following:
1. Pivot table
2. Power Query
3. Dax
4. Conditional Formatting
5. Report Beautification
6. Sales domain metrics
💡 The heart of the project revolved around analyzing net sales figures and evaluating the variance between targeted and actual net sales across various dimensions: years, customers, countries, products, and divisions. Calculating COGS, gross margin, and gross margin percentage provided crucial insights into the financial health of the company.

PowerBI Project

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

Goal of the project is to implement an advanced analytics solutions using Power BI that will enable the company to get insights and make informed decisions.

View Project
Engagement

View Project
on GitHUB

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

It is home page of dashboard which will help user to navigate to required dashboard.

It is data model view which help to find relations/connections between tables

Project Details

In the project focus made on:
1. User friendly design
2. Drillable Insights
3. Robust data modelling
Below is what I learned in the project:
1. Different domain metrics(Finance, sales, Supply Chain, Marketing)
2. Use of bookmarks
3. Data Modelling
4. Power Query(Basic and Advanced)
5. DAX Formulas(Basic to Complex)
6. Implementing stakeholder feedback
7. Choosing right visuals
8. Deploying Power BI Desktop work in Power BI Service
🔍 Key Insights:
Maximizing Profitability: Achieved a significant Gross Margin % of 48.55%, indicating a strong potential for profit optimization across segments.
Strategic Focus: Identified PC division and Retailer channel as revenue powerhouses, accounting for 61.33% and 71.53% respectively.
Operational Precision: Addressing forecast accuracy challenges at Unity Store (8.32%) to ensure smoother supply chain operations.

Live Interactive Dashboard

Data Collection and Preprocessing of Camera Products on Amazon

A web scraping and data preprocessing project focused on Camera products listed on Amazon! In this endeavor, I utilized my skills in web scraping to collect valuable data and performed various data preprocessing steps to enhance its quality and usefulness.

View Project
Engagement

View Project
on GitHUB

Data Collection and Preprocessing of Camera Products on Amazon

Importing required libraries for data extraction and writing Scroll function to scroll a webpage using Selenium webdriver.

Sample data from extracted data using data extraction

Project Details

1️⃣ Web Scraping:
By leveraging Python libraries like Selenium, and pandas, I extracted vital product details such as names, descriptions, and more directly from Amazon's website.
2️⃣ Basic Info on Data:
I conducted an initial analysis to data understand its structure and content. This step involved gaining insights into the dataset's size, number of records, and key variables.
3️⃣ Data Cleaning:
I employed advanced data-cleaning techniques to ensure the integrity and reliability of the collected data. This involved handling missing values, removing duplicate and addressing any inconsistencies in the dataset obtained from the web scraping process.
4️⃣ Data Reduction:
To simplify the dataset and focus on the most relevant information, I performed data reduction techniques. This involved filtering out unnecessary variables or columns that didn't contribute significantly to the analysis.
5️⃣ Data Transformation:
This step involved converting data types, and normalizing values.

Early Detection of Pulmonary Lungs Fibrosis Progression

The goal was to predict the decline in lung function of patients using medical information and CT scans. We utilized data analysis, deep learning (ResNet-50) for feature extraction and machine learning algorithm(XGBoost).

View Project
on GitHUB

Early Detection of Pulmonary Lungs Fibrosis Progression

Importing required libraries and importing data.

Data visualization to find insights and to get know data better.

Project Details

OSIC Pulmonary Fibrosis Progression project, where the goal was to predict the decline in lung function of patients using medical information and CT scans. We utilized data analysis, deep learning (ResNet-50) for feature extraction and machine learning algorithm(XGBoost) to develop accurate predictions of pulmonary fibrosis progression. By working on this project, we gained experience in data science and machine learning.

PowerBI Project

Credit Card Spending Analysis in India

Goal is to develop an interactive dashboard that contains insights into offering a comprehensive look at the spending habits of Indians across the nation, including gender and card types used to carry out each transaction.

View Project
Engagement

It shows credit card analytics for male users.

It shows credit card analytics for female users.

Project Details

This project offers a comprehensive look at the spending habits of Indians across the nation. From the Gender and Card type used to carry out each transaction, to which city saw the highest amount of spending and even what kind of expenses were made, this dataset paints an overall picture about how money is being spent in India.

Live Interactive Dashboard

SQL Project

Finance Analytics & Report Generation

This project focuses on Finance Analytics and Report Generation, aimed at providing efficient and customized reporting solutions for critical decision-making. Leveraging SQL, the project streamlines the process by implementing stored procedures, user-defined functions, and optimizing queries.

View Project
Engagement

View Project
on GitHUB

Executing get_forecast_accuracy stored procedure

Executing gross_sales view

Project Details

Key Features:

1. Customizable Reports: Generate reports based on input parameters like in_fiscal_year, in_top_n, and customer_code.
2. Insightful Metrics: Extract key metrics including forecast accuracy, market badge, monthly gross sale for customers, and more.
3. User-Friendly Design: Emphasis on readability and simplicity in complex queries for easy comprehension.

Usage
1. Generating Reports:
Navigate to the queries directory and execute the desired SQL files to generate reports. Input parameters such as in_fiscal_year, in_top_n, and customer_code as required.

2. Viewing Reports:
Access generated reports from the reports directory in CSV format.

Hello, I am

Lokesh Bhangale

1

2

1

About

Key

My

Sales Analytics and Financial Report

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

Data Collection and Preprocessing of Camera Products on Amazon

Early Detection of Pulmonary Lungs Fibrosis Progression

Credit Card Spending Analysis in India

Finance Analytics & Report Generation

Awards

Contact Me

Email

Github

Linkedin

Call

Lokesh Bhangale

Download Resume