Powered by
Codebasics Bootcamp

Arindam Chakraborty

Data Analyst

[email protected]

Resume

Hello, I am

Arindam Chakraborty.

1

Excel Project

3

PowerBI Projects

1

SQL Project

About Me

👋 Hi there! Welcome to my portfolio website! I'm an aspiring Data Analyst passionate about turning data into insights.

My Skills
• 📊 Excel
• 📈 Power BI
• 🗃️ SQL
• 🐍 Python
• 🖥️ Tableau

My Journey
• 🎓 Background: I have a Bachelor's degree in Bio-Science. Despite my non-technical background, I discovered my talent for data analysis.
• 🏢 Experience: I completed a 5-month internship at Business Brio, where I sharpened my data skills.
• 📂 Projects: I've worked on several business projects, which you can explore below in my portfolio.

Why Me?
• 🔍 Analytical Mindset: I love diving into data to find meaningful patterns and insights.
• 💡 Problem Solver: I enjoy solving real-world problems using data.
• 🌟 Eager to Learn: I'm always excited to learn new tools and techniques in data analysis.

I can't wait to bring my skills and enthusiasm to a great team!

Key Skills

Problem Solving

Effective Communication

Stakeholder Management

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

SQL For Data Science, provided by Coursera

SQL For Data Science, provided by Coursera

Excel Skills for Business Specialization, provided by Coursera

Excel Skills for Business Specialization, provided by Coursera

Python Programming for Data Science, by Data Brio Academy

Python Programming for Data Science, by Data Brio Academy

Internship Certificate From Business Brio

Internship Certificate From Business Brio

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/arindam430

https://github.com/Arindam430

SQL Project

Ad-Hoc Insights

Domain/Function: Consumer Goods

I conducted a business analysis for AtliQ Hardware, examining sales trends, pricing strategies, and customer demand across key markets. The project included SQL-based insights and Power BI dashboards, providing strategic recommendations for revenue growth and market expansion.

View Project
Engagement

View Project
on GitHUB

View Project
on Canva

Other Tools

Micorsoft PowerBI

MS-Excel

Ad-Hoc Insights

This page describes how Atliq Hardware is expanding its data analytics team to tackle insufficient insights, using an SQL challenge for evaluation.

Ad-Hoc Insights

This page outlines various Ad-Hoc requests designed to analyze Atliq Exclusive’s markets, product trends, sales performance, and customer insights.

Project Details

📖 Objective: Conducted a business data analysis for AtliQ Hardware, focusing on sales trends, pricing strategies, and customer demand across multiple regions to drive data-driven decision-making.

💻 Data Analysis: Extracted and analyzed datasets using SQL from multiple sources. Cleaned, processed, and visualized data using Power BI, creating insightful dashboards for management.

📊 Insights Generated: Identified top-performing products, customer segments, and regional sales trends. Correlated pricing strategies with sales performance, uncovering key revenue drivers and market opportunities.

🚀 Outcome: Delivered actionable insights through interactive dashboards, helping AtliQ Hardware improve sales forecasting, pricing strategies, and market positioning.

PowerBI Project

Electric Vehicle Market Analysis

Domain/Function: Automotive Industry

I conducted a market analysis for AtliQ Motors' entry into India's EV market, examining sales trends, state-wise penetration, and customer preferences. The project included projections up to 2030 and strategic recommendations on manufacturing locations and branding to support data-driven expansion.

View Project
Engagement

View Project
on GitHUB

Other Tools

Ms Excel

Electric Vehicle Market Analysis

📊 Sales by Makers: Showcasing EV sales trends, market shares, revenue distribution, and growth insights for top-performing manufacturers.

Electric Vehicle Market Analysis

🌍 Sales by States: Highlighting EV sales, penetration rates, projected growth, and state-wise performance trends for effective market insights.

Project Details

📊 Objective: Conducted a comprehensive market analysis to aid AtliQ Motors in expanding EV sales in India, focusing on sales trends, penetration rates, and government policies.

🖥️ Data Analysis: Analyzed datasets from Vahan Sewa (EV sales) and Ministry of Heavy Industries (public charging stations). Cleaned, processed, and visualized data using Excel and Power BI, creating insightful dashboards.

🔄 Insights Generated: Identified top-performing states, makers, and vehicle categories based on sales and growth rates. Correlated EV sales with public charging infrastructure, uncovering trends and adoption barriers.

🌍 Recommendations: Suggested market strategies such as focusing on 2-wheelers, establishing manufacturing units in Maharashtra, and targeting states like Karnataka and Delhi for penetration.

