- π I'm a Data Analyst AND AI Engineer passionate about uncovering stories hidden in data
- π I work primarily with Python for data analysis, visualization & automation
- π I love transforming raw data into actionable insights and beautiful dashboards
- π± Always learning - currently exploring Machine Learning & Predictive Analytics
- π¬ Ask me about Python, Data Analysis, SQL, or Data Visualization
- π« Reach me at: palakshay071@gmail.com
A production-style Data Engineering workflow β from raw CSV ingestion through Python-based data cleaning, cloud database loading on AWS EC2, and advanced SQL analytics on a music streaming dataset.
- Goal: Build a complete data pipeline: ingest raw play data, clean it with Python & Pandas, load into cloud-hosted PostgreSQL, and extract insights using SQL joins, aggregations, and window functions.
- Tools:
PythonPostgreSQLAWS EC2PandasSQL - Highlights: 14 raw records ingested β 10 clean records loaded to DB | 7 SQL queries written | 3 tables & 3 indexes created
A real-world business intelligence workflow β from raw data ingestion to executive-level dashboard reporting, covering data engineering, SQL analytics, KPIs, customer segmentation, and revenue forecasting.
- Dataset: 5,000 synthetic transactions | 30 products | 2,859 unique customers | May 2025 β May 2026
- Tools:
PythonPostgreSQLPower BISQLETL - Highlights: Identified top-selling categories, low-performing months, and revenue concentration risks to drive strategic business decisions
Analyzed whether market sentiment β Fear, Neutral, or Greed β has a measurable impact on trader PnL, win rate, and trade size to extract actionable strategy insights from real trading data.
- Tools:
PythonPandasJupyterPower BI - Highlights: Greed β higher PnL & win rate | Fear β higher losses & lower win rate | Large trades generate significantly higher returns
βοΈ If you find my work interesting, consider starring some repositories! βοΈ
