Hi, I'm Kiran
Aspiring Data Analyst

Welcome to my portfolio. Here you can find my projects and learn more about my skills in Python, SQL, Advanced Excel, Power BI, and Tableau.

About Me

AUG 14 2024

Comprehensive Superstore
Sales Analysis in Excel

  • Created an interactive Excel dashboard to analyze superstore sales data, featuring KPIs like Total Sales, Total Profit, and Average Order Value.
  • Implemented visualizations such as Donut Charts, Bar Charts, and Maps to effectively present sales performance and regional insights.
  • Used dynamic slicers to enable users to filter data by Year, Category, Payment Mode, and Ship Mode for more granular analysis.
superstore Sales Analysis
OCT 15 2024

Excel-Based Order Data Management and Profit Analysis Report

  • Developed a dynamic Excel report that retrieves order and product details based on a selected Order ID.
  • Utilized advanced Excel functions such as VLOOKUP, XLOOKUP, and FILTER to create a user-friendly interface.
  • Incorporated conditional formatting to visually differentiate profit margins, enhancing the report's usability.
  • Worked with a comprehensive dataset of over 9,000 rows, demonstrating data handling capabilities.
  • Enabled seamless user interaction through a dropdown selection for Order IDs, updating the report dynamically.
Nov 1 2024

Maven Toys
Revenue Trends Dashboard

  • Developed an interactive dashboard to track revenue trends and compare performance across toy stores.
  • Enabled filtering by different regions to identify growing and declining products.
  • Provided insights on seasonal trends and best-performing stores across the country.
Maven Toys Revenue Dashboard
Oct 25 2024

Maven Careers
Career Path Dashboard

  • Created a dashboard to help high school seniors explore career paths by analyzing industry data.
  • Visualized metrics like annual wages and employment pools across various industries.
  • Designed for interactivity to engage students during presentations and highlight trends.
Maven Careers Dashboard
SEP 21 2024

Bollywood Movie Performance Analysis
Using SQL and Power BI

  • Analyzed movie performance data using SQL, generating insights into profitability trends based on genre, release period, and star power.
  • Created a Power BI dashboard to visualize KPIs such as revenue, profit, and budget, providing a clear picture of key performance metrics for decision-making.
  • Evaluated the financial impact of franchise films vs. standalone movies, helping to guide future investments in franchise productions.
Bollywood Movie Performance Analysis
SEP 09 2024

Web Scraping and Data Analysis
Using Python

  • Developed a web scraper using BeautifulSoup (bs4) to extract over 1,000 records from a custom dummy website, enhancing data extraction efficiency by 40%.
  • Cleaned and transformed data with Pandas, improving data accuracy by 35% and streamlining the preprocessing workflow.
  • Automated exploratory data analysis with ydata-profiling, reducing manual analysis time by 60% and providing comprehensive insights for faster decision-making.
Web Scraping and Data Analysis
AUG 26 2024

Fast Food Analysis
Using Power BI

  • Created a comprehensive Power BI dashboard for fast food analysis, showcasing Total Sales, Avg Sales, Max Item Price, Total Quantity, and Number of Orders.
  • Developed 5 interactive dashboards with detailed DAX measures for each item, including Coffee, Vada Pav, Sugarcane Juice, and Panipuri.
  • Performed extensive data validation using SQL queries to ensure accuracy and consistency of the dashboard metrics.
Fast Food Analysis
AUG 2 2024

Car Sales Analysis
Using Python , SQL, Power BI

  • Analyzed Amazon sales data with Python, focusing on performance and profitability.
  • Developed insightful visuals with Power BI to highlight key trends and patterns.
  • Leveraged group by operations extensively to uncover actionable insights and improve data analysis skills.
Amazon Sales Analysis
July 22, 2024

Amazon Sales Analysis
Using Python

Amazon Sales Analysis
  • Analyzed Amazon sales data with Python, focusing on performance and profitability.
  • Developed insightful visuals with Power BI to highlight key trends and patterns.
  • Leveraged group by operations extensively to uncover actionable insights and improve data analysis skills.
Aug 7 2024

Contoso Sales Dashboard
Using Power BI

  • Completed a guided project creating a comprehensive sales dashboard for Contoso using Power BI.
  • Utilized advanced DAX formulas for in-depth analysis of YOY net profit and total sales quantity.
  • Designed interactive visuals to provide actionable insights and enhance data understanding.
July 06, 2024

eCommerce Sales Analysis (Guided)
Using Excel

  • Developed an interactive dashboard in Excel to visualize sales performance across states.
  • Analyzed top-performing subcategories to identify key revenue drivers.
  • Extracted insights into customer preferences and market trends to inform strategic decisions.
  • Enhanced proficiency in Excel and data analysis through practical application in an eCommerce context.
July 25, 2024

Super Store Sales Dashboard (Guided)
Using Power BI

Power BI dashboard project created using the Superstore dataset. The dashboard provides visual insights into sales, profit, and performance metrics, including:

  • Sales by region and segment.
  • Profit analysis by category and state.
  • Performance trends over time.
June 03, 2024

COVID-19 Data Visualization (Coursera)(Guided)
Using Python

Power BI dashboard project created using the Superstore dataset. The dashboard provides visual insights into sales, profit, and performance metrics, including:

  • Completed the COVID-19 Data Visualization Using Python project through Coursera.
  • Utilized Python and libraries like Pandas and Plotly.
  • Analyzed and visualized COVID-19 data for specific region.