Devashish Choudhary

🚀 Data Analyst | Insight-Driven | Business-Savvy
I turn raw data into razor-sharp insights that drive smart decisions.
As a passionate data analyst with a sharp analytical mindset and a relentless curiosity, I specialize in transforming complex data into clear, actionable narratives.

From crafting dynamic dashboards in Power BI/Tableau to writing optimized SQL queries and building data pipelines in Python, I bring both technical depth and business understanding to the table. Whether it's cleaning messy datasets, spotting trends that others miss, or presenting findings that influence strategy, I bridge the gap between data and decisions.

Key skills: Python, SQL, Excel, Tableau, Power BI, Pandas, NumPy, A/B Testing, Data Visualization, Statistical Analysis
Focus areas: Business Analytics, Performance Tracking, Forecasting, Operations, Customer Insights
Let's make your data speak — clearly, confidently, and impactfully.

Programming and Scripting
- Python (Pandas, NumPy, Scikit-learn)
- SQL (Joins, Window Functions, Query Optimization)
Data Visualization
- Power BI (DAX, Power Query)
- Tableau (Basic)
- Excel (Advanced: Pivot Tables, VLOOKUP, Macros)
Statistics & Machine Learning
- Regression
- Classification
- Clustering
- A/B Testing
- Time Series Forecasting
Data Processing & Automation
- ETL
- Data Wrangling
- Workflow Automation
- Alteryx (Basic)
Tools & Platforms
- Jupyter Notebook
- Git
- VS Code
- PowerPoint (Dashboarding & Storytelling)
- SPSS (Basic)
Soft Skills
- Communication
- Problem-Solving
- Adaptability
- Collaboration
- Analytical Thinking
- Presentation Skills
- Leadership

Sales Forecasting & Inventory Optimization

Developed a time-series forecasting model using ARIMA and Prophet, predicting monthly sales with 92% accuracy, reducing overstocking costs by 25%.
Designed an interactive Power BI dashboard with DAX measures to track KPIs (customer retention, revenue trends), cutting manual reporting time by 40%.
Insurance Claims Risk Analysis

Analyzed 50,000+ insurance claims using SQL joins and subqueries, identifying high-risk demographics and improving fraud detection by 20%.
Created dynamic Power BI dashboards with drill-through filters to visualize claim approval ratios for stakeholders.
UPI Transactions Data Analysis

Processed 1M+ UPI transactions using SQL aggregation functions (GROUP BY, PARTITION BY) to identify peak usage hours and top merchant categories.
Cleaned data by addressing missing timestamps (5% of data) and flagged outliers using SQL window functions.
Credit Risk Analysis

Developed a credit scoring model to evaluate the credit-worthiness of borrowers and identify potential default risks.
Stock Market Forecasting

Gathered and analyzed historical financial data, identified relevant features, and trained the model to make accurate predictions.
Real Estate Price Prediction

Developed a web app with regression model laoded to predict house prices in Bangalore, leveraging various features such as location, square footage, amenities, and proximity to essential facilities.
Used Car Price Forecast

Web app for predicting used car's current market price. Enter the details of the car such as number of previous owners , kilometres driven , type fo engine and predict the approximate current market price .
Email Spam Classifier

The Email Spam Classifier project aims to develop a machine learning model capable of accurately identifying and classifying emails as spam or non-spam (ham).
Flight Price Estimste

Estimated the price of flight ticket using factors such as dates of travelling , place of boarding and destination.
Exploratory Data Analysis on Indian Premier League

To analyze the performance of teams and players in different seasons of the IPL. To identify the key factors that contribute to a team's success in the tournament.