📊 Data Analytics Portfolio Aamir Waqas
🚀 Data Analyst | Power BI Specialist | Python & SQL Expert
I specialize in transforming raw, disconnected data into actionable business intelligence. My expertise spans the full analytics lifecycle, from automated ETL pipelines in Python and relational data modeling in SQL to advanced Power BI reporting and insight-driven storytelling. I focus on building scalable, decision-ready analytics solutions that drive operational efficiency and business growth.
🛠️ Technical Toolkit Data Visualization & BI
Power BI with advanced DAX, Power Query, star schema modeling, KPI development, and interactive dashboards.
Data Cleaning & Automation
Python using Pandas and NumPy, along with Excel Power Pivot and automation techniques to ensure data accuracy and repeatability.
Database Management
SQL and MySQL including relational design, joins, aggregations, window functions, and DDL/DML operations.
Business Analytics
KPI benchmarking, trend analysis, performance monitoring, and operational reporting.
Featured Analytics Projects 📁Hospital ER Operational Efficiency (Excel-Power BI)
Analyzed over 9,200 patient visits to uncover bottlenecks in emergency room service delivery. Built advanced DAX measures to track the 80 percent service timeliness target and designed a star schema model to improve performance and drill-down analysis.
📁Credit Card Financial Performance (Excel,Power BI)
Visualized 55 million dollars in revenue and transaction behavior for a financial institution. Segmented customers by income, profession, and education to identify high-value segments and evaluated online versus swipe transaction patterns to support digital adoption strategies.
📁Marketing Campaign Data Quality Pipeline (python,numpy,pandas)
Developed an automated Python pipeline to clean and standardize messy marketing datasets. Resolved critical data integrity issues including typos, currency formatting, and logical inconsistencies. Analyzed 3.18 million dollars in ad spend to report ROI across Meta, Google, and TikTok platforms.
📁SQL Bookstore Management & Analytics (MySql
Designed a relational database for books, customers, and orders. Built complex SQL queries using joins and aggregations to generate insights on revenue, inventory availability, and customer purchasing behavior.
🧠 Core Competencies
Power BI with advanced DAX, data modeling, and row-level security SQL with complex queries and relational database design Python for data manipulation, automation, and analysis Excel for advanced dashboards and analytical workflows
🌐 Let’s Connect
I am always open to discussing data-driven strategies, project collaborations, and career opportunities.
📧 Email: aamirtrue7319@gmail.com
🐦 Twitter: @AIwith_Aamir 💼 Portfolio: GitHub Profile
“Data doesn’t lie. It just needs the right analyst to tell its story.”