Portfolio - Renuka Kulkarni | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Renuka Kulkarni

Data Analyst

EMAIL

[email protected]

PHONE

+91 6303251933

Download CV

About Me

As an Operations & Data Analyst, I managed inventory and operations for over 300 SKUs across 150+ retail stores. Leveraging advanced Excel functions such as VLOOKUP and pivot tables, I streamlined billing, stock tracking, and sales analysis. I also developed Power BI dashboards to visualize key metrics like revenue, stock turnover, and product performance, enabling data-driven decisions that optimized inventory management, reduced stockouts, and contributed to a 10% increase in revenue through smarter purchasing and targeted discount strategies. I am proficient in Excel, Power BI, and SQL, with expertise in data modelling, dashboard creation, and writing complex queries. With strong analytical and communication skills, I am passionate about transforming raw data into actionable insights to support business growth and improve operational efficiency.

I am eager to collaborate on meaningful projects and turn data into impactful decisions. Let’s connect!

1

Excel Project

7

PowerBI Projects

3

SQL Projects

Key Skills

MS Excel

Power BI

MYSQL

DATA MODELLING

DATA CLEANING

ETL

CANVA

DATA ANALYTICS

ANALYTICAL SKILLS

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

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

SQL Beginner to Advanced For Data Professionals

Microsoft Fabric Mini: For Data Analysts

Data Analyst Certification

Data Analyst Certification

Data Visualisation: Empowering Business with Effective Insights

Data Visualisation: Empowering Business with Effective Insights

Data Analytics and Visualization Job Simulation

Data Analytics and Visualization Job Simulation

Power BI Job Simulation

Power BI Job Simulation

Data Storytelling with PowerBI

Data Storytelling with PowerBI

Let's Work Together!

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

[email protected]

Call Me

+91 6303251933

LinkedIn

https://www.linkedin.com/in/renukakulkarni19/

GitHub

https://github.com/renuka251902

PowerBI Project

Customer Insights in Action: Driving Loyalty, Satisfaction & Retention

Domain/Function: Customer Experience & Loyalty Analytics in Retail

Developed an interactive Power BI dashboard for OmniRetail analyzing customer satisfaction, loyalty, and support interactions. Identified key satisfaction drivers across regions, age groups, and loyalty levels to guide retention strategies and CX improvements.

View Project
Engagement

Customer Insights in Action: Driving Loyalty, Satisfaction & Retention

Overview of customer satisfaction by region, age, and loyalty level with key KPIs and visual insights for retention and CX improvement.

Customer Insights in Action: Driving Loyalty, Satisfaction & Retention

Detailed analysis of top satisfaction factors, loyalty distribution, and support experience impact across customer segments and regions.

Project Details

Acted as a Data Analyst for OmniRetail, a U.S. electronics retailer.

Built a dynamic Power BI dashboard analyzing 2024 customer satisfaction data.

Integrated variables like support history, demographics, region, and loyalty level.

Identified top satisfaction drivers and their correlation with retention.

Analyzed satisfaction scores by age group, region, and loyalty level.

Highlighted support interaction impact on customer sentiment and churn.

Delivered actionable insights to improve CX strategies and decision-making.

Demonstrated skills in data storytelling, visualization, and customer analytics.

Focused on driving data-driven strategies for higher satisfaction and loyalty.

Live Interactive Dashboard

SQL Project

CHAI Analysis

Domain/Function: Sales Domain

Brewed insights from a quirky tea shop dataset, blending data analysis with storytelling flair. Using SQL, I explored ordering trends, shop ratings, and revenue patterns across cities.

View Project
Engagement

Database Schema Overview: Snapshot of raw data from all four tables — Ratings, Sales, Shops, and Menu Items — for easy reference and understanding.

Entity Relationship Diagram: Visualizes how Tea Shops, Menu Items, Sales, and Ratings tables are related through keys in a relational schema.

Project Details

"Spilled the Tea… with Data!"☕ is a fun and insightful data analysis project where I explored a tea shop dataset using SQL and Power BI.

From mapping chai shops to analyzing snack popularity, I brewed a full menu of insights.
I listed all shop locations, examined the menu🗺️ (kulhad chai to gulab jamuns), calculated total orders and revenue by location, and identified the best-selling item.
I also analyzed shop ratings, highlighted top-rated spots (avg. rating > 4.5), and filtered reviews mentioning “amazing” chai in Bangalore.
I tracked Masala Chai customers and pinpointed the day with the highest sales.

