Souvanik Chaudhury

Data Analyst

[email protected] +91 9864765010

Resume

Hello, I am

Souvanik Chaudhury.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

Welcome to my portfolio!
I am an enthusiastic Data Analyst, driven by the art of transforming raw data into strategic insights. Proficient in Excel, PowerBI, SQL and Python, I bring a unique combination of technical skills and analytical capabilities to the table.

Although my journey began with a degree in Mechanical Engineering, I quickly discovered that my true passion lies in data analysis and marketing. It's like discovering a hidden talent I never knew I had! While I haven't officially held a data analytics role yet, my portfolio is full of real-world business projects where I've poured my heart into showcasing my ability to slice and dice data to reveal game-changing strategies.

From gears to graphs, my goal is to make data dance. Join me to explore my world of numbers, insights, and endless possibilities as we look at each project together. My portfolio is a testament to my dedication and ability to make data not just a tool, but a driving force for success.

Key Skills

SQL

Python

Creating data visualizations

Data analysis and exploration.

Statistical knowledge.

My Projects

Sales Analytics (FMCG)

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

Ad-hoc Insights (Consumer Domain)

Credit Card Analysis Mitron Bank

Hospitality Data Analysis

Atliq Grands: A Strategic Hospitality Analysis

Awards & Certificate

CodeBasics Resume Challenge 7

CodeBasics Resume Challenge 8

Atliq Technologies Internship Certificate

DATA ANALYSIS BADGE

Data Analyst Certificate

Letter of Recomendation

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.

Mail Me

[email protected]

https://www.linkedin.com/in/souvanik-chaudhury/

Call Me

+91 9864765010

GitHub

https://github.com/souvanikchaudhury

Excel Project

Sales Analytics (FMCG)

Two reports are created for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years.

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.
I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

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

Project video

PowerBI Project

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

AtliQ Electronics, a fast-growing consumer tech firm, lags due to data utilization gaps, primarily storing reports in Excel. My aim: Power BI's analytics implementation for actionable insights and informed choices.

View Project
Engagement

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

The project aimed to create a versatile report for sales, marketing, finance, and executive stakeholders, emphasizing:

1.Robust data modeling
2.User-centric report design
3.Drillable insights

Skills acquired:

1.Power Query (basic & advanced)
2.Basic & complex DAX formulas
3.Handling intricate data models (10+ tables)
4.Selecting visuals & formatting
5.Dashboard design principles
6.Interactive bookmarks usage
7.Power BI service deployment
8.Implementing stakeholder feedback
9.Analyzing diverse metrics (sales, marketing, finance, supply chain)

These skills are valuable for data-driven decision-making roles.

Live Interactive Dashboard

SQL Project

Ad-hoc Insights (Consumer Domain)

AtliQ Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. Hence, company decided to conduct a SQL challenge.

View Project
Engagement

View Project
on GitHUB

Presentation

SQL Queries

Project Details

Handled 10 Unexpected SQL Tasks:
Managed a range of immediate SQL requests to help the company make better decisions. Gained a deeper understanding of important SQL concepts like Common Table Expressions (CTE), different ways to join data, and using window functions. Used these skills to work with and analyzed the database information.
Skillfully applying these concepts, I successfully transformed raw data into actionable insights, contributing to a more informed and strategic approach for the company's future endeavors.

Project video

PowerBI Project

Credit Card Analysis Mitron Bank

Mitron Bank's credit card project is driven by strategic objectives to diversify product offerings, expand market presence, and deliver tailored credit card solutions. With commitment to a data-driven approach, the bank aims to make precise decisions, and understanding customer spending behaviors.

View Project
Engagement

View Project
on GitHUB

Home Page

Demographic View

Project Details

