# Lakshya Agrawal

Lakshya Agrawal is a remote worker on Himalayas, Flight Analytics Dashboard at GitHub, based in India.

Source: https://himalayas.app/@lakshyaag09

```text
Data Analyst turning messy data into decision-ready dashboards with Python, SQL, and Power BI.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 65k-85k USD |
| Job categories | Data Analyst, Business Intelligence Analyst, Data Engineer, Database Analyst, Analytics Engineer, Associate Data Analyst, Data Analytics Specialist |
| Skills | Data Analysis, Python, Pandas, NumPy, SQL, MySQL, Excel, Power Query, Power BI, Data Modeling, Tableau, Plotly, Matplotlib, SeaBorn, Data Cleaning, Data Wrangling, Feature Engineering, Data Exploration, KPI Reporting, Trend Analysis, Jupyter Notebooks, Streamlit, Git, GitHub, ETL, SQL Databases, EDA, Dashboard Development |
| LinkedIn | https://https://www.linkedin.com/in/lakshya-ag09 |
| GitHub | https://https://github.com/Lakshya-Ag09 |

## What I'm looking for

```text
I’m looking for a role where I can turn raw, messy data into insights and decision-ready dashboards using Python, SQL, and BI tools—building reliable pipelines, clean datasets, and clear visualizations that drive real business decisions.
```

## About

```text
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.
```

## Experience

### Flight Analytics Dashboard

[GitHub](https://himalayas.app/companies/github)

```text
Developed an interactive Streamlit application connected to a live MySQL database to search and analyze 10,683 historical flight records across airlines and cities. Wrote parameterized SQL queries (including GROUP BY, HAVING, and UNION/UNION ALL) and visualized results with Plotly for search, market share, and traffic trend views.
```

Skills: Python, MySQL, Streamlit, SQL, Parameterized-Queries, Group-By, HAVING, Union-All, Data-Aggregation, Plotly, Data-Visualization

### Job Market Intelligence System

[GitHub](https://himalayas.app/companies/github)

```text
Built an end-to-end ETL pipeline that cleaned and restructured 13,691 job postings into an analysis-ready dataset of nearly 11,000 records. Engineered structured role/seniority/salary features and delivered a Power BI dashboard with custom DAX measures for benchmarking and demand insights.
```

Skills: Python, ETL, Data-Cleaning, Data-Wrangling, Feature-Engineering, Power-Query, Power-BI, DAX, Data-Modeling, KPI-Reporting, Trend-Analysis

## Education

### JECRC University

Bachelor of Technology (B.Tech), Computer Science Engineering (AI & ML). 2022 - 2026. Grade: 8.2

Activities and societies: Generate Newsletter, Research Paper

```text
Pursuing a B.Tech in Computer Science Engineering (AI & ML) at JECRC University, with expected completion in 2026.
```

## Tech stack

- Tableau
- GitHub
- Jupyter
- NumPy
- Pandas
- MySQL
- Python
- Streamlit
- Microsoft Excel
- Microsoft Power BI
- SQL
- Seaborn

To contact Lakshya, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Bhargav Barewar](https://himalayas.app/@bhargavbarewar): Data Engineer Consultant, Rubixe AI Solutions
- [Gangi Yaamini](https://himalayas.app/@gangiyaamini): Associate Data Analyst, Entri Software Pvt. Ltd.
- [vineet gupta](https://himalayas.app/@vineetgupta1): Data Analyst, Self Employed
- [Glavin Menezes](https://himalayas.app/@glavinmenezes): Data Analyst Intern, AIVariant
- [Nipun Sharma](https://himalayas.app/@nipunsharma2): Data Analytics Intern, IBM SkillsBuild
- [Priyanka Burra](https://himalayas.app/@priyankaburra): Data Analytics Intern, CodeAlpha
- [Swati Shinde](https://himalayas.app/@swatishinde1): Data Analyst, Self Employed
- [Mohammad Maaz](https://himalayas.app/@mohammadmaaz1): Data Analyst, Self Employed
- [Pradnya Patil](https://himalayas.app/@pradnyapatil1): Data Science Intern, QSpiders / Pyspiders
- [Tarush Nandan](https://himalayas.app/@tarushnandan): Data Analyst, Self Employed
