Powered by
Codebasics DA Bootcamp

Ramesh Ranjan

Data Aspirant

+91 07004332106 [email protected]

Resume

Hello, I am

Ramesh Ranjan.

1

Excel Project

4

PowerBI Projects

About Me

I’m an aspiring Data Analyst with hands-on experience in tools like Excel, Power BI, SQL, and Python. Currently pursuing a degree in Computer Science with a specialization in Data Analytics at IIT-Patna, I’ve chosen this field not only because it aligns with my studies, but also because I genuinely enjoy working with data and finding actionable insights.

Although I haven’t worked in a company yet, I’ve built several real-world business projects—including a complete Power BI dashboard that visualizes and interprets key business metrics. These projects reflect my ability to analyze data, solve problems, and present insights in a clear, meaningful way.

I’m eager to bring my skills, passion, and curiosity to a dynamic team where I can grow and contribute as a data-driven decision maker. Feel free to explore my work below!

Key Skills

Excel

PowerBi

Python

SQL

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

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

+ 91 07004332106

https://github.com/ramesh2026

Excel Project

Sales and Finance Analytics

Domain/Function: Data Analysis

Created 2 reports for the Sales department which will help in evaluating Customer Performance and understand their Market Performance with respect to their targets.

View Project
Engagement

View Project
on GitHUB

Sales and Finance Analytics

Market Performance vs Target Report

Sales and Finance Analytics

Customer Performance Report

Project Details

The Customer Performance Report empowers businesses to delve into their sales data and extract valuable insights for strategic decision-making. Utilizing advanced
Excel techniques, including DAX formulas and Pivot tables, combined with Power Query for data manipulation, the report provides a comprehensive overview of
customer performance metrics. From determining effective customer discounts to facilitating negotiations and identifying expansion opportunities, this report equips
stakeholders with actionable insights.
I have learned the following:
1. Advanced Excel functionalities: DAX formulas, Pivot Tables, Conditional Formatting.
2. Power Query for data transformation and cleaning.
3. Comprehensive knowledge on Sales Domain Metrics.
4. Report Beautification
By leveraging this tool, businesses can optimize their customer relationships, drive sales growth, and make informed decisions to stay ahead in today's competitive
market

PowerBI Project

Business Insights 360

Domain/Function: Data Analysis

Implementing Power Bl for AtliQ Hardware enables advanced analytics, transforming Excel data into actionable insights for informed decision-making, empowering rapid expansion and competitive edge in the consumer electronics market.

Business Insights 360

Home Page

Business Insights 360

Data Modelling

Project Details

In this project, the goal is to develop one dashboard which could be used by Stakeholders from Sales, Marketing, Finance and Executives team. The project is made on
the following:
1. Adaptive Data Modelling
2. User-centric Report Design
3. Drillable Insights
I learned the following concepts in this project:
1. Power Query (Basics and Advanced Operations)
2. Basic and complex DAX formulas
3. Data Modelling involving 11+ tables
4. Selection of rights visuals and formatting
5. Dashboard designing principles
6. Using Bookmarks and Selections
7. Deploying project in Power Bl Service
8. Stakeholder Management
9. Sales, Finance, Marketing & Supply Chain metrics

Live Interactive Dashboard

PowerBI Project

Hospitality Domain

Domain/Function: Data Analysis

Created a Dashboard for the Revenue team of AtliQ Hotels to analyze their position in the Industry and help regain their Market Share and Revenue by providing them with the relevant insights about their hotels business

Hospitality Domain

Executive dashboard

Hospitality Domain

Data Model for RPC-I

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.
1. Star Schema Data modelling
2. User-Centric Report Design
3. Drillable Insights
4. KPI View for Cancellation % and Revenue trends
I learned the following concepts in this project:
1. Formulating DAX measure, columns
2. Generating calculated columns
3. Excelling in Data Modelling
4. Applying conditional formatting for more impact
5. Utilizing Heatmaps for total booking by different platforms
6. Selection of rights visuals and formatting
7. Publishing and sharing reports via Power Bl Service
8. Hospitality Domain metric(ADR, RevPAR, DSRN, SRN, Cancellation %, more)

Live Interactive Dashboard

PowerBI Project

EdTech Analytics

Domain/Function: Data Analysis

Developed an interactive EdTech Analytics Dashboard using Power BI & Excel to uncover trends in viewer behavior, course engagement, and content performance—empowering data-driven decisions in the online learning space.

EdTech Analytics

dashboard-1

EdTech Analytics

dashboard-2

Project Details

Designed a comprehensive EdTech Analytics Dashboard using Power BI and Excel to help stakeholders understand key learning trends. The dashboard visualized insights from course data, including average views by category and language, subtitle usage impact, top-rated instructors, and the relationship between course duration and viewership. These insights enabled strategic content decisions, optimized course offerings, and improved learner engagement. The project emphasized interactivity, clarity, and usability, making it a valuable tool for enhancing performance in the EdTech industry.

Live Interactive Dashboard

PowerBI Project

Adidas Performance

Domain/Function: Data Analysis

Analyzed Adidas U.S. sales data to uncover retailer, regional, and product performance trends. Delivered insights to optimize marketing spend, improve product mix, and drive regional growth. Built an interactive Power BI dashboard for strategic decision-making.

View Project
Engagement

Adidas Performance

.

Adidas Performance

.

Project Details

In this project, I analyzed Adidas’s U.S. sales data using Power BI to uncover actionable insights for strategic decision-making. The dataset included transactions across multiple retailers, product categories, and regions. My analysis focused on identifying high-performing and underperforming areas, evaluating sales methods, and understanding regional and gender-based profit trends. Key insights revealed over-reliance on specific retailers, growth potential in online sales, and regional imbalances in profitability. I visualized these findings through an interactive dashboard that enabled dynamic filtering by region, product category, and sales channel. The project delivers clear recommendations to optimize the product mix, reallocate marketing budgets, and target region-specific growth opportunities. This end-to-end analysis demonstrates the power of data storytelling and business intelligence tools in driving smarter, data-informed decisions.

Live Interactive Dashboard