Portfolio - Krishna Mahajan

Krishna Mahajan

Data Analyst

Resume

1

PowerBI Project

1

Excel Project

1

SQL Project

About Me

Hi, I’m an aspiring Data Analyst with a strong passion for turning raw data into meaningful insights. I hold a bachelor’s degree in Data Science, but it was through hands-on projects that I truly discovered my love for data analysis.
I’m skilled in tools like Excel, Power BI, SQL, and Python — and I use them to explore trends, solve problems, and tell stories with data. While I haven’t worked in a company yet, I’ve completed several real-world business projects, which you can explore in my portfolio below.
Each project helped me learn how data drives better decisions, and I’m excited to bring that mindset into a professional role. I’m now looking for opportunities where I can grow, contribute, and help businesses use data more effectively.

Key Skills

Excel

Power BI

Python

SQL

Microsoft Azure (Data & Fabric Workspace)

Tableau

My Projects

Hospitality Management

Domain/Function: Hospitality Domain

Academy Student Learning & Engagement Analysis

Domain/Function: Educational Data Analysis / Google sheet/Excel-Based Reporting

Zepto Product & Inventory Data Analysis

Domain/Function: Business Reporting, Inventory Management

Sign Language Translator for Hearing and Speech Impaired

Domain/Function: Computer Vision, Human-Computer Interaction

My Experience

- At Feynn Labs, I played a pivotal role in driving data-informed decision-making through comprehensive analytics and research initiatives. Developing Analytics Solutions :- Created advanced data analytics tools that helped clients uncover insights and predict market trends, significantly enhancing their strategic planning. Collaboration Across Teams-: Partnered with cross-functional teams to integrate data insights into various projects, ensuring alignment with business goals.

Awards & Certificate

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

SQL Beginner to Advanced For Data Professionals

Data Analytics - ICT Academy ( Infosys Foundation Finishing School for Employability Program)

Microsoft Certified: Power BI Data Analyst Associate

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/krishnamahajan2/

Call Me

+91 9301909822

GitHub

http://github.com/krishnx27

PowerBI Project

Hospitality Management

Domain/Function: Hospitality Domain

To reverse AtliQ Grands' decline, I built two dashboards (Executive and KPI View) showing market share, revenue trends, booking patterns, and key KPIs. Through data analysis, I identified top hotel (320M) ,leading city(Mumbai:670M)

The first image shows comprehensive hotel revenue dashboard focusing on key metrics like revenue, RevPAR, DSR, occupancy, and ADR for different hotel

The second image depicts a hotel booking data model, illustrating the relationship between tables such as data analysis for optimizing hotel operation

Project Details

Facing market share and revenue decline, AtliQ Grands lacked an in-house data analytics team and required insights from historical
data to regain the competitive edge in the luxury/business hotel market in 4 different cities.
Crafted dashboards, created metrics, and delivered additional insights to support strategic decision-making.
Designed 2 dashboards (Executive View, KPI View) displaying market share, revenue trends, booking patterns, and key KPIs for
management.
Identified top-performing hotel (AtliQ Exotica: $320M), city (Mumbai: $670M), and hotel occupancy leader (AtliQ Blu:62.02%)

Live Interactive Dashboard

Excel Project

Academy Student Learning & Engagement Analysis

Domain/Function: Educational Data Analysis / Google sheet/Excel-Based Reporting

Analyzed over 138,000 student records from State ABC to uncover key insights into student engagement on the Khan Academy platform. Created automated formulas and pivot tables to identify learning behavior, school-level participation, and data quality issues.

View Project
on GitHUB

View Project
on Microsoft Excel

Other Tools

Microsoft Excel

Pivot Table

Data Cleaning & Text Functions

Data Validation & Manual Checks

Google sheet

Analyzed 138K+ records using Excel to uncover insights on student engagement, proficiency, and data quality on Khan Academy.

District_8 student data showing skill activity, time spent, and engagement levels using Excel logic columns like “>30 sec”, “No Level Up”, and “Missin

Project Details

This project analyzed over 138,000 student records from State ABC using Excel and Google Sheets to explore learning engagement on Khan Academy. I created pivot tables and formulas to find how many students never worked on skills, how many schools had very low activity, and which blocks had the lowest average learning time. The analysis also measured average proficiency in District_8 and checked data quality in grade entries. Insights will help improve student support and data standards.

SQL Project

Zepto Product & Inventory Data Analysis

Domain/Function: Business Reporting, Inventory Management

A comprehensive SQL-based project that analyzes Zepto’s product data to identify top discounts, stock status, revenue by category, and product value. This helps optimize inventory, pricing, and promotional strategies.

View Project
on GitHUB

View Project
on PostgreSQL

Other Tools

Excel

PostgreSQL

Analyzes Zepto product data: creates table, explores data, counts rows, samples records, and checks for null values for business insights.

Analyzed Zepto product data Size 3353 approx to explore pricing, discounts, and availability trends using PostgreSQL and SQL for actionable insights.

Project Details

This project leverages SQL queries to analyze Zepto’s product and inventory data. It identifies high-discount deals, out-of-stock premium products, revenue contributions by category, and product value metrics like price per gram. The insights gained support strategic decisions on stock replenishment, pricing optimization, and targeted promotions, ultimately driving business growth.

Sign Language Translator for Hearing and Speech Impaired

Domain/Function: Computer Vision, Human-Computer Interaction

Sign Language Translator that helps hearing-impaired users communicate through gestures, converting them into real-time text and speech using MobileNet and KNN. Features gesture recording, model saving/loading, tutorials, and practice modules.

View Project
on GitHUB

View Project
on HTML , Java Script

Other Tools

HTML/CSS/JS

Deep Learning

TensorFlow.js

SpeechSynthesis API

This page shows you the desktop page and the interface of this model.

This page shows you all used items, files and folder.

Project Details

This project enables individuals with hearing and speech impairments to communicate effectively using sign language. Users can train the model by recording their own gestures, which are classified using MobileNet and a KNN classifier. The app supports live translation from gestures to text and speech. It includes the ability to save and upload models, practice sign gestures against a deep learning model, and access a tutorial section with over 100 frequently used phrases and alphabets. Built for web platforms using TensorFlow.js and web APIs, this solution empowers real-time sign-to-speech communication.