Deepanshu Mohanty

Data Analyst

[email protected] +91 9489102831

Resume

Hello, I am

Deepanshu Mohanty.

1

Excel
Project

2

PowerBI
Projects

1

Python
Project

About Me

Aspiring Data Analyst with hands-on experience in SQL, Python, Excel, and Power BI, specializing in transforming raw data into actionable business insights. Skilled in data cleaning, exploratory data analysis, data visualization, and dashboard development with a strong focus on business intelligence and KPI reporting. Experienced in building interactive dashboards, designing data models, and identifying trends that support data-driven decision-making. Passionate about solving real-world business problems through analytics, storytelling, and modern data technologies while continuously improving technical and analytical skills.

Key Skills

SQL

Python

Power BI

Advanced Excel

Data Analysis

Data Visualization

Dashboard Development

Exploratory Data Analysis (EDA)

Power Query

DAX

My Projects

Excel-Sales-Dashboard

Domain/Function: Sales Analytics / Business Intelligence

Customer Behavior Dashboard

Domain/Function: Customer Analytics / Business Intelligence

Food Delivery Analytics Dashboard

Domain/Function: Food & Beverage Analytics

AI-Powered Interview Simulation System using RAG & LLMs - Generative AI / Natural Language Processing

Domain/Function: Generative AI / NLP

My Experience

Project-Based Data Analyst Experience | 2025 – Present

Worked on multiple end-to-end data analytics projects involving sales, customer behavior, and operational datasets using SQL, Python, Excel, and Power BI. Performed data cleaning, transformation, and exploratory analysis to uncover business insights and improve reporting accuracy. Built interactive dashboards with KPI tracking, trend analysis, and dynamic visualizations to support business decision-making. Designed star schema data models, created DAX measures, and automated reporting workflows using Power Query and Python (pandas). Delivered business-focused insights through data storytelling and developed practical analytics solutions including AI-powered document retrieval systems using LangChain and FAISS.

Customer Behavior Dashboard - Interactive Dashboard

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Udemy Certificate in Python Programming Language

Generative AI with Large Language Models

LangChain – Develop AI Agents with LangChain & LangGraph

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/deepanshu-mohanty-00b6b4266/

Call Me

+91 9489102831

GitHub

https://github.com/Deepanshu4284

Excel Project

Excel-Sales-Dashboard

Domain/Function: Sales Analytics / Business Intelligence

Built an interactive Excel-based sales performance dashboard to analyze revenue, profit, regional trends, and product performance using advanced Excel formulas, pivot tables, conditional formatting, and data visualizations for business insights and reporting.

View Project
on GitHUB

View Project
on Microsoft Excel

Regional sales dashboard analyzing quarterly revenue, profit, and margin across North, South, East, and West regions using comparative bar charts and conditional formatting to highlight profitability trends and business insights.

Product performance dashboard comparing revenue, COGS, gross profit, and margins across categories using ranked analysis, data bars, and horizontal charts to identify top-performing products and profitability trends for business insights.

Project Details

I developed an end to end Excel Business Intelligence dashboard, for sales performance, profitability, and those regional tendencies, using 600 + rows of actual transactional data . I built KPI dashboards, to monitor Total Revenue, Gross Profit, Margin % and Orders, more like a living snapshot, not just a static report. I used those more advanced Excel functions like XLOOKUP, INDEX MATCH, SUMPRODUCT, SUMIF and RANK, so the analysis stays dynamic and responsive. I also made interactive charts, did product performance breakdown, and put together regional sales reports with conditional formatting and data visualization approaches, so business decisions can be made with clearer context.

PowerBI Project

Customer Behavior Dashboard

Domain/Function: Customer Analytics / Business Intelligence

Built an interactive Power BI dashboard analyzing customer purchase behavior, subscription trends, revenue by category, and age-group sales insights using dynamic visualizations and filtering features.

View Project
on GitHUB

Other Tools

Power Query

DAX

Data Visualization

Interactive customer behavior dashboard analyzing customer demographics, subscription trends, category-wise revenue, and age-group sales using KPI cards, dynamic filters, and visual analytics for business insights.

Raw customer shopping dataset containing customer demographics, purchase behavior, product categories, payment methods, subscription status, shipping preferences, and review ratings used for customer analytics and dashboard visualization in Power BI.

Project Details

Built an interactive customer analytics dashboard using Power BI to analyze purchase behavior, customer demographics, subscription trends, and category-level sales performance. Analyzed 3.9K customer records and created KPI cards, revenue insights, and age-group analysis dashboards using dynamic filters, DAX measures, and interactive visualizations for business-focused decision-making.

Live Interactive Dashboard

PowerBI Project

Food Delivery Analytics Dashboard

Domain/Function: Food & Beverage Analytics

Designed an interactive Power BI dashboard analyzing 149K+ food delivery orders and $48M+ in revenue across major cities. Built a robust star schema data model and custom DAX measures to track key metrics like average order value, cancellation rates, and popular cuisines.

View Project
on GitHUB

Other Tools

power query

DAX

Data Modeling

Interactive Power BI dashboard for food delivery analytics featuring revenue, orders, customer insights, restaurant rankings, cuisine trends, city-wise distribution, cancellations, and monthly trends using DAX and data modeling.

Star schema data model for a Food Delivery Analytics Dashboard in Power BI with fact and dimension tables for customers, restaurants, menu items, delivery partners, ratings, orders, and delivery performance analytics.

Project Details

Developed an interactive Food Delivery Analytics Dashboard in Power BI to analyze business performance across orders, revenue, customer behavior, restaurant performance, and delivery operations. Built a star schema data model with fact and dimension tables, implemented DAX measures for KPIs such as Total Revenue, Average Order Value, Cancellation Rate, Delivery Time, and Ratings, and created dynamic visualizations including revenue trends, cuisine analysis, city-wise order distribution, and top restaurant rankings. Applied data cleaning, transformation, relationship modeling, time intelligence, and dashboard design principles to generate actionable business insights through an executive-level BI dashboard.

Live Interactive Dashboard

Python Project

AI-Powered Interview Simulation System using RAG & LLMs - Generative AI / Natural Language Processing

Domain/Function: Generative AI / NLP

Developed an AI-powered interview simulation platform using LLMs, RAG, FAISS, and LangChain to generate context-aware interview questions, evaluate responses, and track performance through a FastAPI backend with semantic search and NLP-based scoring.

View Project
on GitHUB

View Project
on Generative AI

Other Tools

Python

RAG

FAISS

LangChain

SQLite

AI Interview Simulator dashboard showcasing resume analysis, skill extraction, AI-generated technical interview questions, and real-time interview interaction using RAG, LLMs, FastAPI, FAISS, and NLP-based contextual evaluation.

FastAPI backend API response displaying successful resume upload, skill extraction, document indexing, and semantic processing for the AI Interview Simulation System using NLP, embeddings, RAG architecture, and vector-based retrieval.

Project Details

Developed an AI-powered interview simulation platform using Large Language Models (LLMs) and Retrieval-Augmented Generation (RAG) to create personalized and context-aware interview experiences. Built an NLP pipeline with spaCy, FAISS, and LangChain for semantic search and intelligent question generation. Designed a FastAPI backend integrated with SQLite for automated response evaluation, score tracking, and performance analytics. Implemented prompt engineering and vector search techniques to improve conversational accuracy and relevance. The system simulates real interview scenarios, provides instant feedback, and helps users enhance technical and communication skills through AI-driven assessments.