KAPIL SINGH BAGARI

About

Detail-oriented B.Sc. IT & Data Analytics student with hands-on experience in Excel, SQL, Python, and Power BI. Builds accurate MIS reports and dashboards, with experience across sales, HR, customer, and purchase analytics projects.

Education

• B.Sc. in IT & Data Analytics
  Mumbai University
  IT & Data Analytics · 2026
• Class XII
  Uttarakhand Board
  2023
• Class X
  Uttarakhand Board
  2021

Skills

• SQL <3 months
• Data Visualization <3 months
• Python <3 months
• Data Cleaning <3 months
• Feature Engineering <3 months
• Matplotlib <3 months
• NumPy <3 months
• Pandas <3 months
• DAX <3 months
• Data validation <3 months
• Trend analysis <3 months
• Business Intelligence <3 months
• Dashboard Development <3 months
• KPI Tracking <3 months
• Predictive Modeling <3 months

Tools / apps / platforms

• Microsoft Excel <3 months
• Microsoft Power BI <3 months
• PostgreSQL <3 months
• Power Query <3 months

Projects

• HR Analytics Dashboard
  Power BI, dashboarding

  Built a dashboard to track workforce KPIs including attrition, compensation, and satisfaction.

• Customer Churn Analysis
  Data analysis

  Analyzed customer data to identify attrition drivers and produce retention recommendations.

• Sales Analytics Dashboard
  SQL, PostgreSQL, Excel, Python, Power BI, DAX

  Analyzed sales records and developed an interactive Power BI dashboard with KPI tracking, slicers, and drill-through pages.

• Purchase & Vendor MIS Dashboard
  Power Query, Excel, PivotTables, PivotCharts, slicers, formulas

  Cleaned and standardized raw purchase data and built an interactive Excel MIS dashboard to track vendor performance, pending payments, delivery delays, and spending.

Courses & certifications

• Data Analysis with Python · freeCodeCamp Developer Certification · 2026