Portfolio - Abhinav Sharma

Hello, I am

Abhinav Sharma

Data Analyst

Resume

1

Python
Project

2

PowerBI
Projects

About

My academic journey has been geared towards becoming a well-rounded business professional. I obtained a Bachelor of Business Administration (BBA) degree, which provided me with a solid foundation in core business principles like marketing, finance, and accounting. Now, I'm pursuing a Master of Business Administration (MBA) with a focus on business analytics at Chandigarh University. This program is deepening my understanding of data analysis techniques and their application to real-world business problems.

However, during my studies, I've been captivated by the emerging field of Machine Learning. What truly fascinates me is its ability to extract valuable insights from vast amounts of data.

Key

Skills

SQL

Python

Excel

PowerBI

Google Sheets

My

Projects

BRICS Decoded: A Python Analysis of Population, GDP, Growth & More.

My recent project analyzing the economic landscape of the BRICS nations! Using Python's libraries (Pandas & NumPy) and the interactive visualization capabilities of Plotly
1. GDP & Growth Rate
2. Population and Inflayion
3. FDI

Atliq Business Dashboard

Project Details The objective of this project is to create a unified report that stakeholders from the sales, marketing, finance, and executive teams can utilize effectively

CRM Dashboard

Domain/Function: Marketing Performance Analysis

This dashboard is designed to offer a comprehensive view of sales, marketing, and customer engagement metrics, supporting data-driven decisions across business functions

My

Experience

From January to July 2024, I worked as a Data Analyst Intern where I honed my skills in SQL, data analysis, and Power BI dashboard creation. During my internship from January to June 2024, I performed in-depth customer data analysis using SQL functions and CTEs, identifying repeat customer behavior and improving retention by 20%. I also developed a Power BI dashboard to track key customer metrics, leading to a 25% increase in lead retention.

In June and July 2024, I further expanded my expertise in data variance analysis and debugging SQL queries to ensure data accuracy. I applied advanced data cleaning techniques and designed customizable dashboards, enhancing decision-making processes through precise and actionable insights.

Awards

& Certificate

Excel: Mother of Business Intelligence

Python: Beginner to Advanced For Data Professionals

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

SQL Beginner to Advanced For Data Professionals

Contact Me

Email

[email protected]

Github

https://github.com/abhinav-Katiyan

https://www.linkedin.com/in/abhinav-sharma-work21/

Abhinav Sharma

Data Analyst

Download Resume

Resume

Python Project

BRICS Decoded: A Python Analysis of Population, GDP, Growth & More.

My recent project analyzing the economic landscape of the BRICS nations! Using Python's libraries (Pandas & NumPy) and the interactive visualization capabilities of Plotly 1. GDP & Growth Rate 2. Population and Inflayion 3. FDI

View Project
Engagement

View Project
on GitHUB

Analyzing Migration Patterns in BRICS Nations

Analyzing Foreign Direct Investment of Countries like USA, India , China and more

Project Details

BRICS Analysis with Python: Unveiling Economic Trends
This project explored the economic landscape of the BRICS nations (Brazil, Russia, India, China, and South Africa) by leveraging the power of Python. We utilized Pandas and NumPy for data manipulation and analysis, while Plotly's visualization capabilities brought the insights to life. The analysis focused on several key economic indicators:
1 Population: We examined the demographic weight of the BRICS nations, exploring their population size and growth rates.
2 GDP & Growth Rate: We unpacked the economic power of each BRICS nation by analyzing their Gross Domestic Product (GDP) and GDP growth rates.
3 Inflation: Inflation levels were investigated to gauge price stability within the BRICS economies.
4 Foreign Direct Investment (FDI): We analyzed the flow of Foreign Direct Investment (FDI) into the BRICS nations. FDI represents investments from foreign entities into a country's productive capacity.

PowerBI Project

Atliq Business Dashboard

Project Details The objective of this project is to create a unified report that stakeholders from the sales, marketing, finance, and executive teams can utilize effectively

View Project
Engagement

View Project
on GitHUB

Metrics for sales, marketing, finances, and supply chain

Power Query (Basic and Advanced Operations)

Project Details

AtliQ Hardwares, a fast-growing consumer electronics company, is struggling to compete with other businesses due to its reliance on Excel for the majority of its reports. To help the company gain valuable insights and make informed decisions, I plan to create an advanced analytics dashboard using PowerBI.

Live Interactive Dashboard

PowerBI Project

CRM Dashboard

Domain/Function: Marketing Performance Analysis

This dashboard is designed to offer a comprehensive view of sales, marketing, and customer engagement metrics, supporting data-driven decisions across business functions

View Project
Engagement

Other Tools

Excel

This Page shows Key KPIs like Lead Conversion Rate, Customer Acquisition Cost, and Marketing ROI help gauge campaign effectiveness and sales efficienc

This page displays key KPIs like Lead Conversion Rate, Customer Acquisition Cost, Marketing ROI, along with a map view, customer acquisition rate, and

Project Details

The dashboard offers critical insights into sales, marketing, and customer engagement to drive data-informed business strategies. Key features include:
Leads, Sales, and Call Data Integration: Seamless tracking of the entire customer journey from lead generation to sales conversion.
Product-Based Insights: Analysis across multiple platforms like Facebook, Google, and Twitter to understand marketing effectiveness.
Sales Performance Leaderboard: Highlights top-performing salespersons based on lead conversions and call performance.
KPIs Tracked:
1.Lead Conversion Rate (LCR).
2.Lead to Opportunity Rate
3.Customer Acquisition Cost (CAC)
4.Lead Conversion Time (LCT)
5.Opportunity to Win Rate

Hello, I am

Abhinav Sharma

1

2

About

Key

My

BRICS Decoded: A Python Analysis of Population, GDP, Growth & More.

Atliq Business Dashboard

CRM Dashboard

My

Awards

Contact Me

Email

Github

Linkedin

Abhinav Sharma

Download Resume