Data Analyst Turning Raw Data into Actionable Insights
Helping businesses make smarter, data-driven decisions with Excel, Power BI, Tableau, SQL and Python.
NBA Player Performance & Era Analysis
(Excel)
Performed exploratory analysis on multi-season NBA player statistics using Excel. Used Pivot Tables and Pivot Charts to analyze player performance, compare eras, and identify trends.
Excel Data Cleaning & Dashboard
Cleaned and analyzed raw data using Excel functions, PivotTables, and conditional formatting. Created an interactive dashboard with slicers for better insights.
Power BI Sales Performance Dashboard
Designed an interactive Power BI dashboard highlighting sales trends, top-performing products, profit analysis, and regional insights using DAX measures and data modeling.
Tableau Interactive Sales & Customer Insights
Created a fully interactive Tableau dashboard showing sales performance, customer segments, regional trends, and product-level analytics using filters, parameters, and calculated fields.
Projects
NBA Player Performance Analysis (SQL Project)
Designed and executed an end-to-end SQL data analysis project using NBA player statistics. Cleaned raw data, created structured tables, and wrote optimized SQL queries to extract meaningful insights related to player performance, experience level, and trends.
SQL Data Analysis & Reporting
Wrote complex SQL queries to clean, join, and analyze large datasets. Used aggregate functions, window functions, and subqueries to generate insights for business reporting.
Python Data Analysis & Automation
nalyzed datasets using Python (Pandas, NumPy, Matplotlib) to clean, transform, and visualize data. Automated repetitive tasks and generated reports with optimized scripts.
Address
Lahore, Pakistan, 54000
Phone
- © 2025 Ammara — Data Analyst Portfolio
- Design Template by: HTML5 UP