Data Analyst

DIPALI MENDHE

**********@*****.*** +91-928******* www.linkedin.com/in/dipali-mendhe-1b/

PROFILE SUMMARY

To be associated with a progressive organization that gives me the scope to apply my knowledge and skills

& involve me. As a part of team and to develop myself professionally and personally in a long term respectively.

EDUCATION

Vidyabharti Mahavidyalaya, Amravati 2022 - 2024

Master of computer Application CGPA: 7.81

Mahatma Fule Mahavidyalaya, Warud

B.Sc(Computer Science) 78.40%

2019 - 2022

PROJECT

1. Amazon Dashboard Creation

Tools: Power BI, MySQL, Excel

To develop a comprehensive and interactive business intelligence dashboard using Power BI. This dashboard is to visualize and analyze key performance metrics and trends for Amazon’s business operation. Responsibilities:

Created interactive and visually appealing dashboards using Power BI to track sales performance, customer satisfaction, inventory levels.

Optimized the performance of the dashboard to the dashboards to the handle large datasets and ensure quick data retrievel and visualization.

Prepare the data by removing duplicates, handling missing values, and correcting inconsistencies.

Use Power Query in Power BI to transform the data, such as normalizing sales data across different marketplaces or calculating additional metrics.

Use Pie chart, Donut chart, Clustered bar chart and Map to show sales trends overtime. A clustered bar chart showing the current loss or profit product. 2. Enhancing Sales performance Data Analysis and Dashboard Creation with Excel To develop dynamic Excel dashboards to visualize sales performance metrics such as revenue, growth rates, regional sales, and sales team performance.

Responsibilities:

In this data analysis project, our objective is to create an annual sales report by cleaning, processing, analyzing data and creating a dashboard in Excel.

Using formulas, pivot tables, and other Excel function to perform complex calculations, such as growth rates, moving averages, and performance ratios.

Incorporating interactive elements like slicers, drop-down menus, and buttons to allow user to filter and explore the data dynamically.

The goal is to find insights, understand our customer, and facilitate sales growth in the next year. We will be reporting on gender, state, channel, age, group, orders, and sales. TECHENICAL SKILLS

Programming Languages: Python, MySQL.

Data Visualization Tool: Power BI Excel.

Analytical Skill: Data mining, Data cleaning, Problem solving.

Proficient in Ms Office

CERTIFICATIONS

Certification of Excel Dashboard For Data Analytics

Certification of Microsoft Power BI

Contact this candidate