The project wrapped up with a CHAI (Challenge–How–Advantage–Impact) framework slide that combined humor, visuals, and actionable insights — where SQL met samosa, and chai met charts.

SQL Project

Pizza Sales Analysis Using SQL

Domain/Function: Sales Domain

Using SQL, I analyzed revenue trends, order patterns, and top-selling pizzas. Insights include peak order times, best-performing pizzas, and revenue growth, helping optimize marketing, inventory, and promotions for better sales and efficiency.

View Project
Engagement

View Project
on GitHub

Other Tools

SQL

CANVA

Pizza Sales Analysis Using SQL

Using SQL to analyze pizza sales, uncovering revenue trends, best-sellers, and key insights for smarter business decisions.

Pizza Sales Analysis Using SQL

Using SQL, we counted total orders placed, retrieving 21,350 orders from the database. This insight helps track sales volume and business performance.

Project Details

This SQL-driven analysis explores key trends in pizza sales, uncovering insights to enhance business strategy. I examined revenue breakdowns, order patterns, and best-selling pizzas to identify crucial opportunities for growth.

🔍 Key Findings:
Total Orders: Identified the overall number of orders placed.
Revenue Breakdown: Determined which pizza types generate the highest revenue.
Most Ordered Pizza & Size: Discovered customer favorites.
Peak Ordering Times: Analyzed hourly order distribution.
Top Revenue Pizzas by Category: Ranked best-performing pizzas.
Cumulative Revenue Trends: Tracked revenue growth over time.

📈 Business Takeaways:
🔹 Optimize marketing for high-revenue pizzas.
🔹 Adjust inventory based on demand trends.
🔹 Launch targeted promotions during off-peak hours.

This project demonstrates how data-driven insights can improve decision-making in the food industry.

PowerBI Project

Automotive Market Analysis

Domain/Function: Automotive Market Analysis

The automobile analysis domain covers price trends, mileage efficiency, fuel consumption, and service & maintenance insights. It provides data-driven insights into vehicle performance, cost efficiency, and ownership expenses, helping buyers, sellers, and industry professionals make informed decision

View Project
Engagement

Automotive Market Analysis

A data-driven dashboard exploring pricing, mileage, fuel efficiency, and service costs to provide key insights for buyers and analysts.

Automotive Market Analysis

Dashboard provides insights into car pricing, fuel type distribution, mileage, service costs, and model counts, helping users analyze market trends.

Project Details

Automobile Market Analysis: Data-Driven Insights:
In this project, I used Power BI to analyze automotive trends, focusing on pricing, mileage, fuel efficiency, and service costs. These insights help buyers and industry stakeholders make informed decisions.
🔹 Key Findings:
Pricing & Revenue: The average car price is ₹1.95M, with revenue peaking at ₹2.04B in 2022. Mahindra has the highest average price, while Maruti Suzuki and Kia remain budget-friendly.
Mileage & Fuel Efficiency: The average mileage is 19.97 km/l, with Mahindra, Honda, and Volkswagen leading in efficiency. Kia lags in mileage and engine size.
Service & Maintenance: Costs peaked in 2019-2021 but have declined. EVs have higher maintenance costs, while CNG and petrol are more affordable. Renault and Mahindra have the highest service costs.
Fuel & Transmission: Fuel types are evenly distributed. Transmission type has little impact on maintenance costs.
Buyer Insights: Honda & Volkswagen offer low service costs.

Live Interactive Dashboard

PowerBI Project

Call Center Analysis

Domain/Function: Telecommunication Analysis

Analyzing call center data, I found an 18.92% abandonment rate. Better agent allocation can help. High resolution rates (90%+) exist, but satisfaction (55%) needs work. Top issues: streaming, payment, and tech support. AI chatbots, shift changes, and training can boost efficiency and service quality

Other Tools

Data Visualization

Call Center Analysis

Displays call center metrics, including total calls, resolution rate, and customer satisfaction.

Call Center Analysis

Highlights agent performance, call resolution stats, and ranking based on efficiency.

Project Details

In my latest Power BI dashboard, I analyzed call center performance to uncover key insights that can drive better decision-making and efficiency. Here’s what I found:

Reducing Abandoned Calls – With an 18.92% call abandonment rate, optimizing agent allocation and introducing a callback option can help retain more customers.

