Portfolio - Jithin Raj B | Codebasics

Powered by
Codebasics DA Bootcamp

Jithin Raj B

Junior Business Analyst

EMAIL

[email protected]

PHONE

+91 8089648779

Download CV

About Me

A Business Analyst with a demonstrated ability to transform complex data into actionable insights. Proficient in Power BI, SQL, and Python, with expertise in developing efficient dashboards and automating processes to enhance decision-making and optimize time. Holding an MTech in Water Resources Engineering from NIT Calicut, with professional experience spanning diverse domains, including e-commerce and education. Committed to leveraging data analytics to drive impactful business outcomes while fostering continuous professional development.

5

PowerBI Projects

Key Skills

Python

MS Word

SQL

MATLAB

Power BI

Power Point

Advanced Excel

Web Scrapping

My Projects

My Experience

TinyZo Online Pvt. Ltd. Jul 2021 – May 2024

Manjeri, Kerala, India (on-site)

• Automated monthly reporting process using advanced Excel techniques, including Power Query, reducing time and effort by 75%.

• Designed and implemented a SQL database connected to through on-premise gateway with Power BI services for

streamlined sales analysis.

• Integrated sales data from multiple e-commerce platforms (Amazon, Flipkart, Jiomart, Meesho, Tata 1 mg and Firstcry) into a unified dashboard, enabling faster insights and better decision-making.

• Over 4 years of sales data exceeding 1 million rows were analyzed from various platforms, with data integrated across 20+ tables through efficient data modelling.

Freelance Subject-Matter Expert Jul 2021 – May 2024

TutorBin, Gurugram, India (Remote)

• Addressed 400+ global student queries in math, statistics, civil engineering, hydrology, programming, numerical, and analytical methods, achieving an expert rating exceeding 4.8 out of 5.

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 8089648779

LinkedIn

https://www.linkedin.com/in/jithinrajb

GitHub

https://github.com/Jithin-Raj-DataAnalyst

PowerBI Project

Amazon Advertisement Campaign Analysis

Domain/Function: Online Retail

An interactive Power BI dashboard to analyze Amazon Sponsored Product advertisement campaigns, offering actionable insights for optimizing advertising strategies.

Amazon Advertisement Campaign Analysis

It evaluates the performance of Amazon Sponsored Product ad campaigns, focusing on metrics like impressions, clicks, spend, sales, ROAS, and ACOS.

Amazon Advertisement Campaign Analysis

Slicers selected: Targeting and ROAS

Project Details

Power BI Interactive Dashboard for Analyzing Amazon Ad Campaign Performance

Reports Used: Data was downloaded from the Amazon Ads Console, including the Search Term, Targeting, Advertised Product, Campaign, Budget, and Placement Reports. These reports, spanning various periods, were extracted, transformed, consolidated, and loaded (ETL) using Power Query Editor in Power BI.

Key Metrics:
- Impressions: The number of times ads were displayed to users, indicating the reach of the campaigns.
- Clicks: The number of user interactions with the ads, reflecting engagement levels.
- Spend: The total amount invested in running the ad campaigns.
- Sales: The revenue generated from the campaigns, showcasing the effect
- ACOS (Advertising Cost of Sales): Measures the percentage of ad spend on sales. A lower ACOS indicates a more efficient campaign.
- ROAS (Return on Ad Spend): Evaluates the revenue generated for every spent on ads. Higher ROAS signifies better performance.

Live Interactive Dashboard

PowerBI Project

Power BI Dashboard for Multi-Platform E-Commerce Sales Analysis

Domain/Function: Online Retail

A comprehensive Power BI solution designed to consolidate sales data from multiple platforms, including Amazon, Flipkart, Meesho, Tata 1mg, JioMart, and FirstCry. The dashboard provides a unified view of performance metrics across over 25 brands and a diverse portfolio of unique products.

Power BI Dashboard for Multi-Platform E-Commerce Sales Analysis

The Overall Performance page of the Power BI dashboard offers a consolidated snapshot of sales performance metrics across r e-commerce platforms.

Power BI Dashboard for Multi-Platform E-Commerce Sales Analysis

The Overview page provides a detailed summary of sales performance across Amazon, Flipkart, and Meesho for each brand.

Project Details

A robust data visualization tool developed using Power BI, designed to streamline and consolidate sales analysis across major e-commerce platforms: Amazon, Flipkart, and Meesho. This dashboard provides a comprehensive overview of sales performance, operational costs, and profitability for different brands, each offering multiple unique products.
Features:
1. Platform-Specific Summaries:
Provides detailed metrics for each platform, including net quantity, net sales, gross settlement, ad costs, and net settlement
Breaks down performance across platforms.
2. Sales Trends Over Time:
Visualizes net payout and sales performance over fiscal years, months, and quarters.
Highlights revenue fluctuations and platform-specific contributions.

Live Interactive Dashboard

PowerBI Project

Election Analysis

This project contains an analysis of the Indian General Elections using Power BI. The study aims to explore various aspects of the elections, including voter demographics, voting trends, and election results.

View Project
Engagement

View Project
on GitHUB

Election Analysis

The vote distribution of a political party in an election does not necessarily determine the number of seats won. A party could receive a significant

Election Analysis

The BJP secured more than the majority margin of 272 seats in the 2014 and 2019 elections. In contrast, the trailing party, Congress, failed to

Project Details

Election Analysis:
A comprehensive study of the Indian General Elections using Power BI and Python.

This project dives deep into various aspects of the elections, such as voter demographics, voting trends, and results. The interactive Power BI dashboard offers insightful visualizations to explore the data deeply.
Key Insights:
Vote Distribution vs. Seats Won: A political party's vote share doesn't always translate into a proportionate number of seats.
Party Performance: The BJP's dominance in 2014 and 2019, and the resurgence of the Congress in 2024.

📊 Data Sources:
- Election Commission of India
- Wikipedia
- Other media sites

Tools Used:
- Python: Web scraping.
- Power BI: Data processing, creating interactive visualizations and dashboards.

Live Interactive Dashboard

PowerBI Project

Business Insight 360

Atliq is a hardware manufacturing company and it sells goods to different customers such as Croma, Best Buy, Staples, Flipkart and so on. These customers sell those goods to end consumers through online (E-commerce) as well as offline stores (Brick and Mortar). While their business grows substantial

View Project
on GitHUB

Business Insight 360

This executive view contains the overall summary of the performance of the Atliq hardware across the globe.

Business Insight 360

The Marketing view dashboard has the dynamics to visualise the marketing performance of the Atliq hardware products.

Project Details

The project highlights the profit and loss statement of the Atliq hardware across the globe.

Live Interactive Dashboard

PowerBI Project

IPL Insights

The sports blog company "Sports Basics" decided to release a special edition magazine on behalf of IPL 2024. To appease the audience, this magazine aims to generate interesting insights and facts from the last 3 seasons of IPL data.

View Project
on GitHUB

This dashboard is specifically used to analyse the performance of each player.

The top players as well as the teams are selected according to the statistics of the 3 seasons.

Project Details

Dashboard Link: https://app.powerbi.com/groups/me/reports/54306c8a-b3e7-4c46-8d92-84d640dee1a6/ReportSection4adb8e78e74a039522ae?experience=power-bi

Live Interactive Dashboard