I developed a comprehensive data visualization dashboard tailored for some of the top automotive companies, including Ford, Toyota, BMW, Audi, Volkswagen, Hyundai, and Skoda. The dashboard focuses on delivering critical insights through intuitive visualizations and interactive elements.

Key Features:

• Key Performance Indicators (KPIs):
• Average Price: Understanding pricing trends across brands.
• Mileage: Analyzing fuel efficiency.
• Miles Per Gallon (MPG): Assessing vehicle performance.
• Tax: Evaluating tax implications on different models.
• Visualizations:
• Donut Charts:
• Fuel Type by Count of Fuel Type
• Average Mileage by Transmission
• Horizontal Bar Chart: Transmission Count
• Area Chart: Average Price by Fuel Type
• Interactive Filters:
• Year
• Model
• Transmission
• Fuel Type

Objective:To provide a user-friendly platform for analyzing key metrics and trends in the automotive industry, enabling better decision-making and strategic planning.

Technologies Used:

• Tableau / Power BI
• SQL for database management

Mitron Bank Credit Card Practice Project - Data Analysis and Insights

Project Role: Data Analyst Date: November 2024

Project Overview

This practice project was inspired by a real-world scenario where Mitron Bank, a legacy financial institution, aimed to launch a new line of credit cards. The goal was to analyze a sample dataset of 4000 customers across five cities to provide actionable insights for the launch.

Key Findings

1. Income and Spend by Demographics:

• Gender: Male customers have significantly higher average income and spending.
• Marital Status: Married individuals show higher financial activity compared to single individuals.

1. Geographical Insights:

• Top Cities: Mumbai, Chennai, and Delhi NCR lead in total income and spending.
• City-Specific Spending: Customizing credit card features for different cities is crucial.

1. Spending Patterns:

• Categories: The top spending categories are bills, groceries, and electronics.
• Peak Months: Spending peaks in August and September, highlighting opportunities for targeted promotions.

1. Occupational Insights:

• High-Spending Occupations: Salaried IT employees and business owners demonstrate significant financial activity.

Strategic Recommendations

• Target High-Income Segments: Focus on premium credit card offers for high-income and high-spending customer segments.
• Tailor Benefits to Popular Spending Categories: Introduce rewards and cashback on bills, groceries, and electronics.
• Occupation-Specific Perks: Develop credit card benefits suited for specific occupations like IT professionals and business owners.
• City-Specific Marketing: Prioritize high-spending cities like Mumbai, Chennai, and Delhi NCR for marketing efforts.

This project underscores the importance of data-driven insights in shaping financial products that meet customer needs and market trends. It was an excellent opportunity to practice and hone my data analysis skills.

Sales Analysis Dashboard - Atliq Hardwares

Welcome to my portfolio! This is a showcase of my data analysis and visualization project for Atliq Hardwares. The journey began with a raw sales directory dump file, which I meticulously imported into SQL. Utilizing SQL queries, I verified the accuracy of the data before visualizing it in Power BI to create the comprehensive Sales Analysis Dashboard presented below.

Key Insights:

1. Revenue and Sales Quantity:

• Total Revenue: ₹984.81M
• Sales Quantity: 2M units
• Insight: The overall performance is strong, with substantial revenue generated from a significant volume of sales.

1. Revenue by Markets:

• Top Markets:
• Delhi: ₹519.51M
• Mumbai: ₹150.08M
• Ahmedabad: ₹132.31M
• Insight: Delhi is the standout market, contributing over half of the total revenue. Focus marketing and sales efforts in Delhi to leverage this dominance. Mumbai and Ahmedabad also show substantial contributions and should be secondary focus areas.

1. Sales Quantity by Markets:

• Top Markets by Quantity:
• Delhi: 988K units
• Mumbai: 384K units
• Nagpur: 262K units
• Insight: The highest sales volume in Delhi corresponds with its highest revenue, indicating a strong market presence. Higher unit sales in Nagpur despite lower revenue suggest lower-priced or more frequently purchased items.

1. Revenue Trend Analysis:

• Fluctuations: Peaks around July 2018 and July 2019
• Insight: Identify the reasons behind the peak months. It could be due to seasonal promotions, product launches, or market conditions. This can help in planning future campaigns to replicate these peaks.

