Automating Insights with Python + SQL

Transforming raw data into actionable business intelligence.

Python SQL Power BI Excel Automation

Latest Projects

Image for Daily Progress Tracker

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

Keywords: Python, MySQL, Streamlit

Technology: Python ,SQL

Image for Maven ToysRevenue Trends Dashboard

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 insi ... Read More

Keywords: Dashboard, Report, Analysis

Technology: Excel

Image for Maven Careers
Career Path Dashboard

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

Keywords: Dashboard, Report, Analysis

Technology: Excel

Image for Excel-Based Order Data Management and Profit Analysis Report

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-friendl ... Read More

Keywords: Xlookup,Vlookup,Filter,Dropdown,Excel,Reports

Technology: Excel

Image for Bollywood Movie Performance Analysis Using SQL and Power BI

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

Keywords: SQL, PowerBI, Report, Dashboard, Analysis

Technology: SQL, PowerBI

Image for Web Scraping and Data Analysis Using Python

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, imp ... Read More

Keywords: Web-Scrapping, Automation, Data Analysis, Pandas

Technology: Python