Portfolio - Aadith Prakash

Aadith Prakash

Data Aspirant

Resume

2

Excel Projects

2

PowerBI Projects

2

SQL Projects

1

Python Project

About Me

Hi there! Thank you for visiting my portfolio website.
I’m glad you’re here!
I’m Aadith Prakash, an aspiring Data Analyst with a passion for transforming messy, unstructured data into clear, actionable insights. I enjoy working with SQL, Excel, Power BI, and Python to uncover trends, build dashboards, and solve business problems.
On this website, you’ll find some of the projects I’ve worked on that showcase my skills in data cleaning, visualization, and storytelling. I am continuously learning and excited to grow in the field of data analytics.
Feel free to explore my work, and don’t hesitate to connect with me!

Key Skills

Power BI

Excel

SQL

Python

My Projects

P&L Report

Domain/Function: Sales analytics(FMCG)

P&L Report - Finance

Domain/Function: Finance Analytics(FMCG)

AtliQ- Business Insights--360

Domain/Function: Brick & mortar and ecommerce

AtliQ--Hospitality Analytics

Domain/Function: Hospitality

Consumer Goods Analytics – Resume project challenge #4

Domain/Function: Consumer goods

Inventory Optimization-Mint Classics

Domain/Function: Supply chain analytics

Hotel Domain Analysis Using Python

Domain/Function: Hospitality

My Experience

Data Analyst Intern-RP2 India Pvt ltd

Feb 2025-June 2025

Utilized Power BI to design interactive dashboards and visual reports for data-driven decision making in. Helped AtliQ grands working in hospitality domain to to track revenue trends, aiding in Strategic planning for market share recovery and revenue growth

Worked with large, complex retail datasets to extract, clean, and analyze data using SQL, enabling the discovery of key business insights.

Utilized Excel for advanced data cleaning and analysis, and built multiple interactive dashboards for the World Happiness Report project to visualize key global insights like the no of country who stands above the average happiness score and the happiest country along with the correlation between various factors like GDP per capita, Social support, health and freedom

Learned key statistical concepts and presented insights on their relevance to data analysis.

Awards & Certificate

Excel: Mother of Business Intelligence

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

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/aadith-prakash-0b9424242/

Call Me

+91 8547377553

GitHub

https://github.com/Aadithhub

Excel Project

P&L Report

Domain/Function: Sales analytics(FMCG)

Generated an extensive Profit and Loss (P&L) report for AtliQ hardware , using advanced excel features like Dax and Pivot tables for in-depth analysis.

View Project
on GitHUB

Shows sales performance by various customers in fiscal year 2018,2019 and also the percentage growth from 2020 to 2021

Shows target vs actual values and percentage change for various customer in fiscal year 2021

Project Details

Sales Analytics
Created a Customer performance report
Conduct a comprehensive comparison between market performance and sales target
Determined effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries.

In this project i have learned the following :
1.Pivot table
2.Power Query
3.DAX (Basics)
4.Conditional Formatting
5.Report Beautification
6.Sales Domain Metrics

Overall this project aims to empower businesses to monitor and evaluate their sales activities and performance. By leveraging sales data analysis, business can unlock new opportunities, drive growth and stay competitive in the dynamic market landscape.

Excel Project

P&L Report - Finance

Domain/Function: Finance Analytics(FMCG)

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves creating Create Profit and Loss (P&L) reports by Fiscal Year & Months , Create Profit and Loss (P&L) reports by Markets.

View Project
on GitHUB

Shows gross margin and gross margin % for different markets

Shows all key finance metrics for different years and individual months

Project Details

In this project, I worked on building comprehensive Profit and Loss (P&L) reports using Excel. Evaluation of financial performance, support decision-making, and facilitate communication with stakeholders.
P&L by Fiscal Year and Months: This report provided a detailed breakdown of Net sales, COGS(Cost of goods sold), and gross margin trends over specific fiscal years and individual months and also net sales comparison between 2021 and 2020
P&L by Markets: This analysis segmented financial performance across different geographical or business markets to help identify high-performing regions and areas requiring attention.
Throughout this project, I have acquired expertise in the following areas:
1. Utilizing pivot tables
2. Harnessing the capabilities of Power Query
3. Grasping the fundamentals of DAX (Data Analysis Expressions)
4. Enhancing data presentation through conditional formatting
5. Improving the visual appeal of reports
6. Gaining insights into finance-related metrics

PowerBI Project

AtliQ- Business Insights--360

Domain/Function: Brick & mortar and ecommerce

AtliQ Hardware faced challenges managing data within Excel. Objective: Shift from Excel to Power BI for better comprehension. Goal: Achieve insights into finance, sales, and supply chain areas. Data Volume: 1.8 million entries. Tools Used: SQL, Power BI, DAX Studio

Designing a landing page that connects with users, making it an essential part of our dashboard.

Data Modelling involving 10+ tables

Project Details

