Skip to content
View asgeek96's full-sized avatar
🏠
Working from home
🏠
Working from home

Block or report asgeek96

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
asgeek96/README.md

banner

Hi πŸ‘‹, I'm Anubhav Srivastava

πŸš€ Data Analyst | Business Intelligence | Data Engineering


🧠 About Me

  • πŸ“Š Data Analyst specializing in Business Intelligence & Data Engineering
  • πŸ—οΈ 4+ years building enterprise ETL pipelines, OLAP cubes & Power BI dashboards at TCS
  • πŸ”„ Currently leading DWH decommissioning β€” migrating multi-dimensional SSAS cubes to Power BI
  • πŸ€– Integrating AI & OpenAI APIs into analytics workflows
  • 🌱 Currently learning Data Fabric

πŸ› οΈ Tech Stack

BI & Analytics: Power BI β€’ DAX β€’ SSAS β€’ Excel
Databases: SQL Server β€’ MySQL β€’ PostgreSQL β€’ Snowflake
ETL & Engineering: SSIS β€’ Apache Airflow β€’ API Integration (C#)
Cloud & AI: Azure (AZ-204) β€’ OpenAI APIs β€’ Prompt Engineering
Programming: C# β€’ ASP.NET Core


πŸ“„ Resume


πŸš€ Featured Projects

πŸ‘₯ HR Employee Attrition Dashboard

HR Employee Attrition Dashboard

2-page Power BI dashboard analysing attrition across 1,470 employees (IBM HR dataset, 35 features)
DAX: Attrition Rate, Overtime Risk, Income Gap, Tenure Comparison
Key Finding: Overtime employees leave at 3Γ— the rate; Sales Reps at 39.8% attrition β€” highest risk role
Conditional formatting, age group binning via Power Query, satisfaction matrix with heatmap

πŸ”— View Project


🚚 Delivery Logistics Performance Dashboard

3-page dark-themed Power BI dashboard across 25,000 deliveries, 9 partners & 5 regions
DAX: Delay Rate, On-Time Rate, Failed Deliveries, Avg Cost by Mode
Key Finding: Stormy weather causes 41% delays vs 16% in clear; Same Day costs 13% more than Standard
Custom tooltip page, conditional formatting, treemap, cross-page slicers by region & weather

πŸ”— View Project


πŸ“Š Sales & Revenue Intelligence Dashboard

Sales Dashboard

End-to-end Sales Analytics solution using SQL Server & Power BI with star schema data model
DAX: YTD, MTD, YoY Growth, Profit Margin, KPI tracking
Identified high discount-driven profit losses and top-performing markets across regions

πŸ”— View Project


πŸ† Certifications

Category Certification
☁️ Cloud Microsoft Certified: Azure Developer Associate (AZ-204)
☁️ Cloud AZ-900: Azure Fundamentals
πŸ—„οΈ Data MySQL Bootcamp – Colt Steele
πŸ—„οΈ Data MySQL Assessment – Scored 100%
πŸ€– AI Prompt Engineering for AI Bootcamp
πŸ€– AI OpenAI & ChatGPT API for Developers
πŸ€– AI Generative AI Mastermind
πŸ” Security Cyber Security Foundation – TCS
πŸ” Security Application Security Fundamentals

πŸ“Š GitHub Analytics


πŸ“ˆ Contribution Activity


🐍 Contribution Snake


🌐 Connect With Me

---

Pinned Loading

  1. Anubhav-Srivastava-Resume Anubhav-Srivastava-Resume Public

    Anubhav Srivastava – Data Analyst | BI | Data Engineering

  2. delivery-logistics-powerbi-dashboard delivery-logistics-powerbi-dashboard Public

    Tool: Power BI | Dataset: Delivery Logistics (25,000 deliveries, 15 features) A three-page interactive Power BI dashboard analysing delivery performance across 9 partners, 5 regions, and 6 weather …

  3. HR-Employee-Attrition-Dashboard HR-Employee-Attrition-Dashboard Public

    Tool: Power BI | Dataset: IBM HR Analytics (1,470 employees, 35 features) A two-page interactive Power BI dashboard analysing employee attrition patterns across roles, departments, age groups, comp…

  4. Student-Mentor_Database Student-Mentor_Database Public

    Relational database system for managing student-mentor assignments using MySQL

  5. sales-analytics-dashboard sales-analytics-dashboard Public

    End-to-end retail data warehouse using SQL Server, SSIS, and Power BI with star schema and executive dashboard.

  6. BMIPrediction BMIPrediction Public

    "BMI analysis and classification on 500-person dataset using Python, Pandas & scikit-learn"

    Jupyter Notebook