PG

Priyanshi Gupta

BCA student · Aspiring Data Analyst

Lucknow, Uttar Pradesh, India

@priyanshi_gupta

0 followers

Looking for jobs Looking for internships

🎓 Bachelor of Computer Applications (Data Science & Artificial Intelligence) at Babu Banarasi Das University · Graduating 2028

About

BCA student with hands-on experience in SQL, Python, Excel, Power BI, and Tableau for data analysis and visualization. Seeking a Data Analyst Internship to apply analytical skills to business problems and generate actionable insights.

Education

Skills

<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

<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.
Git MongoDB Tableau Power Query Google Sheets Microsoft Excel Microsoft Power BI

Projects

  • HR Analytics Dashboard
    Excel, Power BI

    Developed an HR Analytics Dashboard using Excel and Power BI to analyze employee demographics, salary trends, job roles, and workforce metrics. Created interactive KPIs and visualizations to identify workforce patterns and support data-driven HR decision-making.

  • Zepto Sales Analysis
    Excel

    Performed descriptive analysis of product, category, city, pricing, discount, orders, and revenue data. Created visualizations for product, category, city, discount impact, pricing, and AOV analysis.

  • Excel

    Built an interactive sales dashboard using Pivot Tables, XLOOKUP/VLOOKUP, slicers, and KPI cards. Analyzed product and category performance to identify sales trends and actionable insights.

  • SQL

    Analyzed sales data using SQL to evaluate revenue, orders, AOV, and product performance. Used JOINs, aggregate functions, subqueries, GROUP BY, and window functions to generate business insights.

Explore the Broxer community

🤖
Online · instant AI help
Broxer