Agent Performance Insights – Jim, Martha, and Dan handle the most calls per hour, while Greg and Dan have the highest call resolution rates (90%+). However, customer satisfaction (55%) needs improvement. Focused training and quality monitoring can enhance service levels.

Top Customer Issues – Streaming (847 calls), Payment (818 calls), and Technical Support (805 calls) are the most common concerns. Implementing self-service solutions (FAQs, chatbots) can reduce call volumes and improve efficiency.

Data-Driven Actions:
Introduce an AI chatbot for common issues.
Optimize shift scheduling to reduce call abandonment.

Project video

Live Interactive Dashboard

PowerBI Project

Online Retails Store Analysis

Domain/Function: Online Retail Sales Analysis

This job simulation refined my skills in data analysis, visualization, and strategic decision-making, preparing me for real-world business challenges.

View Project
Engagement

View Project
on GitHUB

Other Tools

Data Visulization

Data Cleaning

Dashboard

Online Retails Store Analysis

This job simulation refined my skills in data analysis, visualization, and strategic decision-making, preparing me for real-world business challenges.

Online Retails Store Analysis

This job simulation refined my skills in data analysis, visualization, and strategic decision-making, preparing me for real-world business challenges.

Project Details

Defining Business Scenarios-
Analyzed an online retail dataset, identifying key metrics and framing critical business questions for executives like the CEO and CMO to drive strategic insights.

✦ Selecting the Right Visuals-
Learned to choose effective charts and graphs to present data clearly and make insights more impactful.

✦ Designing Engaging Dashboards-
Utilized Power BI to create dynamic and interactive visualizations, enhancing data storytelling and business analysis.

✦ Presenting Insights & Analysis-
Extracted meaningful insights from data, improving decision-making through data-driven storytelling and visualization

This job simulation refined my skills in data analysis, visualization, and strategic decision-making, preparing me for real-world business challenges.

Live Interactive Dashboard

PowerBI Project

Mitron Bank – Credit Card Market Analysis

Domain/Function: Banking Domain

This project provided valuable insights into customer behavior, income patterns, and spending trends, enabling Mitron Bank to refine its credit card strategy. By leveraging Power BI and Excel, actionable recommendations were formulated to enhance customer engagement and promote financial inclusion.

View Project
Engagement

View Project
on GitHUB

Mitron Bank – Credit Card Market Analysis

Analyze customer demographics, income utilization, and spending patterns to provide data-driven recommendations for designing new credit card features

Mitron Bank – Credit Card Market Analysis

Optimizing credit card offerings through data-driven insights, tailored rewards, and strategic customer segmentation to enhance engagement and profita

Project Details

Mitron Bank, headquartered in Hyderabad, partnered with AtliQ Data Services to enhance its credit card offerings by leveraging customer insights. The analysis focused on understanding customer demographics, spending behavior, and income utilization to drive a more customer-centric approach.

🔹 Objectives:
✅ Analyze demographic classification
✅ Identify spending insights & income utilization
✅ Segment key customer groups
✅ Recommend credit card features

🔹 Key Insights:
✅ Majority of customers belong to a specific age group and city
✅ Credit cards are the most utilized financial product
✅ Peak spending occurs in specific months, influenced by seasonal trends
✅ Bills and groceries emerge as the top spending categories
✅ Income utilization varies across demographics, highlighting different financial behaviors

Live Interactive Dashboard

PowerBI Project

AtliQ Grands Hospitality Analysis

Domain/Function: Hospitality Domain

This project demonstrated my ability to transform complex business data into meaningful insights for strategic decision-making. By leveraging Power BI and SQL, I developed an interactive dashboard that helps AtliQ Grands optimize revenue streams, reduce cancellations, and improve market positioning.

View Project
Engagement

View Project
on GitHUB

AtliQ Grands Hospitality Analysis

Develop a dashboard and provide actionable insights to optimize revenue and market performance.

AtliQ Grands Hospitality Analysis

This model enables analysis of booking trends, occupancy rates, revenue performance, and customer preferences.

Project Details

AtliQ Grands, a premium hotel chain in India, struggled with declining revenue and market share due to competition and ineffective decision-making. Lacking an in-house analytics team, they engaged external analysts to extract insights from historical data.

🔹 Objective: Develop a dashboard for revenue optimization.
🔹 Tools: Power BI, DAX, SQL, Excel.
🔹 Skills: Data visualization, BI, revenue analysis, dashboard design.

