Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

PRIYANKA PEELWAL

Data Analyst
Jaipur

Summary

Data Analyst with 1+ year of experience Turing complex datasets into actionable business strategies. I have skills in data extraction, cleaning and visualization using SQL, Excel, Power BI. Expert in identifying operational part translating business problems into data requirements.

Overview

1
1
year of professional experience
7
7
Certifications

Work History

Data Analyst

Airtel
05.2024 - 06.2025
  • Automated BI Reporting: Designed and deployed interactive Power BI / Tableau dashboards tracking DAU/MAU for leadership, eliminating hours/week of manual Excel reporting.
  • Churn & Optimization Strategy: Built a customer segmentation and churn-risk model using Logistic Regression, enabling the CRM team to run targeted retention campaigns that reduced churn optimization and protect the annualized revenue.
  • Data Modeling & SQL: Optimized sql queries using complex joins, window functions, and CTEs to extract and clean multi-table datasets across sales, operation, and customer suspport.
  • Transformed raw datasets in Microsoft Excel using Power Query, VLOOKUP/XLOOKUP, and conditional formatting to ensure data accuracy before analysis.
    Optimized SQL queries using JOINs, CTEs, window functions, and aggregations to extract and transform data from relational databases for reporting pipelines.
  • Prepared and delivered weekly and monthly management reports data-driven decision-making across departments.
  • Performed EDA using Python (Pandas, NumPy) — profiling datasets, identifying outliers, analysing distributions, and generating statistical summaries to support business insights.
  • Make Reports and Prepare all Data Work as per Management Requirement.

Education

M.Tech -

DR. K.N. Modi University
Niwai, Jaipur
09.2023

B.Tech - undefined

Govt. Women's Engineering College
Ajmer
09.2021

12th -

3D Academy SR. Sec. School
Dausa
03.2017

10th - undefined

St. Mary's Convent School
Dausa
03.2015

Skills

Data Querying & Database: SQL (PostgreSQL, MySQL, SQL Server, BigQuery) Database Management, ETL/ELT Pipelines

Data Visualization: Power BI, Tableau, DAX, Dashboard Development

Data Analysis: Advanced Excel (Pivot Tables, VLOOKUP, Power Query), KPI Reporting

Database & Querying: SQL Server (SSMS), Joins, Aggregations, Subqueries

ETL & Automation: Alteryx, Power Automate, VBA Scripting, Data Transformation

Data Modeling: Power BI Data Modeling, Relationships, Calculated Columns, Measures

Programming: Python (Basic – Data Cleaning, Preprocessing using Pandas)

Analytical and Statistical Skills

Soft Skills: Problem Solving & Critical Thinking

Certification

Data Analytics Certificate from Google.

Timeline

Data Analyst

Airtel
05.2024 - 06.2025

B.Tech - undefined

Govt. Women's Engineering College

10th - undefined

St. Mary's Convent School

M.Tech -

DR. K.N. Modi University

12th -

3D Academy SR. Sec. School
PRIYANKA PEELWALData Analyst