PALLAVI JANGA

Detail-oriented Entry-Level Data Analyst with hands-on experience in SQL, Excel, Python, and Power BI. Skilled in data cleaning, dashboard development, exploratory data analysis, and transforming raw data into actionable business insights. A strong ability to combine analytics with AI tools to improve reporting efficiency.

1. Retail Sales Optimization Dashboard using Power BI & SQL 

• Tools: Power BI, SQL, Excel (Power Query, Pivot Tables), ChatGPT
• Description: Developed an interactive Power BI dashboard to analyse multi-store retail sales performance.
• Extracted and cleaned transactional data using SQL (Joins, CTEs, and Window Functions).
• Applied Excel Power Query for data transformation and merging multiple data sources. Designed DAX measures for KPIs such as Sales Growth %, Profit Margin, and Inventory Turnover.
• Integrated ChatGPT to generate automated insights and summaries for weekly management reports. Delivered a 15% improvement in decision-making speed through AI-assisted reporting.
• Key Skills: SQL Optimization, Power BI DAX, Excel Power Query, AI Integration, Data Visualization

2. Customer Churn Prediction & Retention Strategy using Python & AI Tools 

Tools: Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI, Dataiku, MonkeyLearn Description: Built a predictive model to identify potential customer churn for a telecom company.   

• Performed data cleaning and feature engineering using Python (Pandas, NumPy).
• Conducted EDA and visualized churn patterns using Matplotlib and Seaborn.
• Used Dataiku for automated model building and MonkeyLearn for sentiment analysis on customer feedback.
• Created a Power BI dashboard to visualize churn probability and retention KPIs.
• Recommended targeted retention strategies that could reduce churn by 10%.
• Key Skills: Python EDA, Predictive Analytics, AI Tools, Power BI Visualization, Data Storytellin