🚀 Outcome: Delivered actionable insights with data-driven recommendations to boost EV adoption, enhance infrastructure, and position AtliQ Motors as a market leader in India.

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ Hospitality Revenue Analysis

Domain/Function: Hotel and Tourism

AtliQ Grands, a luxury hotel chain in India, hired a third-party service provider to analyze their market share and revenue decline. As a data analyst, I developed key metrics, created a dashboard, and generated additional insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

MS Excel

AtliQ Hospitality Revenue Analysis

Overview page offering a snapshot of selected properties with KPIs and charts, such as Realization% and ADR by booking channels.

AtliQ Hospitality Revenue Analysis

Data Model consisting 3 dimension tables and 2 fact tables.

Project Details

AtliQ Grands, a luxury hotel chain in India, hired a third-party service provider to counter market share and revenue losses due to competitor strategies and poor decisions.

As a data analyst, I was tasked with:
- 📊 Developing key metrics.
- 📋 Creating a dashboard.
- 🔍 Generating additional insights.

What I Learned:
- 📈 Created impactful visuals like stacked percentage bar charts.
- 🛠️ Enhanced data storytelling with dynamic tooltips.
- 💡 Understood price elasticity differences in travel vs. product industries.
- 💸 Emphasized consistent pricing across channels and unique promotions.
- 🔗 Linked RevPAR to pricing and occupancy rates.
- 📝 Analyzed hotel cancellation policies, noting fees for late cancellations.

Summary: This project improved my data visualization skills and provided strategic insights to help AtliQ Grands regain market share and boost revenue with data-driven decisions.

Live Interactive Dashboard

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Business Intelligence and Analytics

AtliQ Hardwares, a fast-growing consumer electronics company, needs a competitive edge. My goal is to implement a Power BI solution to provide insights and enable informed decision-making.

View Project
Engagement

View Project
on GitHUB

Other Tools

MS Excel

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User-friendly landing page as part of dashboard design for intuitive navigation and enhanced user experience.

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Data modeling involving 10+ tables and over 1.5 million records for robust and comprehensive analysis.

Project Details

In this project, I created a comprehensive report for stakeholders in sales, marketing, finance, and the executive team, focusing on:

1. 📊 Robust Data Modeling: Strong, reliable data structure across 10+ tables.
2. 🧩 User-Friendly Design: Intuitive and easy-to-navigate report.
3. 🔍 Drillable Insights: In-depth analysis with drill-down capabilities.

Skills and Learnings:
1. 🔄 Power Query: Basic and advanced data transformations.
2. 🧮 DAX Formulas: Simple and complex formulas.
3. 📂 Data Modeling: Multiple table relationships.
4. 📈 Visuals: Effective visual selection and formatting.
5. 🎨 Dashboard Design: User-friendly and appealing layouts.
6. 📑 Bookmarks: Interactive, dynamic reports.
7. 🚀 Deployment: Power BI service for collaboration.
8. 📝 Feedback: Stakeholder feedback implementation.
9. 📊 Metrics: Sales, marketing, finance, and supply chain insights.

This project equips AtliQ Hardwares with actionable insights, driving informed decisions and fostering growth.

Live Interactive Dashboard

Excel Project

Sales Analytics

Domain/Function: FMCG

I created a sales report using Excel pivot tables to help businesses determine customer discounts, improve negotiations, and identify expansion opportunities. The reports provide insights to optimize sales strategies, enhance customer satisfaction, and boost revenue.

View Project
Engagement

View Project
on GitHUB

Sales Analytics

This report shows customer net sales over the years, helping businesses track trends and identify top and underperformers for strategic decisions.

Sales Analytics

This report lets stakeholders evaluate a country's sales over the years, compare to targets, and identify gaps and areas for improvement.

Project Details

In this project, I created a sales report using Excel pivot tables to help businesses determine effective customer discounts, negotiate better with consumers, and spot potential expansion opportunities in promising countries. These reports provide actionable insights and recommendations to optimize sales strategies, enhance customer satisfaction, and boost revenue.

Skills I Learned:
• 📊 Pivot Tables
• 🔄 Power Query
• 🧮 Basic DAX
• 🎨 Conditional Formatting
• 🖌️ Report Beautification
• 📈 Sales Domain Metrics

Project Goals:
• Empower businesses with tools and insights to monitor and improve sales activities
• Unlock new opportunities through sales data analysis
• Drive growth and stay competitive in a dynamic market

By leveraging this data, businesses can drive growth and stay competitive in a dynamic market.