VARUN JANGIR
Data analyst
Jaipur,RJ
Summary
Entry-level Data Analyst with strong hands-on experience in SQL, Power BI, Excel, and foundational Python (EDA). Proven ability to convert raw transactional data into actionable business insights through data cleaning, star schema modeling, KPI development, and interactive dashboards. Experienced in analyzing profit leakage, customer risk behavior, and e-commerce performance using Kaggle and simulated datasets. Comfortable working with complex SQL queries, relational data models, and executive-ready Power BI dashboards.
Overview
1
1
Certification
Education
Bachelor of Computer Applications - undefined
Poornima University
Jaipur, Rajasthan, India07.2025
Skills
- SQL
- Power BI
- Excel
- Joins
- Subqueries
- CTEs
- Views
- Aggregations
- Data Modeling
- DAX Measures
- KPI Cards
- Slicers
- Interactive Dashboards
- Star Schema
- Fact & Dimension Tables
- Descriptive & Diagnostic Analysis
- Trend Analysis
- Python
- GitHub
- CSV datasets
- Kaggle
Certification
- Google Data Analytics Professional Certificate, Google (Coursera)
- Data Analytics Certification, Industry-recognized program
Project
Food Delivery Business Analytics (Zomato-Inspired), SQL, Power BI, Performed end-to-end business analysis to identify why revenue growth was not converting into profit., Cleaned and transformed 50k+ data using SQL, designed star schema, and built KPIs for profit, retention, and customer value., Developed interactive Power BI dashboards highlighting discount misuse, repeat customer impact, and growth drivers., Delivered actionable insights showing repeat customers drive profitability while heavy discounts hurt margins. Profit Leakage Detection & Analysis, SQL, Power BI, Analyzed transaction-level 70k+ data to detect profit leakage across product categories using advanced SQL queries., Designed a star schema and built Power BI dashboards to track discount impact and category-wise profitability., Identified Electronics and Toys as major leakage contributors due to pricing and discount inconsistencies. FinTech Customer Value & Risk Analysis, SQL, Power BI, Segmented customers based on transaction behavior to assess value and risk patterns., Created KPIs for monthly activity, customer status, and risk indicators using SQL and DAX., Built dashboards enabling city-wise and segment-level analysis for data-driven decisions.
Github Portfolio
https://github.com/varunjangir7 (Includes SQL queries, datasets, dashboards, and project)
Timeline
Bachelor of Computer Applications - undefined
Poornima University