GB

Gagan Bhardwaj

BI Consultant · Data Analyst · Power BI | SQL

Panchkula, Haryana, India

@gagan_bhardwaj

0 followers

About

Data Analyst and BI enthusiast with hands-on experience in Power BI, SQL, MySQL, Excel, and Python. Skilled in data cleaning, transformation, modelling, and dashboard development for business reporting and actionable insights.

Experience

  • Data Analyst Intern
    Theta Academy
    Jan 2026 – May 2026
  • Junior Accountant
    GAMP Technologies
    Aug 2025 – Oct 2025

Education

  • MBA
    Data Science & AI · Jul 2025 – Jun 2027
  • Bachelor of Commerce
    Jul 2021 – May 2025
  • Diploma in Computer Application
    Computer Application · Dec 2023 – Dec 2024

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.
MySQL Power Query Microsoft Excel Microsoft Power BI

Projects

  • Wine Quality Prediction
    Python, Machine Learning

    Built a Random Forest classifier on the UCI red-wine dataset with data cleaning, EDA, feature preparation, and prediction input.

  • Used Car Sales and Price Intelligence Dashboard
    Power BI, SQL, Python

    Analysed resale pricing, depreciation, and demand trends; applied Python regression to estimate fair resale value. Combined SQL-based data preparation with Power BI visuals to flag good, fair, or overpriced listings.

  • EV Fleet Analytics Dashboard
    Power BI, Excel

    Built a fleet-monitoring dashboard covering vehicle utilisation, charging activity, battery health, maintenance, and cost KPIs. Identified underused vehicles and charging-pattern savings.

  • Amazon Sales Dataset Analysis
    MySQL

    Analysed revenue trends, product performance, and regional insights using SQL joins, GROUP BY, subqueries, and stored procedures. Created reporting-ready outputs and practised query optimization.

  • Real Estate Market Analysis Dashboard
    Power BI, Power Query, DAX

    Designed an interactive dashboard analysing property prices, price per sq ft, rental yield, and location trends. Built Power Query transformations, relationships, and DAX KPIs for investment-focused reporting.

Courses & certifications

  • Data Visualisation Simulation · TATA / Forage
  • Data Analytics Simulation · Deloitte / Forage

Explore the Broxer community

🤖
Online · instant AI help
Broxer