In leading the development of our innovative Rewards Program at Mitron Bank, my approach was marked by a meticulous and strategic process. Beginning with the import and rigorous validation of the dataset, I ensured a foundation of accuracy and reliability. Through a series of refinements and adjustments, the dataset was fine-tuned for relevance, setting the stage for a robust data modeling approach that facilitated seamless analysis. Key performance metrics, including Total Income, Total Spend, Total Customers, and Credit Card Usage, were meticulously tracked, forming the backbone of our monthly monitoring system. The user interface was crafted with a keen focus on visual appeal and interactivity, utilizing diverse visuals and slicer filters. Additionally, I delved into an in-depth analysis of the dataset, extracting valuable insights that shaped our strategic decisions. The innovative incentives, tailored for specific employee demographics and behaviors, were conceived to optimize.

Project video

Live Interactive Dashboard

PowerBI Project

Hospitality Data Analysis

AtliQ Grands is a renowned brand facing challenges,To combat declining market share and revenue, the managing director has initiated a Business and Data Intelligence initiative, and I'm honored to be a part of this transformative journey.

View Project
Engagement

View Project
on GitHUB

Dashboard View

Key Insights

Project Details

While collaborating with AtliQ Grands, a distinguished luxury hotel chain, our team successfully implemented "Business and Data Intelligence" strategies aimed at rejuvenating their market share and revenue. A pivotal aspect of our initiative was the creation of a dynamic Power BI dashboard, fostering real-time data analysis.
𝐅𝐨𝐜𝐚𝐥 𝐩𝐨𝐢𝐧𝐭𝐬:-
Crafting an engaging Power BI dashboard for dynamic, real-time data analysis.
Incorporating essential hospitality domain metrics such as RevPAR, ADR, DBRN, DSRN, and DURN.
Scrutinizing historical data to unearth opportunities for enhancing revenue.
Offering actionable insights to steer pricing and occupancy decisions strategically.
𝐀𝐪𝐮𝐢𝐫𝐞𝐝 𝐯𝐚𝐥𝐮𝐚𝐛𝐥𝐞 𝐬𝐤𝐢𝐥𝐥𝐬 𝐚𝐧𝐝 𝐤𝐧𝐨𝐰𝐥𝐞𝐝:-
A high level of proficiency in Power BI for effective data visualization and analysis.
A comprehensive understanding of pivotal hospitality metrics and KPIs.
Embracing data-driven decision-making principles for optimizing pricing and occupancy.

Live Interactive Dashboard

Python Project

Atliq Grands: A Strategic Hospitality Analysis

AtliQ Grands, a fictional hospitality powerhouse with a presence in four cities, embarked on a profound data-driven exploration to conquer challenges and propel business expansion.

View Project
Engagement

View Project
on GitHUB

Data Exploration

Insights Generation

Project Details

𝗧𝗵𝗲 𝗽𝗿𝗼𝗷𝗲𝗰𝘁 𝘂𝗻𝗳𝗼𝗹𝗱𝘀 𝗶𝗻 𝘁𝗵𝗿𝗲𝗲 𝗽𝗶𝘃𝗼𝘁𝗮𝗹 𝘀𝘁𝗮𝗴𝗲𝘀:

🧹 𝑫𝒂𝒕𝒂 𝑪𝒍𝒆𝒂𝒏𝒊𝒏𝒈:
Ensuring precision in insights, I diligently polished the data:
Rectified negative values in the Number of Guests.
Eliminated outliers in Revenue Generated & Realized.
Addressed NaN/Null values in Ratings Given.
------------------------------------------------------------
🔄 𝑫𝒂𝒕𝒂 𝑻𝒓𝒂𝒏𝒔𝒇𝒐𝒓𝒎𝒂𝒕𝒊𝒐𝒏:
Converting raw data into actionable intelligence:
Introduced the concept of 'Occupancy Percentage' derived from successful bookings and capacity.
Explored nuanced insights based on the transformed dataset.
📊 Insights Generated:
🏢 Presidential rooms claim the highest occupancy rate.
🌆 Delhi leads in occupancy, closely trailed by other cities.
📅 Weekends exhibit higher occupancy (>70%) than weekdays (50.9%).
📉 Bangalore consistently records the lowest occupancy rate.
🗓️ August data might be incomplete, available only for Mumbai and Bangalore.
-------------------