Lakshya Agrawal

I’m a Data Analyst with a Computer Science Engineering (AI & ML) background, focused on turning messy, real-world datasets into decision-ready dashboards. I’m comfortable across the full analytics workflow—data cleaning and feature engineering in Python, querying and aggregation in SQL, and dashboard design in Power BI.

In my Job Market Intelligence System project, I built an end-to-end ETL pipeline to clean and restructure 13,691 raw job postings into an analysis-ready dataset of nearly 11,000 records. I engineered role, seniority, and salary features from unstructured text, normalized over 84,000 skill mentions and 15,000 location records, and delivered a 3-page Power BI dashboard with custom DAX measures to surface the most in-demand role and top requested skills.

In my Flight Analytics Dashboard, I built an interactive Streamlit app connected to a live MySQL database to search and analyze 10,683 historical flight records across 12 airlines and 7 cities. I wrote parameterized SQL queries (GROUP BY, HAVING, UNION/UNION ALL) to support market-share and traffic aggregation, then visualized trends using Plotly in an easy, non-technical three-view experience.