Powered by
Codebasics Data Analytics Bootcamp

Nabyendu Kuiti

Data Analyst

+91 8981506503 [email protected]

Resume

Hello, I am

Nabyendu Kuiti.

1

SQL Project

1

Excel Project

2

PowerBI Projects

About Me

Welcome to my portfolio! I'm Nabyendu Kuiti, a highly motivated data analyst with a PGDM in Marketing. I possess a strong analytical mind and a passion for extracting valuable insights from complex datasets.

Why Choose Me?

🔍 Uncover Hidden Gems: Leverage strong analytical skills and expertise in Excel, Power BI, and MySQL to extract valuable insights from complex data.

🎯 Customer-Centric Solutions: Prioritize understanding client needs to deliver tailored solutions that exceed expectations.

🤝 Collaborative Spirit: Foster open communication and teamwork to achieve mutual success in a fast-paced environment.

📚 Lifelong Learner: Continuously invest in skill development to stay ahead of the curve in the evolving data landscape.

Key Skills

SQL

STAKEHOLDER MANAGEMENT

PROJECT MANAGEMENT

My Projects

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/nabyendu-kuiti/

+ 91 8981506503

https://github.com/nabyendukuiti

SQL Project

Analysis for Ad-hoc Requests in the Consumer Goods Domain

Domain/Function: Consumer Goods

Atliq Hardware, a leading computer hardware producer with a global presence, is seeking sharp minds to join their growing data analytics team. To identify candidates with the right blend of technical skills and analytical thinking, they've designed a short SQL challenge.

View Project
Engagement

View Project
on GitHUB

Analysis for Ad-hoc Requests in the Consumer Goods Domain

Utilized MySQL to analyze 10 ad hoc requests

Analysis for Ad-hoc Requests in the Consumer Goods Domain

Utilized PowerPoint for delivering the presentation.

Project Details

🎯Objective:
Analyze 10 ad hoc requests from Atliq Hardwares management to provide actionable insights for informed decision-making through SQL queries.

🔍 Data Analysis: Successfully addressed 10 ad-hoc requests utilizing fundamental SQL concepts including WHERE clause, GROUP BY, ORDER BY, JOINS, CTE, ensuring accurate and efficient data retrieval for each query.

📊 Data Visualization: Transformed query results into dynamic visualizations using Power BI. Employed a variety of effective visualizations, including bar charts, pie charts, maps, donuts, and line charts, to convey insights with clarity and impact.

🎥 Insights Presentation: Conducted a comprehensive video presentation elucidating insights gleaned from visualizations. Shared impactful observations and actionable recommendations through a clear and engaging narrative, fostering understanding and driving informed decision-making.

Excel Project

Provide Insights to the Revenue Team in the Hospitality Domain

Domain/Function: Hospitality

AtliQ Grands, a luxury hotel chain in India, is losing market share due to competition and mismanagement. Seeking a data-driven approach for a turnaround.

View Project
on GitHUB

Provide Insights to the Revenue Team in the Hospitality Domain

Overall Report

Provide Insights to the Revenue Team in the Hospitality Domain

Monthwise Report

Project Details

🎯Objective:
AtliQ Grands is experiencing declining market share and revenue in luxury/business hotels due to competition and ineffective decision-making. This project aims to analyze data and create a dashboard to guide strategic decisions and restore market position.

🔍 Data Analysis: Used Excel Power Query to extract, transform, and load (ETL) AtliQ Grands' historical data for analysis.

📊 Data Visualization: Created a visually compelling dashboard featuring bar charts, pie charts and line charts to communicate insights clearly and effectively.

🎥 Insights Presentation: Delivered a thorough video presentation, articulating key insights derived from visual representations.

PowerBI Project

Business insights 360

Domain/Function: Consumer Goods

AtliQ Hardware, a fast-growing company, leverages Power BI for data-driven insights in finance, sales, marketing, and supply chain, aiming to dominate the market.

View Project
Engagement

View Project
on GitHUB

Business insights 360

Home page

Business insights 360

Executive view

Project Details

🎯Objective:
Revamp Atliq Hardware's strategy with data-driven insights. Form a dedicated data team and utilize advanced tools for understanding consumer behaviour and market trends.

🔄 Data Integration: Successfully imported 1.8 million records from varied sources like Excel, CSV, and MySQL into Power BI, establishing a unified data platform for thorough analysis.

🛠️ ETL Optimization: Implemented Power Query for seamless data extraction, transformation, and loading, enhancing data flow efficiency. Utilized DAX Studio to reduce load time and storage by 25%.

📊 Robust Data Modeling: Developed a strong data model with 15+ tables, enabling efficient relationships. Leveraged DAX for insightful calculated columns and measures.

📈 Customized Reporting: Tailored reports, including P&L for Finance, Sales, Marketing, Supply Chain, and Market Share Trends for Executives.

📊 Dynamic Dashboard:
Created a versatile Power BI dashboard, meeting AtliQ Hardware's departmental needs

Live Interactive Dashboard

PowerBI Project

Analyse Promotions and Provide Tangible Insights to Sales Director

Domain/Function: FMCG

AtliQ Mart, a retail giant with over 50 supermarkets in southern India, ran massive promotions during Diwali 2023 and Sankranti 2024. The Sales Director now seeks insights from these campaigns to make informed decisions for future promotions, aiming to optimize sales and customer engagement.

View Project
Engagement

View Project
on GitHUB

Analyse Promotions and Provide Tangible Insights to Sales Director

Store Analysis

Analyse Promotions and Provide Tangible Insights to Sales Director

Promotion Analysis

Project Details

🎯Objective: Identify successful and unsuccessful promotions from Diwali 2023 and Sankranti 2024, providing actionable insights for future strategies. Create a clear, self-explanatory dashboard for the Sales Director.

🔍 Data Analysis: Successfully addressed 5 ad-hoc requests utilizing fundamental SQL concepts including WHERE clause, GROUP BY, ORDER BY, JOINS, CTE, ensuring accurate and efficient data retrieval for each query.

📊 Data Visualization: Prepared a dashboard using Power BI to convey insights with clarity and impact.

Live Interactive Dashboard