PT

Purnima Tyagi

MBA student · Business Analyst

Delhi, India

@purnima_tyagi

0 followers

MBA, Business Analytics at Banasthali Vidyapith · Graduating 2027

About

Business Analytics MBA candidate with hands-on experience in Power BI, Power Query, DAX, SQL and Excel for MIS dashboards, reporting automation and KPI analysis. Built large-scale retail analytics dashboards and automated reporting workflows across multiple data sources.

Experience

  • Power BI & Power Automate Intern
    Acetians Technology Pvt. Ltd. · Delhi
    Aug 2026 – Nov 2026

    Developed and maintained interactive Power BI dashboards for business reporting and management insights. Built Power Automate workflows for automated file downloads, data processing and workflow execution. Used Power Query to clean, merge and transform data from Excel, SharePoint and OneDrive; resolved refresh and automation issues.

  • Business Analyst Intern
    RSPL Group · Gurugram
    May 2026 – Aug 2026

    Led analysis of how On-Shelf Availability, search visibility and promotions drive market share on Blinkit and Zepto. Built pan-India Excel MIS dashboards on 197,000+ SKU-level records across 66 cities using IF, COUNTIFS, AVERAGEIFS and SUMIFS. Quantified ~1.40% sales lift per 1% OSA improvement via hypothesis testing; benchmarked Share of Voice across 193 keywords and 12 cities vs four competitors. Built a Blinkit Sales Loss Attribution dashboard quantifying Rs. 25.9L MRP loss by reason type and city.

Education

  • MBA
    Business Analytics · 2025 – 2027
  • BBA
    Maa Shakumbhari University
    Finance · 2022 – 2025

Skills

Tools / apps / platforms

6 to 12 months 6 to 12 months Most of a year behind them.
Microsoft Excel
3 to 6 months 3 to 6 months A few months of practice with it.
Power Query Microsoft Power BI Microsoft SharePoint
<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.
Tableau Microsoft Power Automate

Projects

  • Automated Report Workflow
    Power Automate, SharePoint

    Flow that fetches report files, processes them and delivers the updated report on a schedule.

  • Sales Funnel & Lead Conversion Analysis
    Power BI, Excel

    Measured stage-wise conversion and drop-off by lead source and region in a funnel dashboard.

  • Customer & Sales Analysis
    SQL

    Queried the Olist e-commerce dataset with JOINs and CTEs to analyze revenue, top categories and delivery performance.

  • HR Analytics Dashboard
    Power BI, DAX

    Analyzed IBM HR Attrition data (1,470 employees) for attrition drivers by department, tenure, overtime and income.

  • Retail Sales MIS Dashboard
    Excel

    Interactive PivotTable dashboard on the Superstore dataset tracking sales, profit and margin by category, region and segment.

Courses & certifications

  • Data Visualisation · Tata Group (Forage) · 2026
  • Data Analytics Job Simulation · Deloitte Australia (Forage) · 2026
  • Business Analytics with Excel
  • Power BI for Beginners
  • NISM Financial Literacy
  • Basic SQL
  • Banking and Finance · Bajaj Finserv

Explore the Broxer community

Online · instant AI help
Broxer