Data Analyst | SQL · Python · Power BI · AI/RAG
📍 Chennai, India | 📧 deepanshumohanty@gmail.com | 🎓 B.E. CCE @ Rajalakshmi Institute of Technology (2026)
I'm an entry-level Data Analyst who turns messy datasets into clean, actionable insights. I build interactive dashboards, automate data workflows, and lately I've been bridging analytics with AI — building RAG pipelines and LLM-powered tools.
I also co-founded Luminix, a D2C clothing brand where I wore the analyst hat in real-time — tracking Meta Ads performance, managing KPIs, and making data-driven calls that drove ₹1.2L+ in revenue.
| Category | Tools |
|---|---|
| SQL | MySQL, SQLite |
| Python | Pandas, NumPy |
| BI & Visualization | Power BI, DAX, Power Query |
| Excel | Advanced Excel, Pivot Tables, XLOOKUP |
| AI / ML | LangChain, RAG, FAISS, Generative AI |
| Tools | Git, GitHub, Jupyter Notebook, VS Code, Microsoft Fabric |
Excel · SQL · Power BI
Analyzed 466+ orders across 4 regions and 5 product categories. Tracked ₹61.77 Cr in revenue and ₹20.15 Cr in gross profit (avg 34.5% margin). Identified laptops as the #1 category and Q4 as peak quarter. Built dynamic KPI dashboards for regional and category decision support.
Power BI
Interactive dashboard across 3.9K customer records — purchase behavior, review ratings, and category-level trends. Found Clothing as the top revenue driver and Young Adults as the highest-spending segment. Includes dynamic filters for subscription, gender, category, and shipping type.
Power BI · Star Schema
End-to-end BI solution for a food delivery platform. Built a star schema data model (fact + dimension tables) and designed visualizations for monthly revenue trends, restaurant performance, cuisine distribution, and city-level order analysis.
Python · LangChain · FAISS · RAG
RAG-based Q&A app that lets you query unstructured PDFs using natural language. Built with LangChain for orchestration and FAISS for vector search — a practical demo of AI integration for analytics automation.
- 🏅 Power BI Data Analytics 3.0 — Codebasics (May 2026)
- 🏅 Advanced Excel — Codebasics (Jan 2026)
- 🏅 LangChain & AI Agents — Udemy (Oct 2025)
- 🏅 Generative AI with LLMs — Coursera × AWS & DeepLearning.AI (Aug 2025)
- 🏅 Python Bootcamp — Udemy (Mar 2025)
- Deepening Power BI + Microsoft Fabric skills
- Exploring more LLM-powered analytics tools
- Building a portfolio of end-to-end data projects
"Data is the closest thing to having a time machine — it tells you what happened and hints at what's next."