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

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

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

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

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

Technology: Python

Data professional's salary dashboard Using Power BI

Completed: 2024-08-18

Keywords: Dashboard, Report, Analysis

Technology: Power BI

Contoso Sales Dashboard Using Power BI

Completed: 2024-08-07

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

Keywords: PowerBI, Data

Technology: Power BI