Irshaad Sheikh

Projects

When I first began my journey into the IT world, I was fortunate to gain hands-on experience through several freelance projects and collaborations. At that stage, I valued the learning and practical exposure more than financial reward, which allowed me to quickly build essential professional skills. These projects not only sharpened my technical abilities in data analysis and automation, but also gave me the confidence to deliver real value in a business context.

Businessman using laptop with document online for approve quality assurance and ERP management, Quality management with assurance, Quality control and improvement.
Digital tablet with sample spreadsheet document on the screen

Excel Sales Summary

Description:
Cleaned and structured a dataset of ~500 shop transactions. Built PivotTables and bar charts to show monthly revenue and best-selling products.

Skills & Tools:
Excel | PivotTables | SUMIF | Charts

Outcome:
Client received a one-page sales overview for management reporting.

Check marks on checklist and fill out online form or answer questions. Survey steps grade selection with quality assurance improvement form. Compliance with regulations product, service and standard.

Customer List Cleanup

Description:
Normalized a customer database with ~1,200 entries. Removed duplicates, standardized email formats, and created a dashboard showing new vs. returning customers.

Skills & Tools:
Excel | Data Cleaning | Conditional Formatting

Outcome:
Improved accuracy of customer records by 95%.

Man analyze data, business plan information and business growth chart to analysis for project strategy on laptop computer at home office

SQL Order Analysis

Description:
Wrote SQL queries for ~10,000 e-commerce orders. Identified top 5 products, calculated average order value, and segmented repeat customers.

Skills & Tools:
SQL | SELECT | GROUP BY | JOIN

Outcome:
Delivered a report highlighting revenue drivers and customer loyalty.

Business intelligence and analysis reports.

Power BI Sales Dashboard

Description:
Created an interactive dashboard for 12 months of sales (~5 categories). Included slicers for product and month, and visuals for total revenue, growth trend, and category comparison.

Skills & Tools:
Power BI | Power Query | Interactive Visualizations

Outcome:
Gave management a clear, visual overview of performance trends.

Automation and Optimization of Business Processes with Gears

Invoice Tracker Automation

Description:
Developed an Excel sheet that automatically logs invoices with formulas and highlights overdue payments. Added a summary page with monthly totals.

Skills & Tools:
Excel | SUMIF | Conditional Formatting

Outcome:
Reduced manual tracking effort and improved payment visibility.

Marketing strategy

Customer Segmentation Report

Description:
Analyzed ~3,000 customer records. Segmented customers by spending (low, medium, high) and visualized distribution in Power BI with pie and bar charts.

Skills & Tools:
Power BI | Excel | Data Cleaning

Outcome:
Helped identify that 20% of customers generated ~65% of revenue.