Diksha Dahiya

Email Campaign Analysis

• Analysed historical email campaign data and strategised to improve campaign performance and increase email penetration
• Improved email open rates by 20% by segregating and selectively targeting inactive users with new re-engagement strategies
• Orchestrated campaign 360 dashboard highlighting all the key metrics like open, click, send, bounce at campaign level.

Store Performance Index

• Generated and presented business insights by vertically analysing the time series data of retail transactions of the stores.
• Improved performance strategy implementation TAT by 50% by re-engineering KPI dashboard to 6 hr refresh frequency
• Assisted business heads in store segmentation basis performance metrics (e.g., sales, profit).
• Deep divided into stores historical transactional data, defined KPIs and presented insights to Business stakeholders.

• Took time off to prepare and attempt Civil Services Examinations – appeared for 3 attempts.
• Cleared Preliminary Examination given by 10 Lakh candidates in 2022; Appeared for CSE Mains Examination in 2022 moulded myself into a well-rounded smart individual who understands issues from holistic as well as a deeper perspective.
• Developed analytical and critical thinking abilities to source practical solutions to problems over short, medium & long term

• Developed and shared knowledge-based content on data analysis schemas on Python, SQL, DAX, PowerBI, MS ExcelGenerated KPI metrics reports through statistical analyses of the projects and assessment data.
• Hosted industry expert-led workshops to share their expertise and knowledge of analytics and its application in modern business.

Sales Analysis Project

• Developed road-to-profitability strategy for US based retail chain by analysing the annual sales data of 1000+ stores.
• Generated various analytics reports like dashboards and charts by feeding the sales data on MS-Excel