Anshika Goyal

MBA (Business Analytics), IoA-accredited professional with hands-on experience in business analysis and BI development. Skilled in KPI analysis, requirements gathering, and building real-time Power BI dashboards for Budget vs Actual tracking, cost optimization, and executive reporting. Proficient in Power BI, SQL, Excel, and Python, with a strong focus on data-driven decision-making.

MIS Intern at Hireyy (2026-03 – 2026-04)

• Tracked and updated daily intern performance sheets, ensuring accurate and organized records of intern productivity for management review.
• Sourced and logged new job postings across 5+ job portals and company websites daily, identifying relevant opportunities for ongoing recruitment needs.

IT Intern - Power BI at Hero Future Energies (2025-07 – 2025-09)

• Built IT Budget vs Actual dashboards in Power BI using DAX measures and calculated columns to track year-over-year IT spend, monitor KPIs, and flag cost overruns for leadership reporting.
• Developed renewable energy performance dashboards (Solar, Hydrogen, Electrolyzer) with Expected vs Actual variance analysis, using Power Query for data transformation and shaping from multiple source files.
• Created dynamic dashboards with live Excel-connected data refresh, enabling real-time Budget vs Actual visibility for senior stakeholders across business units.

Research Analyst Intern at The Chef Kitchen (2024-06 – 2024-07)

• Designed a data collection system using Excel and SQL to capture customer behavior patterns and identify microtrends, supporting operational and inventory decisions.
• Analyzed cost components across workforce, inventory, and delivery operations, recommending process changes that contributed to a 20% reduction in operational costs.

MBA in Business Analytics – JECRC University, Jaipur (2024 – 2026)

Bachelor of Business Administration in BBA – Sophia College, Ajmer (2021 – 2024)