Skip to content
View pratikshadandriyal's full-sized avatar

Block or report pratikshadandriyal

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
pratikshadandriyal/README.md

🎯 On a Mission to Turn Raw Data into Real Decisions

Fresher | Data Analyst Aspirant | AI & ML Enthusiast

LinkedIn GitHub Gmail


🚀 About Me

pratiksha = {
    "role"       : "Aspiring Data Analyst & AI Explorer",
    "status"     : "Actively seeking Data Analyst / AI roles 🔍",
    "superpower" : "Turning messy data into clean, useful insights",
    "approach"   : "Build projects. Don't just talk about them.",
    "currently"  : "Deep-diving into Data Analysis & Visualization 📊",
    "fun_fact"   : "I clean data like it personally offended me 🧹"
}

🛠️ Tech Stack

Data & Analytics

Python SQL Pandas NumPy Excel Power BI Power Query

Programming & Web

Java C HTML5 CSS3 JavaScript

Tools & Environments

Git GitHub Jupyter Google Colab VS Code


🎯 What I'm Targeting

🎪 Role 💡 What I Bring
Data Analyst SQL + Python + Power BI for end-to-end analysis

📌 Featured Projects

🖥️ Project 1 — Helpdesk Performance & SLA Analytics (Most Recent)

  • What it does: End-to-end IT support operations dashboard analyzing 8,000 tickets across 8 departments and 20 agents — tracking SLA compliance, agent workload, resolution times, and peak load patterns over 26 months (Jan 2024 – Feb 2026)
  • Tools used: Python · SQL Server · Power BI · DAX
  • Why it stands out: Designed specifically for IT services companies (TCS, Infosys, Wipro). Includes a Day × Hour peak load heatmap and an Agent Workload vs Breach Rate scatter chart — two visuals rarely seen in fresher portfolios
  • Key insights: 23.49% overall SLA breach rate with no improvement trend over 26 months — a systemic staffing issue; Network category breaches at 37.5%; 3 agents carry 35% of total ticket volume; Marketing dept generates highest tickets per employee at 22.97
  • 🔗 View Project

📈 Project 2 — SaaS Product Analytics Dashboard

  • What it does: Analyzes user behaviour, feature adoption, churn patterns, and revenue metrics for a B2B SaaS company across 5,000 users, 6,566 sessions, and 14,996 feature interactions
  • Tools used: Python · SQL Server · Power BI · DAX · Power Query
  • Why it stands out: Goes beyond surface-level dashboards — tracks the full B2B SaaS funnel from activation to churn with revenue impact quantified in dollars. Feature adoption correlation analysis (5 features = 55.3% conversion) shows product analytics thinking, not just reporting.
  • Key insight: Only 25.5% of users are paid & active; users adopting 5 features convert at 55.3% vs 46.9% for single-feature users; $90,548 MRR lost to churn monthly
  • 🔗 View Project

🤖 Project 3 — AI Job Displacement & Reskilling Dashboard

  • What it does: Analyzes AI's impact on 13,700+ job records across 9 countries covering automation risk, salary changes, and reskilling urgency (2020–2026)
  • Tools used: Python · SQL Server · Power BI · DAX · Power Query
  • Why it stands out: Deliberately chosen to avoid oversaturated e-commerce datasets — addresses a topic every hiring manager in tech is thinking about right now
  • Key insight: 27.78% of jobs face high automation risk; Energy & Finance most disrupted; avg salary increased by $3,500 post AI adoption
  • 🔗 View Project

🏦 Project 4 — Banking Analytics Dashboard

  • What it does: Analyzes 10,000+ banking records covering customer demographics, transaction trends, account balances, and inactive account detection
  • Tools used: SQL Server · Power BI · DAX · Power Query Editor
  • Key insight: Identified Top N high-value customers, 90-day inactive accounts, and monthly transaction trends across Credit & Debit types
  • 🔗 View Project

📊 GitHub Activity


💭 My Data Philosophy

"Without data, you're just another person with an opinion." — W. Edwards Deming


Open to opportunities • Let's connect and build something meaningful!

Profile Views

Pinned Loading

  1. Helpdesk-Performance-SLA-Analytics Helpdesk-Performance-SLA-Analytics Public

    End-to-end IT Helpdesk Analytics Dashboard — SQL Server, Power BI, Python | SLA breach analysis, agent performance, peak load heatmap

    TSQL

  2. SaaS-Product-Analytics-Dashboard SaaS-Product-Analytics-Dashboard Public

    End-to-end SaaS Product Analytics Dashboard | SQL Server • Power BI • Python | User behaviour, feature adoption, churn analysis & revenue metrics across 5,000 users

    TSQL

  3. AI-Job-Displacement-Reskilling-Dashboard AI-Job-Displacement-Reskilling-Dashboard Public

    End-to-end Power BI dashboard analyzing AI's impact on jobs, salaries & reskilling across 9 countries using SQL Server and Python

    TSQL 1

  4. Banking-Analytics-PowerBI Banking-Analytics-PowerBI Public

    Power BI dashboard analyzing 10,000+ banking transactions with KPIs for customer demographics, transaction trends, and account inactivity using SQL Server and DAX

    TSQL 2