This project, which combines Power BI, SQL, and Excel, centers around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. The company's heavy reliance on Excel for data analysis has led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.
💼Finance View: shows profit and loss statement like GM,NP,NS etc. and performance over time chart w.r.t to key metrices.
📣Sales View: Shows customers and product performance , unit economics and performance matrix by NS and GM%
📣 Marketing View: Shows region and product performance , unit economics and performance matrix by NS and GM%
🚚 Supply Chain View: shows forecast accuracy, Net Error, trends and key metrices by customers and product.
👨‍🎓 Executive View: shows market share of competitors, trends, revenue by division and channel, top 5 customer

Live Interactive Dashboard

PowerBI Project

AtliQ--Hospitality Analytics

Domain/Function: Hospitality

This project serves as a prime example of how data can bring about a significant transformation in the hospitality sector. It accomplishes this by delving into essential metrics like Revenue, ADR, RevPAR, Occupancy%, Realization%, Cancellation%.

Data Model

Dashboard view

Project Details

In this project, the goal is to develop one dashboard which could be used by the Revenue team of AtliQ Hotels for providing them with insights about their business. AtliQ Grands, renowned for its chain of five-star hotels across India, boasts a rich 20-year history in the hospitality sector. Nevertheless, they currently struggle with diminishing market share and revenue in the luxury and business hotel segment, attributed to competitive pressures and less effective management choices. In response to this challenge, the managing director of AtliQ Grands is embarking on a strategic initiative to integrate "Business and Data Intelligence" into their operations. The primary aim is to recapture market share and boost revenue.
I learned the following concepts in this project:
1. Formulating DAX measure, columns
2. Generating calculated columns
3.Excelling in Data Modelling
4.Selection of rights visuals and formatting
5.Publishing and sharing reports via Power BI Service

Live Interactive Dashboard

SQL Project

Consumer Goods Analytics – Resume project challenge #4

Domain/Function: Consumer goods

In this project, the goal is to execute the Ad-Hoc requests by writing SQL queries for each request & derive insights from the dataset given, which will be used by the management team of AtliQ Hardwares to make "Data-driven" decisions.

View Project
on GitHUB

Shows increase/decrease in product count for various segments

Gross sale contribution by channels

Project Details

In the "Consumer Goods Domain" project , I worked on database of Atliq Hardwares. Facing the challenge of data-informed decisions, I answered ten ad-hoc requests to extract actionable insights. Findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a flourishing 'Accessories' category. Sales seasonality and the pivotal role of the 'Retailer' channel were uncovered.
I learned the following concepts of SQL in this project:
1. SELECT, DISTINCT, WHERE clause
2. HAVING, GROUP BY, AND, IN
3. ORDER BY, LIMIT
4. Aggregation functions: MIN(), MAX(), AVG()
5. COUNT(), ROUND()
6. Alias in SQL
7. JOINS and its types
8. Subqueries
9. CTEs(Common Table Expressions)
10. Windows functions: RANK(), PARTITION BY

SQL Project

Inventory Optimization-Mint Classics

Domain/Function: Supply chain analytics

Analyzed warehouse and inventory data for Mint Classics, a retailer of classic model cars, using MySQL to recommend the closure of an underperforming warehouse. Identified excess stock, slow-moving products, and low-profit items to optimize storage without affecting customer service.

View Project
on GitHUB

Warehouse with least no of customers and which generates very less revenue

Warehouse with highest delayed shipments

Project Details

Analyzed warehouse and inventory data for Mint Classics to recommend the closure of an underperforming warehouse. Used MySQL to assess warehouse performance, product sales, inventory levels, and customer service timelines. Identified Warehouse D as the least efficient based on low stock, revenue, and customer reach. Found high excess stock and low-profit products in Warehouse B, recommending clearance to make space. Proposed closing Warehouse D and reorganizing Warehouse B without impacting 24-hour shipping targets. Developed SQL queries, CTEs, and stored procedures to automate analysis and support business decisions. Gained practical experience in supply chain and retail analytics.
The project enhanced my data analysis, problem-solving, and communication skills, contributing to my growth as a data analyst.

Python Project

Hotel Domain Analysis Using Python

Domain/Function: Hospitality

Atliq Grands encountered tough competition and a decline in revenue. They sought to utilize data and strategic insights but lacked internal expertise. My aim is to conduct a comprehensive analysis using Python to empower Atliq Grands with insights for customer retention and revenue growth.

View Project
on GitHUB

Average rating of different cities

Revenue contribution by various platforms

Project Details

In this project , I performed EDA using pandas to get insights. I performed the following operations:
1. Data Cleaning- Handling missing values and outliers.
2. Data Transformation - Added occupancy% columns.
3. Insights generation-key questions answered
#calculating average occupaancy rate by room type and city.
# Identifying occupancy rate on weekdays and weekends.
# Analyzing revenue generated per city.
# Analyzing monthly revenue trends.
# Assessing revenue by booking platforms.
My learnings include :-
1.Pandas-merge
2.Pandas-Group by
3.Pandas-Aggregate functions
4.Outlier removal using normal distribution
5.Insights generation using matplotlib and seaborn
6.Lambda function