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 is supported. This note will only be visible to you.
Report abuse

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

Report abuse
pratikshadandriyal/README.md
Typing SVG

LinkedIn GitHub Gmail


About Me

Data Analyst with internship experience in healthcare (MAX Healthcare) and govtech (EasyGov). I build analytics solutions from scratch — SQL Server schema design, Python data pipelines, and Power BI dashboards with 15+ DAX measures. Currently targeting Data Analyst roles in IT services and product companies across India.


Tech Stack

Data & Analytics

SQL Server Power BI Python Pandas NumPy Excel Power Query DAX

Tools & Environment

Git GitHub Jupyter VS Code SSMS Google Colab


Featured Projects

🖥️ Helpdesk Performance & SLA Analytics

IT support operations dashboard built on 8,000 tickets across 8 departments and 20 agents — tracking SLA compliance, agent workload, and resolution patterns over 26 months (Jan 2024 – Feb 2026). Schema designed to mirror how ServiceNow and Jira Service Management operate in practice.

Tools: SQL Server · Power BI · DAX · Python

Finding Value
Overall SLA breach rate 23.49% — no improvement across 26 months
Highest breach category Network at 37.5% vs Access at 13.1%
Agent overload 3 agents carry 35% of total ticket volume
Peak load window Monday 11am–1pm across all departments

🔗 GitHub  |  📊 Live Dashboard


📈 SaaS Product Analytics Dashboard

Product analytics covering the full user lifecycle — 5,000 users, 6,566 sessions, 14,996 feature interactions across a normalised 4-table SQL Server schema (Jan 2024 – Dec 2024).

Tools: SQL Server · Power BI · DAX · Python · Power Query

Finding Value
Paying and retained users Only 25.5% of total users
Feature adoption vs conversion 5-feature users convert at 55.3% vs 46.9%
MRR lost to churn monthly $90,548 vs $92,818 retained
Free vs paid engagement Free users average 2.1 mins more per session

🔗 GitHub  |  📊 Live Dashboard


🤖 AI Job Displacement & Reskilling Analytics

Workforce analytics across 15,000+ job records covering automation risk, salary outcomes, and reskilling urgency across 9 countries and 8 industries (2020–2026). Built with a full data pipeline — Python for data quality engineering, SQL Server for cleaning and transformation, Power BI for a 4-page interactive dashboard.

Tools: SQL Server · Power BI · DAX · Python · Power Query

Finding Value
High automation risk jobs 30.12% of all records
Most disrupted sectors Energy (disruption 23.62) and Finance (23.59)
Salary outcome post-reskilling +$3,567 average — but 41.13% of workers earned less
Highest skill gap role Teacher and Customer Support Rep at index 51

🔗 GitHub  |  📊 Live Dashboard


💭

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


Open to Data Analyst opportunities · India · Let's connect

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