Hi, I'm Asma Shaik 👋
I am an aspiring Data Analyst with practical experience in SQL, Power BI, and Python.
This repository showcases my end-to-end analytics projects where I work with raw datasets, prepare data, build models, create dashboards, and generate business insights.
My focus is on turning data into clear, decision-support information for stakeholders.
Languages & Querying
- SQL
- Python
Data Processing
- Pandas
- NumPy
Visualization & BI
- Power BI
- Matplotlib
- Seaborn
Concepts
- Data Cleaning & Transformation
- Exploratory Data Analysis (EDA)
- KPI & Trend Analysis
- Dashboard Design
- Business Insight Generation
Tools
- GitHub
- Jupyter Notebook
- SQL Server
Data_Analytics_Portfolio/
│
├── PowerBI_Projects/
├── Python_Projects/
├── SQL_Projects/
└── API_Data_Analysis_Projects/
Each folder contains project-specific datasets, scripts, reports, dashboards, and documentation.
Goal: Analyze transaction behavior, revenue performance, activation, and delinquency trends.
Highlights:
- SQL used for schema setup and data staging
- Power Query for cleaning & shaping
- DAX measures for KPIs
- Week-over-Week and Year-to-Date analysis
- Customer and card segmentation
📁 PowerBI_Projects/Credit_Card_Financial_Analytics
Goal: Evaluate sales, profit, and regional/category performance.
Highlights:
- Time series trend analysis
- 15-days sales forecasting
- Regional comparisons
- Category & sub-category profitability
- Executive-style interactive dashboard
📁 PowerBI_Projects/superstore_sales_dashboard
Goal: Understand workforce patterns and factors affecting retention.
Highlights:
- Data cleaning with Pandas
- Exploratory analysis
- Attrition and demographic insights
- Business recommendations
📁 Python_Projects/HR_Analytics_Employee_Performance_and_Retention
Goal: Identify purchasing behavior and key revenue drivers during festive sales.
Highlights:
- Customer segmentation
- Regional contribution
- Occupation and age analysis
- Category performance
📁 Python_Projects/Sales_Analytics_Diwali_Retail
Goal: Collect and analyze real-time weather data using an external API.
Highlights:
- Data extraction from API
- JSON handling and transformation
- Trend and condition analysis
- Data preparation for reporting and visualization
📁 API_Data_Analysis_Projects/Weather_Data_Analysis
Goal: Explore patterns in animal sleep, lifespan, and biological characteristics.
Highlights:
- Data exploration and cleaning
- Comparative species analysis
- Identification of behavioral trends
- Insight generation from structured datasets
📁 Python_Projects/Animal_Sleep_Analysis
Goal: Practice SQL querying, aggregations, joins, and business reporting.
Highlights:
- GROUP BY & HAVING
- Subqueries
- Customer and revenue insights
📁 SQL_Projects
Through these projects, I demonstrate the ability to:
- Work with structured and raw datasets
- Prepare and transform data for analysis
- Build analytical models
- Create meaningful dashboards
- Communicate insights clearly
- Organize projects using professional repository practices
I am actively looking for opportunities as a Junior Data Analyst.
If my work aligns with your needs, I would love to connect and discuss how I can contribute to your team.