Abritti Chakraborty

• Dedicated Data Analyst with a strong foundation in data analysis and visualization.
• Equipped with an MCA and BCA.
• Completed comprehensive training at PCS Global Pvt Ltd.
• Proficient in Advanced Excel and Power BI.
• Seeking to contribute analytical skills and insights to drive data-informed decision-making in a dynamic organization.

HOTEL BOOKING CANCELLATION ANALYSIS

This project analyzes hotel booking cancellations using advanced Excel techniques. It examines data to identify patterns in guest types, peak cancellation periods, and room allocation. Using IF-ELSE functions and pivot tables, the analysis tracks trends, visualizes insights with charts, and provides recommendations to reduce cancellations. Key findings highlight demographics prone to cancellations and suggest strategies like flexible booking policies and improved room allocation to optimize hotel operations and enhance customer satisfaction.

• Tools: Excel (Pivot Tables, Dashboards)
• Organization: PCS Global Pvt Ltd (February 5-10, 2024)

FESTIVAL SALES PROJECT

This project analyzes Diwali sales data to uncover consumer trends and inform marketing strategies. Using Python and visualization tools, it examines gender, age, marital status, regional patterns, and occupation's influence on buying behavior. Key findings include top-selling products, demographic trends, and regional variations. The project offers targeted marketing recommendations to optimize future sales performance based on these insights.

• Tools: Python (Matplotlib, Seaborn)
• Organization: PCS Global Pvt Ltd (December 1-6, 2023)

A SUPER STORE SALES REPORT & PREDICTION

This project analyzes superstore sales data using Power BI to identify trends, optimize processes, and increase sales. It includes sales performance, profitability, and customer segmentation analysis. Visualizations like time series charts, geographical maps help derive insights. Recommendations focus on enhancing sales, improving profits, and boosting customer retention. The project emphasizes data-driven decision-making to drive growth and improve business performance.

• Tools: Power BI (Time Series)
• Organization: PCS Global Pvt Ltd (June 3-11, 2024)

HR ANALYSIS

This HR analytics project analyzes employee data using Power BI to understand factors influencing attrition and job satisfaction. It examines variables like salary, gender, education, job role, and department, using interactive visualizations to identify trends. Key findings highlight departments with high attrition and factors affecting employee satisfaction. The project offers actionable recommendations to optimize HR strategies, improve retention, and enhance workplace engagement.

• Tools: Power BI (Dashboards)
• Organization: PCS Global Pvt Ltd (May 1-10, 2024)

• 1 Year Data Analysis Certificate- PCS Global Pvt Ltd, 07/01/24
• Introduction to Generative AI- Google, 04/01/24
• Data Visualization Certificate- TATA Group, 08/01/24
• AI/ML in Geodata Analysis- IIRS ISRO Dehradun, 09/01/24

• Managed a YouTube channel on Indian culture, heritage, and traditions.
• Researched topics, analyzed information, scripted, and recorded videos.
• Channel has over 96k+ subscribers, demonstrating skills in research, content creation, and audience engagement