Appu Anand | Data Analyst Portfolio

About Me

I’m Appu Anand, a data analyst with a strong focus on bridging business goals and data-driven insights.I specialize in Power BI, Python, SQL, and Excel transforming raw data into powerful visual narratives and evidence based strategies.

My expertise lies in building interactive dashboards, uncovering performance drivers, and optimizing decision-making through analytics.I thrive on simplifying complexity, ensuring that every metric tells a story that matters.

Beyond analysis, I’m passionate about continuous learning exploring simulations, advanced visualizations, and emerging analytics tools to stay ahead in the evolving world of data intelligence.

My Toolkit

My Work

Sales Performance RCA

Automated weekly RCA pipeline with row-level security and dashboards adopted by regional managers — improved planning speed and accuracy.

Marketing ROI Insights

Developed Marketing ROI Dashboard in Power BI — tracks campaign performance, conversion efficiency, and profitability insights using real-world marketing data..

Fraud Detection

Built an ML pipeline and Streamlit ops dashboard; optimized thresholding to reduce false positives while maintaining high recall (92% precision).

Customer Segmentation

RFM analysis used to segment a customer base for targeted marketing campaigns, significantly improving campaign ROI.

QSR Customer Journey

Behavioral segmentation and funnel analysis leading to targeted experiments that increased engagement metrics during pilots.

Bike Sales Analysis

Exploratory Data Analysis and Dashboard design to track regional sales performance, inventory, and customer demographics.

Certifications

IBM Data Analysis Using Python

Applied Python for advanced data wrangling, exploration, and insight generation.

IBM Data Visualization Using Python

Designed interactive dashboards and compelling visuals using Python libraries.

CISCO Data Analytics Essentials

Built analytical models with pandas, matplotlib, and statistical methods to support decision-making.

Statistics

Applied statistical concepts to analyze trends, correlations, and data distributions effectively.

Career Essentials in Data Analysis by Microsoft and Linkedin

Developed end-to-end analytical workflows integrating Excel, Power BI, and Python.

SQL and Relational Databases

Crafted optimized SQL queries for managing and analyzing structured datasets.

Architecting with Google

Gained expertise in designing scalable, cloud-based data systems on Google Cloud.

1 Million Prompters Initiative

Utilized prompt engineering techniques to enhance AI-driven data analysis and storytelling.

Simulations

Data Analytics Simulation

Utilized customer analytics and data preparation on transaction data to deliver commercial recommendations, benchmark stores for uplift testing, and generate strategic reports.

TATA GenAI Powered Simulation

Applied AI-powered data analytics and GenAI tools to conduct EDA, propose a no-code predictive modeling framework for delinquency risk, and design an agentic AI collections strategy incorporating ethical AI principles.

Deloitte Data Analytics Simulation

Performed forensic data analysis and classification using Excel, culminating in the development of a Tableau dashboard to present business conclusions.

TATA Data Visualization Simulation

Developed data visuals and prepared executive meeting questions to support effective decision-making for Tata Consultancy Services.

Accenture Simulation

Advised a social media client by cleaning, modeling, and analyzing 7 datasets to uncover content trends, presenting strategic insights via PowerPoint and video.

Contact

Interested in collaborating or hiring me for analytics projects?
Let’s connect through the links below.

Turning Data into Decisions