- Deep expertise in Power BI, Power Query, DAX, SQL, and interactive dashboard creation with a proven track record of building data and reporting infrastructure from the ground up. Skilled in designing and developing real-time, actionable insights into key performance indicators (KPIs) for data-driven decision-making. Built automated workflows and data refresh strategies to ensure up-to-date insights without manual intervention.
Key Projects:
1. Customer Engagement Plan Dashboard for AI Projects:
- Spearheaded an internal project to extract, transform, and clean customer engagement plan data, improving reporting accuracy by 30%.
- Designed and developed a Customer Engagement Plan Dashboard, providing stakeholders actionable insights into customer trends, market dynamics, and project statuses.
Created tailored visualizations:
- Customer Trends Chart that enhanced strategic planning by 15%.
- Market Trends Visualization with drill-down capabilities, improving market analysis efficiency.
- Stacked Chart for Agricultural Activities, simplifying tracking by categorizing monthly activities.
- Project Status Dashboard to monitor project lifecycle stages, boosting visibility and decision-making by 25%.
2. Ticket Metrics Dashboard:
- Developed a comprehensive Ticket Metrics Dashboard for Therapy brands to monitor customer support, technical support, and product defect reduction.
- Designed reports to track key metrics: new tickets, beginning-of-month open tickets, resolved tickets, and end-of-month open tickets.
- Leveraged advanced DAX techniques like calculated columns, measures, and time intelligence functions to analyze ticket lifecycle stages and support decision-making.
- Automated data refresh workflows, updating reports on the 1st of every month at 12 AM, cutting manual reporting effort by 30%.
- Improved operational efficiency and customer satisfaction by reducing ticket resolution time by 15%
- Collaborated with project leads at Therapy Brands to gather requirements, ensuring dashboards met their specific needs and provided relevant insights.