Powered by
Codebasics DA Bootcamp

David John

Data Anlysis

+91 7600398199 [email protected]

Resume

Hello, I am

David John.

1

Excel Project

2

PowerBI Projects

About Me

Welcome to my portfolio! 🚀 I'm passionate about digging into data to uncover valuable insights that businesses can use to make smart decisions. I'm skilled in Excel, Power BI, SQL, and Python, which help me turn raw data into meaningful information. 📊

I hold a Master's Degree in AI and Machine Learning and have two years of experience in IT. My journey in data analysis is ongoing and I'm always learning new things to stay updated. 🎓

In my portfolio, you'll find various projects where I've used my skills to solve real-world business problems. From making data easy to understand with visuals to predicting trends, I love using data to help companies grow. 📈

Come take a look at my portfolio and let's chat about how I can help your business make sense of data and drive success! 🌟

Key Skills

SQL

SnowFlake

Python

Data Visulation

AWS

Tableau

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

Scam Awareness Course

SQL Beginner to Advanced For Data Professionals

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.

[email protected]

https://www.linkedin.com/in/david-john04/

+ 91 7600398199

https://github.com/Davidjohn4

Excel Project

Sales Analytics & Finance Report

Experience the dynamic story of annual net sales, comparing market achievements to targets. Dive into detailed P&L insights covering net sales, COGS, gross margin, and GM%. A concise yet comprehensive journey through business success metrics!

View Project
Engagement

View Project
on GitHUB

Other Tools

Pivot Table

Power Query

Condition Formating

Dax Query

Sales Analytics & Finance Report

Tracking country-wise sales 2019-2021. Altiq Hardware: Reporting on 2021 targets; colour scale shows achievement status.

Sales Analytics & Finance Report

The top & bottom 5 product quantities are shown with colour-coded achievement status

Project Details

1)Sales Analytics:
- We examine annual net sales against target goals, comparing actual performance with market expectations and evaluating the top 10 products.
- Our analysis includes division-wise comparisons to identify top and bottom performers, offering insights into market trends.
-We also assess deviations in sales performance, highlighting products that exceeded or missed targets to inform future strategies.

2) Finance Report:-

- We created a concise Profit and Loss (P&L) report, detailing net sales, COGS, gross margin, and GM% for each year.
- The report focused on comparing our market performance metrics against set targets for every quarter.
- This analysis offered a clear snapshot of our financial performance, highlighting strengths and areas for improvement throughout the year.

PowerBI Project

Provide Insights to the Product Strategy Team in the Banking Domain

A groundbreaking financial institution in Hyderabad. AtliQ Data Services revolutionized credit card offerings, achieving an unprecedented Utilisation % of 287.05%. Led by Strategy Director Mr. Bashnir Rover, the bank strategizes on 4000 customer details, ensuring a successful project launch.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power bi

Excel

Data Cleaning

Data modelling

Provide Insights to the Product Strategy Team in the Banking Domain

Using the Bookmark feature, you can view the Dashboard

Provide Insights to the Product Strategy Team in the Banking Domain

In this city, we have slicers for Gender, Payment Type, Marital Status, and Occupation. Additionally, we can employ IT Employee (ITE), Freelancer (FL)

Project Details

- Mind Bank's innovative credit card project aims to revolutionize the industry through tailored offerings.
- Collaborating with AtliQ Data Services ensures robust data handling for effective strategies.
- Led by Mr. Bashnir Rover, the project focuses on meticulous market research and customer analysis.
- Anticipated ROI stands at an impressive 287.05%, with key metrics like Minimum Balance, Delinquency Rate, and Bankruptcy Rate being prioritized.
- Targeting age groups 25-45, Mind Bank projects substantial growth with 144 million AUM for ages 25-34 and 131 million for ages 35-45.

Live Interactive Dashboard

PowerBI Project

Analyse Promotions and Provide Tangible Insights

AltiQ Mart, a leading retail chain in southern India, assesses ongoing festive promotions like $500 cash-back and BOGOF deals using SQL and Power BI. Insights from this analysis guide future promotions for improved sales and profitability.

View Project
Engagement

Other Tools

SQL

Power Query

Dax

View

Data Modelling

Analyse Promotions and Provide Tangible Insights

This is a dashboard displaying various metrics and insights related to sales performance and promotion types.

Analyse Promotions and Provide Tangible Insights

This dashboard provides insights on sales performance and promotion types, including bottom 2 IR product/category-wise and IS by category and promo t

Project Details

AltiQ Mart, a leading retail chain with 50 stores in southern India, focuses on festive promotions like Diwali and Sanskrit festivals. The Sales Director seeks to evaluate ongoing promotions using SQL, Power BI, and PowerPoint OBS Studio for future enhancement.

Key Insights:

Successful promotions: $500 cash-back and BOGOF deals, generating a $122 margin.
Less effective promotions: 50% and 25% off offers.
Top-performing stores: STMYS-1 and STCHE-4 in Chennai, driving substantial revenue.
Bottom-performing stores: STVSK-3 and STMLR-0 in Visakhapatnam and Mangalore, requiring improvement.
Revenue drivers: Combo1 and grocery & staples categories contributing 50% of total revenue.
This analysis will guide AltiQ Mart in refining its promotional strategies to maximize sales and profitability in the upcoming seasons.

Project video

Live Interactive Dashboard