1. Customer Experience Dashboard
Tools: Power BI, Excel, SQL
Goal: To integrate customer feedback and CRM data into a single dashboard for
performance monitoring.
Actions & Achievements:
• Collected and transformed over 25,000+ survey and CRM records using SQL and
Power Query.
• Automated reporting workflow, reducing manual processing time by 70%.
• Designed five interactive dashboards tracking KPIs like NPS, satisfaction rate, and
response time.
• Improved decision-making efficiency by 40%, enabling managers to act faster on
customer issues.
Skills: Power BI, Data Cleaning, SQL, KPI Reporting, Customer Insight.
2. Sales Forecasting Model
Tools: Python (Pandas, NumPy, Scikit-learn), Power BI
Goal: To build a data-driven model predicting monthly sales and identifying growth
trends.
Actions & Achievements:
• Processed three years of sales data (100k+ transactions) and engineered predictive
features.
• Achieved 92% forecasting accuracy, improving planning and target setting.
• Integrated results with Power BI for dynamic data visualization and trend tracking.
• Contributed to a 15% improvement in budget forecasting accuracy for business teams.
Skills: Python (Machine Learning), Power BI, Data Modelling, Trend Analysis.
3. Customer Segmentation Analysis
Tools: SQL, Power BI, Excel
Goal: To identify high-value and at-risk customers through behaviour-based
segmentation.
Actions & Achievements:
• Performed RFM analysis on 50k+ customer profiles using SQL and Excel functions.
• Segmented customers into behavioural groups, improving campaign targeting
efficiency by 35%.
• Designed Power BI visuals highlighting retention potential and churn probability.
• Supported the marketing team to boost engagement rates by 22% through targeted
initiatives.
Skills: SQL (Joins, Window Functions), Excel (Pivot Tables), Power BI, Customer
Segmentation.
4. Social Media Sentiment Analysis
Tools: Python (TextBlob, NLTK), Power BI
Goal: To evaluate customer perception and satisfaction trends through social media
feedback.
Actions & Achievements: Collected and analyzed over 10,000 online comments from social media and reviews platforms.
• Classified sentiment with 87% accuracy, identifying key improvement themes.
• Presented findings via Power BI dashboards, influencing a 20% increase in positive
engagement.
• Provided actionable feedback that reduced recurring complaint categories by 18%.
• Skills: Python (NLP), Text Mining, Power BI, Data Storytelling.
5. Operational KPI Dashboard (University Research Division)
Tools: Power BI, Python, Excel
Goal: To automate KPI monitoring and enhance reporting for academic performance
tracking.
Actions & Achievements:
• Integrated datasets from multiple Excel files and online systems, processing 10,000+
records.
• Automated data cleaning using Python scripts, reducing reporting errors by 71%.
• Developed KPI dashboards visualizing research progress and stakeholder satisfaction.
• Increased departmental reporting efficiency by 60%, improving decision turnaround
time.
Skills: Power BI, Python (Pandas), Data Governance, KPI Tracking
