Appu AnandMIS Executive & Data Analyst

Open to Data Analyst · BI Analyst · MIS Analyst roles

Numbers don't
report themselves.
I make them.

I'm Appu Anand, an MIS Executive and Data Analyst. I take scattered operational data — dealership orders, annotation logs, customer journeys — and turn it into reporting people actually act on, with Power BI, SQL, and Python.

See the work Download résumé

2+Years experience

3Industries

6Shipped projects

8Certifications

LIVE METRICS · TRACKING NOW

↳ tracked monthly, 3 dealerships

Enquiry → Order conversion

0cases

↓ down from 58

Registration pendency, open

↑ faster MIS delivery

Reporting turnaround gain

0sites

↳ centralized reporting

Dealership showrooms covered

Reporting turnaround trend — steady improvement quarter over quarter.

appu_anand.dashboard● Available for hire

Run it yourself

Don't take my word.
Query it.

Every result below is a real, verified number from my actual work — the same numbers on my résumé. Pick a query.

appu_anand.sql

About

Who's behind
the dashboard.

Trivandrum, Kerala · Based in India

I turn operational noise into decisions someone can actually make.

That's meant tracking Toyota dealership orders and market share across three showrooms, leading annotation review for Smart City data collection, and mapping QSR customer journeys — different industries, same core job: find the signal, structure it, report it clearly.

Day to day that means Power BI dashboards, SQL queries, Python automation, and a lot of Excel that used to be manual and isn't anymore. I'm currently completing an MBA in Business Analytics at Amrita Vishwa Vidyapeetham alongside my work as MIS Executive.

Core instruments

Power BI SQL Python (Pandas) DAX Tableau Advanced Excel

Reporting & MIS

MIS Reporting Dashboard Development KPI Monitoring Report Automation Data Validation

Business analysis

Root Cause Analysis Market Share Analysis Sales Performance Stakeholder Management

Experience

Where the reports
came from.

Nov 2025 — Present

MIS Executive

Nippon Motor Corporation Pvt. Ltd., Kerala

Centralized daily order listing and Toyota market share reporting across three dealerships using RTO registration data, replacing fragmented manual tracking.
Track monthly enquiry-to-order conversion (38%) across sales officers, giving management visibility into team performance and pending orders.
Track weekly registration pendency and test drive activity through KPI-based reports — helped drive pendency down from 58 to 16 cases.

Nov 2023 — Apr 2025

Junior Lead – Data Analysis

Cogniphi Technologies

Automated manual data processing using Python, reducing manual effort by 35%.
Led a team of 10 on Smart City annotation work, reducing annotation errors by 20%.
Built Power BI dashboards with DAX measures reporting annotation quality, throughput, and team performance for Smart City stakeholders.

Apr 2023 — Oct 2023

Data Analyst

Cogniphi Technologies

Analyzed QSR customer journey and drive-through data to build dashboards supporting AI model development for engineering and testing teams.

Projects

Built end to end,
not just diagrammed.

Power BI · Excel · DAX

Retail Sales Root Cause Dashboard

Integrated revenue, profit, discount, and delivery data to isolate root causes of declining profitability. Found that high discounting (21%+) in the Technology category and delayed deliveries drove a South-region profit drop after July 2024.

View on GitHub

Power BI · Excel · DAX

Marketing ROI Dashboard

Tracks ROI, conversion rate, cost per conversion, and revenue per customer. Found mobile campaigns delivering 2.1x ROI on just 40% of spend — a ~15% projected ROI gain from reallocating budget.

View on GitHub

XGBoost · SMOTE · SHAP · Streamlit

Fraud Detection Explorer

End-to-end pipeline: XGBoost for classification, SMOTE for class imbalance, and an interactive Streamlit dashboard with SHAP-based model explainability.

View on GitHub

Power BI · SQL

QSR Customer Journey Dashboard

Operational dashboard mapping customer wait times, peak-hour demand, and service throughput to give operations leadership clear efficiency levers.

View on GitHub

Python · RFM · KMeans

Customer Segmentation & Personas

Segmentation model using RFM analysis and KMeans clustering to isolate high-value customer cohorts and behavioral patterns invisible in aggregate reporting.

View on GitHub

Power BI · Python · EDA

Bike Sales Analysis

Exploratory analysis and dashboard covering the Indian bike resale market — regional performance, inventory patterns, and customer demographics across categories.

View on GitHub

Training log