portfolio

👋 Hi, I’m Abdur Rehman

💼 Data Analyst Portfolio

Data Analyst Power BI SQL Excel Python

I specialize in transforming raw data into actionable business insights using dashboards, analytics and reporting systems.

I am a Data Analyst passionate about turning raw data into meaningful business insights. I enjoy working with data to solve real world business problems using Power BI, SQL, Excel, and Python. My goal is to help businesses make better decisions through data driven strategies.

🧠 Skills

📊 Technical Skills

📈 Data Analytics Skills

🧩 Soft Skills

🚀 Additional Skills

📊 Projects

🔹 E-Commerce Store Dashboard

Tools: Power BI · Excel · SQL
▸ Analyzed 5,901 orders covering profit, cost, returns, and customer segments (2019–2020).
▸ Identified $92K in losses across product categories, leading to pricing and inventory optimization decisions.
▸ Delivered insights to improve profitability and reduce operational inefficiencies. 🔗 [View Project] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/ecomerce.pbix 🔗 [View Project Screenshot] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/Screenshot%202026-04-27%20001100.png

🔹 Panda Delivery App — Grocery Sales Analytics

Tools: Power BI · Excel · SQL
▸ Processed 8,500+ transactions across Fruits, Dairy, and Snacks categories.
▸ Identified demand gaps and stock inefficiencies across product categories.
▸ Supported restocking strategy and improved supply planning decisions. 🔗 [View Project] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/panda_delivery_app.pbix 🔗 [View Project Screenshot] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/Screenshot%202026-04-27%20001129.png

🔹 Abdur Car Showroom — Customer Analytics

Tools: Power BI · Excel · SQL - Python
▸ Analyzed 24,000+ customer records based on demographics, income, and preferences.
▸ Built customer segmentation model for targeted dealership marketing.
▸ Improved understanding of high-value customer profiles for business growth. 🔗 [View Project] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/abdur%20car%20showroom.pbix 🔗 [View Project Screenshot] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/Screenshot%202026-04-27%20001233.png

🔹 Client Store Data — Vendor & Sales Intelligence

Tools: Power BI · Excel · SQL · Python
▸ Analyzed $452M in sales vs $321.9M in purchases to evaluate business performance.
▸ Identified vendor concentration risks and dependency issues.
▸ Tracked quarterly KPIs to support strategic decision-making. 🔗 [View Project] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/Client%20Project.pdf 🔗 [View Project Screenshot] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/Screenshot%202026-04-27%20000941.png

🔹 SQL Project — Customer & Sales Analysis

Tools: SQL (PostgreSQL)
▸ Wrote complex queries using joins, subqueries, and aggregations.
▸ Extracted insights on customer behavior, revenue trends, and top products.
▸ Built analytical views to support reporting and decision-making. 🔗 [View Project] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/SQL%20Project.pdf 🔗 [View Project Screenshot]

🔹 Excel Project — Business KPI Dashboard

Tools: Excel
▸ Built an interactive dashboard using Pivot Tables and charts.
▸ Tracked sales performance, profit trends, and category-level KPIs.
▸ Automated reporting structure for faster business analysis. 🔗 [View Project] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/excel%20dashboard.xlsx 🔗 [View Project Screenshot] https://github.com/kcqbiqoqcemhcqwbjxlw-jpg/rehman.github.io/blob/main/Screenshot%202026-04-27%20001414.png

🎯 What I Do

⭐ Turning data into decisions that drive business growth.

This site is open source. Improve this page.