
Data Analyst
NKP Empire Ventures Pvt Ltd · Jan 2024 – Present
- Designed and maintained 8 Power BI dashboards across sales, customer engagement, and financial KPIs, driving a 12% increase in customer engagement and adoption by 4 cross-functional teams.
- Automated recurring MIS and WoW/MoM sales reporting using Power Query and SQL, reducing report turnaround time by 30%.
- Reduced material wastage by 8% through data-driven wastage and process analysis, delivering measurable cost savings across outlet operations.
- Analysed sales and financial performance data to identify trends and growth opportunities, supporting strategic and operational planning for senior management.
- Planned month-wise targets for stockists, customers, and salespersons based on historical performance, aligning targets to business objectives.
- Prepared Monthly Nielsen-style reports and stockist-wise warehouse allocation plans, streamlining inventory distribution across outlets.
- Built ad-hoc and holiday-period sales forecasting models to support inventory and staffing planning around peak-demand periods.
- Built data visualisations using Advanced Excel (Pivot Tables, Pivot Charts, VLOOKUP, HLOOKUP, Data Validation, Macros) and Google Sheets, reducing manual effort in recurring reporting workflows.
- Collaborated with the marketing team to track promotional scheme participation and campaign performance across outlets, providing data-driven insights that informed pricing and offer strategies.

