Portfolio - Rita Mahato | Codebasics

Powered by
Codebasics DA Bootcamp

Rita Mahato

Data Aspirant

EMAIL

[email protected]

PHONE

+91 7044689553

Download CV

About Me

“I turn data into clear stories that help drive better decisions.”

Hi, I’m an aspiring Data Analyst who enjoys working with Excel, Power BI, SQL, and Python to uncover patterns, solve problems, and share insights in a simple way.

I hold a Bachelor’s degree in Information Technology and began my career as a developer. Along the way, I discovered my passion for data—digging into numbers, finding meaning, and presenting it visually so it makes sense to everyone.

In my portfolio below, you’ll find projects based on real business problems, showing how I analyze data, build dashboards, and deliver results. I’m excited to grow further as a data analyst and contribute to impactful, data-driven decisions.

1

Excel Project

1

PowerBI Project

1

Python Project

Key Skills

SQL

Python

matplotlib

Pandas

Seaborn

Power BI

Tableau

Spreadsheet

My Projects

My Experience

Technical Analyst 2010-2014

Cognizant Technology Solutions Ltd. Kolkata, India

.Analyzed data accuracy by 15%+ and reduced errors in health insurance reporting.

Collaborated with stakeholders, defined reporting needs, and accelerated delivery timelines by 20%.

Senior Software Engineer 2007 - 2009

iGate Global Solutions Ltd (Currently Capgemini) Hyderabad, India

Data Quality Management (Retail Domain, Infor Enterprise Collaboration Product) .

Performed data validation and analysis using Oracle SQL and Excel, reducing discrepancies and improving accuracy of unique product data across retail databases

Awards & Certificate

Deloitte Australia - Data Analytics Job Simulation

Deloitte Australia - Data Analytics Job Simulation

Comcast - Unspoken Interview Fundamentals Job Simulation

Comcast - Unspoken Interview Fundamentals Job Simulation

Excel: Mother of Business Intelligence

Excel: Mother of Business Intelligence

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

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

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 7044689553

LinkedIn

https://www.linkedin.com/in/mahato-rita/

GitHub

https://github.com/Rita-Mahato-2025

Excel Project

Sales Analytics(FMCG)

Domain/Function: FMCG

Developed two detailed reports for the sales team, enabling them to evaluate customer performance more effectively and assess overall market performance in comparison to their set targets, supporting data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

Sales Analytics(FMCG)

Customer Performance Report: Shows each customer's net sales trends and year-over-year performance at a glance.

Sales Analytics(FMCG)

Market vs Target Report: Tracks yearly market performance against targets, helping stakeholders evaluate progress and gaps.

Project Details

Project Summary:
In this project, I designed a comprehensive sales report in Excel using Pivot Tables to help businesses make data-driven decisions. The report supports determining optimal customer discounts, strengthening consumer negotiations, and identifying potential expansion opportunities in high-growth markets.

The insights generated from the report provide actionable recommendations that enable businesses to refine sales strategies, improve customer satisfaction, and maximize revenue.

Key Learnings & Skills Acquired:

Pivot Tables

Power Query

Basic DAX

Conditional Formatting

Report Design & Visualization

Sales Domain Metrics

Outcome:
This project highlights how sales data analysis can empower organizations to track performance, evaluate market opportunities, and enhance sales efficiency. By leveraging these insights, businesses can uncover growth opportunities, stay competitive, and drive sustainable success.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: FMCG

My goal is to implement an advanced Power BI analytics solution at AtliQ Hardwares, transforming Excel-based reports into interactive dashboards to drive insights and enable data-driven decision-making for better competitiveness.

View Project
Engagement

View Project
on GitHUB

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Data modeling involving 15+ tables

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User-empathetic landing page as a part of dashboard design

Project Details

Project Goal:

Create a single Power BI report usable by stakeholders across Sales, Marketing, Finance, and the Executive team.

Focus on:

Robust Data Modeling

User-empathetic Report Design

Drillable Insights

What I Learned:

Power Query (Basic & Advanced Operations)

Basic & Complex DAX formulas

Data Modeling across 10+ tables

Choosing the right visuals & formatting

Dashboard Design Principles

Using Bookmarks

Deploying in Power BI Service

Implementing Stakeholder Feedback

Metrics across Sales, Marketing, Finance & Supply Chain

Live Interactive Dashboard

Python Project

Diwali Sales Analysis

Domain/Function: Retail & E commerce

This Python capstone project showcases the application of data manipulation, visualization, automation, and problem-solving. It delivers a real-world solution through an end-to-end data analysis workflow, highlighting practical skills and analytical thinking.

View Project
on GitHUB

Diwali Sales Analysis

From above graphs, we can see that most of the buyers are working in IT Sector, Healthcare and Aviation.

Diwali Sales Analysis

From the above two graphs, we can see that most of the orders and total sales/ amount are from Uttar Pradesh, Maharashtra and Karnataka respectively

Project Details

Diwali Sales Analysis – Python Capstone Project

This Python capstone project marks the culmination of skills gained throughout the course by integrating data manipulation, visualization, automation, and problem-solving into a complete analysis workflow. The focus is on analyzing Diwali sales data to uncover customer buying behavior, festive spending patterns, and top-performing product categories, highlighting both analytical thinking and business relevance.

Objective:

Apply Python programming to solve a real-world business problem.

Generate actionable insights from retail sales data.

Strengthen knowledge of key libraries (Pandas, NumPy, Matplotlib, Seaborn).

Improve coding practices and showcase the ability to design, implement, and present an end-to-end solution.