Powered by
Codebasics DA Bootcamp

Mayuri Desai

Data Aspirant

+91 9561710146 [email protected]

Resume

Hello, I am

Mayuri Desai.

1

Excel Project

1

PowerBI Project

About Me

I am an aspiring Data Analyst with a background in Computer Science and two and half years of hands-on experience as a Testing Engineer. During my time in the technical field, I discovered a passion for transforming raw data into actionable insights. I specialize in using tools like Excel, Power BI, and SQL to analyze data and support informed business decisions. In addition to my technical experience, I have successfully completed business projects showcased in my portfolio below, demonstrating my ability to deliver real-world data solutions. I'm driven by curiosity and a desire to continuously learn, and I’m eager to apply my analytical skills to help organizations make data-driven decisions.

Key Skills

sql

data analysis

databases

excel

mysql

power bi

data modelling

data cleaning

My Projects

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/mayuri-desai-340973285/

+ 91 9561710146

Excel Project

Sales Analytics(FMCG)

Domain/Function: Revenue

Created two reports for the sales team to assess customer performance and track market progress against their targets, helping them align efforts with business goals.

View Project
Engagement

Sales Analytics(FMCG)

Customer Performance Report: Provides net sales performance of each customer across years

Sales Analytics(FMCG)

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

Developed a comprehensive sales report using Excel pivot tables, designed to help businesses make data-driven decisions.
The report enables companies to determine effective customer discount strategies, improve negotiations with consumers, and identify potential expansion opportunities in high-growth countries. The insights provided by the report allow businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

Key Skills and Tools Learned:
1.Pivot Tables
2.Power Query
3.DAX
4.Conditional Formatting
5.Report Beautification
6.Sales Domain Metrics

This project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities.
By leveraging sales data analysis, businesses can:
Optimize Customer Discounts,Facilitate Consumer Negotiations,Identify Market Expansion Opportunities.
The sales report provides actionable insights and data-driven recommend

PowerBI Project

Business Insight 360 BI Dashboard For Finance, Sales, Marketing, Supply-Chain, Excecutive

Domain/Function: Business Insight 360

AtliQ Hardware, a rapidly expanding consumer electronics company, faces challenges in staying competitive due to its current reliance on Excel for reporting. Goal is to introduce Power BI to deliver advanced analytics capabilities, enabling deeper insights and supporting data-driven decision-making

View Project
Engagement

Business Insight 360 BI Dashboard For Finance, Sales, Marketing, Supply-Chain, Excecutive

A quick, insightful dashboard for the finance team

Business Insight 360 BI Dashboard For Finance, Sales, Marketing, Supply-Chain, Excecutive

A quick, insightful dashboard for the executive team

Project Details

The purpose of this project is to provide a BI dashboard for stakeholders from sales, finance, marketing, supply chain, and the executive team. The focus is on the following:

1.Building a robust and efficient data model
2.Designing reports with a user-centered approach
3.Providing insights with drill-down capabilities

Key Learnings from the Project:

1.Data Modeling
2.Dashboard Design Principles
3.DAX (Data Analysis Expressions)
4.Data Cleaning
5.Bookmarking
6.Stakeholder Feedback Implementation
7.Cross-functional Metrics
8.Power Query

Live Interactive Dashboard