Chandana Krishna N

MBA (Marketing) candidate with a strong engineering foundation (B.E. in Biotechnology, 9.2 CGPA) and hands-on experience in quality assurance, operations, and customer relations. Experienced in data analysis, process evaluation, and cross-functional coordination across manufacturing and financial services industries. Skilled in Excel and business analytics with a structured problem-solving approach. Seeking an entry-level Analyst role to apply data-driven decision-making and analytical thinking to business challenges.

1.Vrinda Store Retail Sales Analysis – Excel Dashboard Project

• Cleaned and structured raw sales data for analysis.
• Conducted revenue and performance analysis across product categories and regions.
• Built dynamic Excel dashboard using Pivot Tables and slicers to monitor key business KPIs.
• Identified seasonal sales trends and customer purchasing patterns.

2.HR Attrition Analysis Dashboard – Power BI

• Cleaned and transformed HR dataset using Power Query.
• Built data model and developed DAX measures for attrition rate, KPIs, and employee metrics.
• Analyzed 433 employee records to identify attrition drivers across departments and demographics.
• Found 20.7% attrition rate, with highest turnover in Sales department and 26–35 age group.

3.Pizza Sales Data Analysis – SQL & Power BI

• Performed end-to-end sales data analysis using SQL and Power BI.
• Wrote SQL queries to calculate KPIs including total revenue, average order value, total pizzas sold, and total orders.
• Used GROUP BY, aggregate functions (SUM, COUNT, DISTINCT), and date functions to analyze daily and monthly trends.
• Calculated percentage contribution by pizza category and size using subqueries.
• Built interactive Power BI dashboard to visualize revenue trends, busiest days, product performance, and category contribution.
• Identified peak sales in July and January and highest orders on weekends and Friday evenings.

4.Restaurant Market Analysis – Python (Pandas, Matplotlib)

• Imported and cleaned large dataset using Pandas.
• Performed data wrangling, transformation, and feature analysis.
• Analyzed restaurant ratings distribution and cost-performance correlation.
• Identified high-demand cuisines and city-level performance patterns.
• Built visualizations to support business insights and strategic recommendations.

• Co-authored and presented research paper on automated customer engagement at an International Digital Innovation Conference at JSS Science & Technology University (in association with Malaysia University of Science & Technology)(2025).
• 1st Place – Chaitanya HR Club Competition (Economic Analysis Presentation).
• Financial Head – PHOTO-ON Club, SJCE (2022–2023) | Managed budgeting and financial coordination.
• Core Team Member – Institutional Events (Mannovex 2024 & Kannada Rajyotsava 2024).