Skip to content
View DeepakKhati's full-sized avatar
1 follower · 1 following

Block or report DeepakKhati

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

Hi, I'm Deepak Khati 👋

Data & MIS Analyst | Power BI · SQL · Excel · DAX · Power Query

Turning raw data into decisions — through dashboards, SQL queries, and business insight reporting.

I'm an analytics professional based in Delhi NCR, building end-to-end projects across sales performance, HR analytics, e-commerce data, and content strategy. I specialize in Power BI dashboard development, SQL-based analysis, and Excel reporting — with a focus on actionable business insights, not just pretty charts.

🛠️ Tech Stack

Category Tools
Visualization Power BI, DAX, Power Query
Database MySQL, SQL (Joins, Window Functions, Subqueries)
Spreadsheets Excel (Pivot Tables, XLOOKUP, SUMIFS, Power Query)
Data Modeling Star Schema, Fact & Dimension Tables
Currently Learning Python (Pandas, NumPy)

📂 Featured Projects

🔷 Power BI

Project Description
Advanced Sales Report Dashboard Time intelligence, MoM analysis, salesperson KPI tracking
Awesome Chocolates Sales Analysis 6-geography sales breakdown using Star Schema + DAX measures
Netflix Content Strategy Analysis Genre, geography & content trend analysis across Netflix library

🔶 SQL (MySQL)

Project Description
E-Commerce Zepto SQL Analysis Product pricing, discount trends & stock insights on grocery dataset
HR Employee Attrition Analysis IBM HR dataset — attrition drivers across departments, salary bands & job roles

🟢 Excel

Project Description
Excel Sales Dashboard Revenue analysis by region, city & category using Pivot Tables + dynamic slicers

📊 What I Build

  • 📈 Sales Dashboards — Revenue tracking, MoM trends, territory performance
  • 👥 HR Analytics — Attrition analysis, headcount reporting, department benchmarking
  • 🛒 E-Commerce Analysis — Pricing strategy, discount impact, inventory insights
  • 📺 Content Analytics — Genre performance, regional distribution, trend mapping

📬 Let's Connect

LinkedIn Email

📍 Delhi NCR & Remote | 🎯 Open to: Data Analyst · MIS Analyst · Business Analyst · Power BI Developer roles

"Data is just noise until someone asks the right question."

Pinned Loading

  1. E-Commerce-Zepto-SQL-Analysis E-Commerce-Zepto-SQL-Analysis Public

    SQL analysis on Zepto grocery dataset | product pricing, discount trends & stock insights using MySQL

  2. Excel-Sales-Dashboard Excel-Sales-Dashboard Public

    Interactive Excel sales dashboard analyzing revenue patterns across regions, cities and product categories using Pivot Tables and dynamic slicers

  3. HR-Employee-Attrition-Analysis HR-Employee-Attrition-Analysis Public

    SQL project analyzing the IBM HR Analytics Employee Attrition Dataset to identify factors influencing employee attrition. The analysis explores trends across departments, job roles, salaries, trave…

  4. Chocolates-Sales-Analysis-PowerBI Chocolates-Sales-Analysis-PowerBI Public

    Independent Power BI report analyzing chocolate sales across 6 geographies with star schema and DAX measures

  5. Advanced-Sales-Report-Dashboard-PowerBI Advanced-Sales-Report-Dashboard-PowerBI Public

    Advanced Power BI sales dashboard with time intelligence, MoM analysis and salesperson performance tracking

  6. Netflix-Content-Strategy-Analysis Netflix-Content-Strategy-Analysis Public

    Power BI analysis of Netflix content library covering genre, geography and content trends