1. Top 5 Customers:

• Top Contributors:
• Electricalsara: ₹413.33M
• Electricalsytical: ₹49.64M
• Insight: Electricalsara is the dominant customer, contributing a significant portion of revenue. Strengthen relationships with top customers through loyalty programs, personalized offers, and exclusive deals.

1. Top 5 Products:

• Top Products:
• (Blank): ₹468.96M (requires attention)
• Prod040: ₹23.58M
• Insight: The high revenue from the "blank" product entry suggests potential data quality issues. Investigate and resolve these blanks to ensure accurate reporting. Focus on promoting top-selling products like Prod040 and Prod159.

Recommendations:

1. Market-Specific Strategies:

• Delhi Focus: Given its high contribution to revenue and sales quantity, implement region-specific promotions, increase product availability, and enhance customer service in Delhi.
• Secondary Markets: Develop targeted marketing strategies for Mumbai and Ahmedabad to boost their performance further.

1. Customer Retention:

• Top Customers: Implement loyalty and rewards programs for top customers like Electricalsara to maintain and enhance their contribution.
• Customer Segmentation: Analyze the behavior of top customers to identify opportunities for cross-selling and up-selling.

1. Data Quality Improvement:

• Resolve Data Blanks: Investigate the causes of blank entries in the product data and rectify them to ensure accurate insights and reporting.

1. Trend Replication:

• Peak Analysis: Study the factors that led to revenue peaks in July 2018 and 2019. Apply these learnings to plan future campaigns and promotions around similar patterns.

1. Product Strategy:

• Promote Top Products: Focus on marketing and inventory optimization for top-selling products like Prod040 and Prod159 to maximize revenue.
• Address Data Gaps: Ensure all product entries are complete and accurate to avoid misrepresentation of performance.

By leveraging these insights and implementing the recommendations, you can enhance the sales performance and overall strategy for Atliq Hardwares. This project highlights your proficiency in SQL, data verification, and Power BI, showcasing your ability to derive actionable insights from complex datasets.

This project involves the creation of an interactive HR Analysis Dashboard in Power BI, aimed at understanding the factors contributing to employee attrition. The dashboard provides insightful visualizations and analytics, allowing HR professionals to make data-driven decisions to reduce attrition rates and enhance employee retention strategies.

This project focuses on creating an interactive dashboard in Power BI to analyze video game sales across different regions and platforms. The dashboard provides comprehensive insights into sales trends, top-selling games, and performance comparisons, enabling stakeholders to make data-driven decisions in the gaming industry.

This project involves creating and answering 20 diverse and insightful questions using My SQL. The questions cover various aspects of data retrieval, manipulation, and analysis, showcasing a basic understanding of SQL operations.

This project involves creating an interactive dashboard in Tableau to analyze mobile usage data. The dashboard provides comprehensive insights into user behavior, usage trends, and key metrics, enabling stakeholders to make data-driven decisions in the mobile industry.

This project involves creating an interactive dashboard in Tableau to analyze video game sales data. The dashboard provides comprehensive insights into sales trends, top-selling games, and performance comparisons, enabling stakeholders to make data-driven decisions in the gaming industry.

This project involves creating an interactive dashboard in Tableau to analyze employee attrition using HR analytics data. The dashboard provides comprehensive insights into factors contributing to employee turnover, enabling HR professionals to make data-driven decisions to improve retention rates.

Successfully completed DATA and BUSINESS ANALYTICS Training at TechTip24. Includes 40+ Hours of Power BI, 30 Hours of SQL and TABLEAU Sessions. Successfully Submitted 3 End-to-End Projects. Gained practical experience through Virtual Internships and real world problem solving.

• Completed a job simulation where I strengthened my PowerBI skills to better understand clients and their data visualisation needs.
• Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client requests with well-designed solutions.
• Strong communication skills reflected in the concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis.
• Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision-making.

• Completed a job simulation where I strengthened my PowerBI skills to better understand clients and their data visualisation needs.
• Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client requests with well-designed solutions.
• Strong communication skills reflected in the concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis.
• Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision-making.