Kshitija Bharati

Exploratory Data Analysis - Washing Machine Prices (Flipkart)

• Scraped Flipkart data using Python & BeautifulSoup to study pricing trends.
• Cleaned & analyzed attributes like price, ratings, capacity, and discounts using Pandas, NumPy, Matplotlib, Seaborn.
• Identified feature-impact relationships and created visualizations for decision-making.

SQL Project - Library Data Management

• Designed a relational LibraryDB with tables: Publisher, Book, Book_Authors, Library_Branch, Book_Copies, Borrower, and Book_Loans.
• Wrote complex SQL queries to:Count copies of books per branch (e.g., "The Lost Tribe" in Sharpstown). Identify borrowers with no books checked out. Track loaned books with borrower details & due dates. Summarize total loans per branch,etc.

SQL Project -Sales & Inventory Management Database

• Designed and implemented a relational database (SalesDB) with tables for Products, Customers, Orders, Order_Details, and Inventory.
• Developed complex SQL queries and reports to analyze monthly sales revenue, top-selling products, customer spending trends, and products needing restocking.Utilized joins, aggregations, and grouping techniques to generate actionable insights for business decision-making.

Power BI Project - Adidas Sales Analysis Dashboard

• Developed an interactive dashboard to analyze sales across time, region, product, and customer demographics.
• Tracked key business metrics such as Total Sales, Total Profit, Average Price per Unit, and Units Sold to evaluate overall business health.
• Conducted profitability analysis by retailer to identify top contributors and sales efficiency.
• Monitored sales trends over time (yearly, quarterly, monthly, daily) to uncover seasonal patterns and performance fluctuations.