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.

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
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
Aug 7 2024

Contoso Sales Dashboard
Using Power BI (Guided)

  • 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 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.
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.