Automating Insights with Python + SQL
Transforming raw data into actionable business intelligence.
Featured Projects
Daily Progress Tracker
Completed: 2025-02-07
Built an automated task tracking system using Streamlit and MySQL to log daily activities and measure progress. Implemented a missing-day detection system that fills in incomplete tasks automatically ... Read More about Daily Progress Tracker
Keywords: Python, MySQL, Streamlit
Technology: Python ,SQL
Maven Careers Career Path Dashboard
Completed: 2024-10-25
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 inter ... Read More about Maven Careers Career Path Dashboard
Keywords: Dashboard, Report, Analysis
Technology: Excel
Fast Food Analysis Using Power BI
Completed: 2024-08-26
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 deta ... Read More about Fast Food Analysis Using Power BI
Keywords: Report, Analysis, Data Analysis, Sales
Technology: Power BI
Comprehensive Superstore Sales Analysis in Excel
Completed: 2024-08-14
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 Ch ... Read More about Comprehensive Superstore Sales Analysis in Excel
Keywords: Excel,Visualization,Dashboards,KPI,Analysis
Technology: Excel
Retail Sales Data Analysis Using SQL
Completed: 2024-07-10
Conducted comprehensive retail sales data analysis using SQL. Extracted and transformed data to generate insights on regional, product, and customer segment performance Generated detailed SQL reports ... Read More about Retail Sales Data Analysis Using SQL
Keywords: Analysis, Data Analysis, PPT
Technology: SQL
Latest Projects
Daily Progress Tracker
Completed: 2025-02-07
Built an automated task tracking system using Streamlit and MySQL to log daily activities and measure progress. Implemented a missing-day detection system that fills in incomplete tasks automatically ... Read More about Daily Progress Tracker
Keywords: Python, MySQL, Streamlit
Technology: Python ,SQL
Maven ToysRevenue Trends Dashboard
Completed: 2024-11-01
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 insigh ... Read More about Maven ToysRevenue Trends Dashboard
Keywords: Dashboard, Report, Analysis
Technology: Excel
Maven Careers Career Path Dashboard
Completed: 2024-10-25
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 inter ... Read More about Maven Careers Career Path Dashboard
Keywords: Dashboard, Report, Analysis
Technology: Excel
Excel-Based Order Data Management and Profit Analysis Report
Completed: 2024-10-15
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 ... Read More about Excel-Based Order Data Management and Profit Analysis Report
Keywords: Xlookup,Vlookup,Filter,Dropdown,Excel,Reports
Technology: Excel
Bollywood Movie Performance Analysis Using SQL and Power BI
Completed: 2024-09-21
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, ... Read More about Bollywood Movie Performance Analysis Using SQL and Power BI
Keywords: SQL, PowerBI, Report, Dashboard, Analysis
Technology: SQL, PowerBI
Web Scraping and Data Analysis Using Python
Completed: 2024-09-04
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, impr ... Read More about Web Scraping and Data Analysis Using Python
Keywords: Web-Scrapping, Automation, Data Analysis, Pandas
Technology: Python