PG

Priyansha Gupta

Data Analyst · Excel, Power Query & Power BI

Patna, Bihar, India

@priyansha_gupta

0 followers

Bachelor of Arts (Honours), Economics at Indira Gandhi National Open University (IGNOU) · Graduated 2024

About

Data analyst with hands-on experience in Excel, Power Query, Power BI, Google Sheets, and TallyPrime. Has worked on data cleaning, analysis, report preparation, and practical accounting workflows including GST, TDS, and financial reporting.

Experience

  • Data Analyst and Research Assistant (Academic Project)
    Freelance
    Apr 2026 – Present

    Cleaned, organized, and formatted economic datasets using Excel and Power Query for analysis and reporting. Used VLOOKUP, PivotTables, sorting, filtering, and Excel formulas to compare records, analyze trends, and summarize data. Prepared tables and charts from processed datasets to present analysis results.

Education

Skills

6 to 12 months 6 to 12 months Most of a year behind them.
<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.

Tools / apps / platforms

6 to 12 months 6 to 12 months Most of a year behind them.
Power Query Microsoft Excel
<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.
Claude Google Sheets Microsoft Word OpenAI ChatGPT Microsoft Copilot Microsoft Power BI

Projects

  • UrbanGlow and Zepto Data Analysis
    Excel, Power Query, Power BI

    Cleaned and structured raw UrbanGlow and Zepto data, including duplicate removal, field standardization, filtering, and data formatting. Used Power Query to import, transform, clean, and prepare raw datasets for analysis. Analyzed processed data to identify trends, patterns, category-level differences, and key observations. Created charts, graphs, and visual reports to present findings from the analyzed datasets. Used Power BI to build reports and visualizations from prepared data.

  • Tally Practical Accounting Project
    TallyPrime, GST, TDS

    Set up a company in TallyPrime and configured ledgers, stock items, and basic company details. Recorded purchase and sales vouchers, including GST-enabled transactions and TDS deduction entries. Reviewed Day Book, Sales, Profit and Loss, and Dashboard reports to trace how individual voucher entries were reflected in financial summaries. Reconciled voucher-level entries against report-level totals to verify accuracy of the recorded transactions.

Courses & certifications

  • Basics of Data Analytics · Physics Wallah & Microsoft · 2026
  • Microsoft Excel Beginners to Advanced · Skill Course · 2026
  • Power Query Corporate Training Masterclass · Skill Course / Learn More Pro · 2026

Explore the Broxer community

Online · instant AI help
Broxer