Talha Waheed
Power BI & Data Analytics Specialist
New to Contra
Talha is building their profile!
Superstore Sales & Profit Analysis
Developed a SQL-based sales and profit analysis project using MySQL to clean, validate, analyze, and extract meaningful business insights from the Superstore dataset.
The project involved data cleaning, duplicate detection, date conversion, KPI calculation, sales and profit analysis, product and customer analysis, regional performance analysis, shipping analysis, and discount impact analysis.
Advanced SQL techniques including CTEs, subqueries, JOINs, CASE statements, aggregate functions, and window functions such as RANK, DENSE_RANK, ROW_NUMBER, LAG, and LEAD were used to answer complex business questions and identify performance trends.
Tool: MySQL / MySQL Workbench
Skills: SQL, Data Cleaning, Data Analysis, KPI Analysis, Advanced SQL, Window Functions, CTEs, Joins, Business Insights
3
42
NYC Airbnb Data Cleaning & Analysis
Performed data cleaning and exploratory data analysis on a New York City Airbnb dataset using Python, Pandas, and NumPy.
The project involved handling missing values, duplicate records, invalid prices, data types, and price outliers, followed by analysis of room types, neighbourhoods, pricing, reviews, availability, minimum nights, and hosts.
The analysis generated meaningful insights into Airbnb pricing patterns, listing distribution, room types, neighbourhood performance, and customer review behavior.
Tools: Python, Pandas, NumPy, Jupyter Notebook / Google Colab
Skills: Data Cleaning, Data Preprocessing, Exploratory Data Analysis, Outlier Detection, Data Analysis, Data Visualization, Business Insights
1
40
Inventory Management Dashboard
Created an interactive Inventory Management Dashboard in Microsoft Excel to monitor stock levels, inventory movement, product performance, and overall inventory status.
The project involved data cleaning, formulas, KPI tracking, and dashboard visualization to identify low-stock products, fast-moving items, excess inventory, and stock trends. The dashboard helps businesses monitor inventory efficiently and make better stock planning and purchasing decisions.
Tool: Microsoft Excel
Skills: Data Cleaning, Inventory Analysis, Excel Formulas, KPI Tracking, Data Visualization, Dashboard Development
1
52
Superstore Sales Analytics
Developed an end-to-end sales analytics project using SQL and Power BI to analyze Superstore sales data and generate meaningful business insights. The project involved data cleaning, transformation, SQL analysis, KPI creation, and interactive dashboard development.
The analysis focused on sales and profit performance, regional trends, product categories, customer segments, and overall business performance. Interactive Power BI visualizations and filters were used to make the data easy to explore and support data-driven decision-making.
Tools: SQL, Power BI, Excel, DAX
Skills: Data Cleaning, Data Analysis, SQL Queries, Data Visualization, Dashboard Development, Business Insights
0
26