Key Insights: Identified top-performing locations, highest occupancy rates, peak revenue periods, and the impact of cancellations on profitability.

New Learnings: Created custom visuals, leveraged Power BI features like bookmarks, explored industry cancellation policies, and optimized dashboard design for a seamless experience.

Revenue Analysis: Collected data on room rates, bookings, occupancy, and revenue. Created DAX measures for ADR, RevPAR, occupancy percentage, and other key metrics to assess profitability and operational efficiency.

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc Insights

Domain/Function: Consumer Goods

ATLIQ Hardware, one of the leading computer hardware producers in India with customers from across the globe, want to get insights on company products sales to make data-informed decisions.

View Project
Engagement

View Project
on GitHUB

Consumer Goods Ad-hoc Insights

The above Image shows the SQL query for getting the desired data

Consumer Goods Ad-hoc Insights

The above image shows the results obtained from the SQL query

Project Details

AtliQ Hardwares, a leading computer hardware manufacturer operating across India and global markets, struggled with accessing real-time insights for decision-making.

I designed and executed optimized SQL queries to extract key business data for AtliQ Hardwares, focusing on sales, inventory, and operations. These queries were structured to retrieve relevant metrics efficiently, ensuring data accuracy and consistency.

The extracted data was then transformed into an interactive Power BI dashboard, enabling real-time performance tracking, identifying bottlenecks, and uncovering growth opportunities. This streamlined data pipeline improved decision-making and empowered stakeholders with actionable insights.

PowerBI Project

Business Insights-360

Domain/Function: Business Intelligence

This project strengthens expertise in e-commerce and brick-and-mortar operations while developing key Power BI skills for data analysis and decision-making. It provides hands-on experience in finance, sales, marketing, and supply chain, executive, enabling data-driven insights for business growth.

View Project
Engagement

View Project
on GitHUB

Other Tools

MS Excel

MYSQL

DATA CLEANING

DATA MODELLING

ETL

Business Insights-360

Business Insights 360: A Power BI dashboard providing key insights into Finance, Sales, Marketing, Supply Chain, and Executive metrics for decisions.

Business Insights-360

This data model connects sales, finance, marketing, and supply chain data, enabling seamless analysis through Power BI for informed business decisions

Project Details

Leveraging Power BI, I designed interactive dashboards for the homepage, finance, sales, marketing, supply chain, and executive views. These dashboards deliver key business insights, enabling data-driven decisions. Along with technical expertise in visualization, I honed soft skills like stakeholder management and communication to present actionable insights effectively. This blend of skills fosters a comprehensive understanding of business performance and analytics.

Finance: Analyze P&L, track Net Sales, and assess KPIs like GM% and Net Profit%.
Sales: Evaluate customer/product performance, GM% by region, and unit economics.
Marketing: Assess divisional and customer insights, analyze COGS and GM.
Supply Chain: Track forecast accuracy, net error, and supply trends.
Executive: Monitor market share, revenue distribution, and top-performing customers/products.

This combination of skills and insights supports strategic decision-making and business performance analysis.

Live Interactive Dashboard

Excel Project

Sales & Financial Analysis

Domain/Function: Excel & Finance

Developed Sales Performance & Finance reports to analyze sales trends, compare market performance with sales targets, track key metrics, and analyze financial performance. This helped improve decision-making and resource allocation using data insights.

View Project
on GitHUB

View Project
on GitHub

Sales & Financial Analysis

This report helps identify underperforming and overperforming markets by comparing actual sales to targets.

Sales & Financial Analysis

This report analyzes 2019-2021 sales trends across countries, comparing actual sales vs targets to identify gaps and optimize sales strategies.

Project Details

This project analyzes sales trends and financial performance using a dataset from AtliQ hardware (2019-2021). It includes an interactive Sales Report and a P&L Report, enabling data-driven decision-making.

Key Insights & Features:
Sales Analysis: Net Sales performance by region, country, and division.
Market Performance: Compared sales with targets across divisions.
Finance Report: Created a Profit & Loss report to track Net Sales, COGS, and Gross Margin %.
Visual Dashboards: Built interactive reports for better data visualization.

Tools & Techniques Used:
Tools: Excel, Power Query, Power Pivot, DAX
Techniques: Data Cleaning, Sales Trend Analysis, ETL Process

Business Impact:
This analysis helps businesses track sales trends, optimize financial performance, and make data-driven decisions to improve profitability.