Portfolio - Ankita | Codebasics

Hello, I am

Ankita

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Hello! I'm Ankita, a data enthusiast passionate about turning numbers into stories that drive smart decisions. I'm on the lookout for roles that challenge me and let me make a meaningful contribution.

Why choose me?
I'm all about practical data insights. With Excel, SQL, and Power BI, I turn data into actionable information.

What makes me special?
I easily fit into teams with my adaptability and strong analytical skills, making a quick and positive impact. Let's connect and bring data to life together!

Key

Skills

sql

effective communication

data analytics

My

Projects

Vrinda Sales Annual Report

vrinda store wants to create an annual sales report. So that, the stakeholders can understand their customers and grow more sales in the upcoming year.

Credit Card Financial Dashboard

Designed to empower stakeholders with real-time visibility into credit card transactions and financial insights. This dashboard ensures effective decision-making and strategic planning.

Awards

& Certificate

Agile Methodologies

Contact Me

Email

[email protected]

Github

https://github.com/AnkitaShanker

https://www.linkedin.com/in/ankita-02928a20a/

Call

+91 9318317457

Ankita

Data Aspirant

Download Resume

Resume

Excel Project

Vrinda Sales Annual Report

vrinda store wants to create an annual sales report. So that, the stakeholders can understand their customers and grow more sales in the upcoming year.

I conducted fundamental data cleaning and introduced two additional columns, "Age Group" and "Month," to enhance data interpretation and analysis.

This report has slicers enabled so that the stakeholders can understand the report easily enabling them to grow and make informed decisions.

Project Details

in this project, I developed an Excel-based sales report and dashboard project aimed at enhancing business understanding and identifying expansion opportunities. Leveraging comprehensive data analysis, the project generates actionable insights and recommendations. The reports facilitate optimized sales strategies, heightened customer satisfaction, and revenue maximization. By providing a holistic view of customer behavior and market trends, the project empowers Vrinda Store to make informed decisions, capitalize on growth avenues, and maintain a competitive edge in the marketplace.

I have learned the following:

1. Pivot table
2. Pivot Chart
3. Data Cleaning
4. Data Processing
5. Data Analysis
6. Data Beautification
7. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, and drive growth.

PowerBI Project

Credit Card Financial Dashboard

Designed to empower stakeholders with real-time visibility into credit card transactions and financial insights. This dashboard ensures effective decision-making and strategic planning.

View Project
Engagement

View Project
on GitHUB

💡Insights: - Total Interest is 7.8M - Male customers are contributing more in revenue which is 30 M and Female 25 M. -Most users are graduates.

Insights: - Overall revenue is 55M - Total transaction amount is 45M - Blue and Silver credit cards contribute 52M of overall transaction revenue.

Project Details

Introducing the Credit Card Financial Dashboard project using Power BI designed to empower stakeholders with real-time visibility into credit card transactions and financial insights. This dashboard ensures effective decision-making and strategic planning.

🔎Project Objective: To develop a comprehensive credit card weekly dashboard that provides real-time insights into key performance metrics and trends, enabling stakeholders to monitor and analyze credit card operations effectively.

📊Steps:
1. Data import from PostgreSQL
2. Data cleaning/processing & DAX
3. Dashboard & Insights

Hello, I am

Ankita

1

1

About

Key

My

Vrinda Sales Annual Report

Credit Card Financial Dashboard

Awards

Contact Me

Email

Github

Linkedin

Call

Ankita

Download Resume