Power Bi Data Analyst

PAYAL BHANSALI LinkedIn GitHub *********@*****.*** +91-976*******

Detail-oriented Data Analyst with over 4 years of experience turning complex datasets into actionable business insights. Skilled in data modeling, statistical analysis, and visualization across large-scale e-commerce and SaaS platforms. Strong command of SQL, Python, Snowflake, and Power BI. Experienced in exploratory data analysis (EDA), building automated reporting pipelines, and collaborating with cross-functional teams to support product, marketing, and operations decision-making.

● Languages & Tools: SQL, Python (Pandas, Numpy, Seaborn), Snowflake, MySQL

● Data Visualization: Power BI (DAX, KPIs, Reports, Dataflows), Excel (Advanced Formulas, Power Query)

● EDA & Statistical Analysis: Outlier Detection, Regression, Descriptive Statistics, A/B Testing

● ETL & Automation: Data Cleaning, Transformation, Validation, Data Pipelines

● Project Tools: Asana, SharePoint, Trello, Kibana Business Analyst [Shopalyst] -08/2024 - Present

o Conducted ad-hoc and scheduled analyses using Snowflake and Python to support decision-making across marketing and product teams.

o Created dynamic Power BI dashboards to visualize SKU-level performance, pricing trends, and stock availability across multiple merchants.

o Collaborated with cross-functional teams to automate client-facing reporting, reducing delivery time by 40%. o Conducted funnel and behavioral analysis to identify conversion issues and opportunities for optimization. o Processed and integrated large datasets (Amazon S3 to Snowflake) with automated ETL processes for real-time insights.

Analyst [UTOPIAN VA (INDIA) PRIVATE LIMITED] -10/2021- 08/2024 o Delivered weekly and monthly reports on store performance, customer acquisition, and product trends using Power BI and Excel.

o Analyzed Amazon & Shopify data to track pricing, returns, and sales velocity, helping reduce return rates by 10%. o Developed automated Excel models and visual reports to support client decisions and streamline analysis workflows.

o Applied SQL queries to segment user behavior and run correlation analysis across sales campaigns. Retail Data Analysis -03/2023 - 04/2023

o Designed a Retail Data Analysis Dashboard using Snowflake, AWS, Python, and Power BI, driving a 30% increase in sales revenue and enhancing decision-making efficiency. o Streamlined data upload and tracking between AWS S3 and Snowflake, reducing data manipulation by 25% and improving accuracy, while leveraging Python for automated EDA to uncover actionable business insights.

Deloitte Case Study -02/2023 - 03/2023

o Analyzed World Bank data for 200 countries (1990–2018), focusing on CPI, exchange rates, and exports to identify key trends and actionable insights.

o Executed complex queries in Snowflake to optimize calculations and reduce execution time, and crafted Power BI visualizations, boosting business intelligence by 35%.

Full Stack Data Analytics

Data Analytics Consulting Virtual Internship

Advance Google Analytics

Power BIVirtual Case Experience

Bachelor of Commerce (B.com)08/2017 - 06/2020

Amravati University

Contact this candidate