Skip to content
View Mohan81020's full-sized avatar
2 followers · 0 following

Block or report Mohan81020

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

👋 Hi, I'm Mohan Kumar

Data Analyst | SQL | Power BI | Excel | Python
🎓 B.Tech · 💼 Data Analyst

🔎 About Me

I'm a Data Analyst with experience in SQL, Python, Power BI, and Excel, helping businesses make data-driven decisions through analytics, dashboard development, and reporting automation.

I work on Inventory, Sales, and Campaign Analytics for TI Cycles of India, where I:

  • Built an Inventory Health Scoring Model using Python and ABC-XYZ segmentation
  • Developed SQL-based reports for inventory tracking and sales performance analysis
  • Created Power BI dashboards for inventory, sales, and campaign KPIs
  • Automated business reports using Python (openpyxl) and Excel
  • Performed campaign analysis using ROMS, CPA, CTR, and uplift testing

Previously at Affine, I worked on Microsoft Bing Ads and Azure Campaign Analytics projects, where I:

  • Automated reporting processes (60% reduction in manual effort 🚀)
  • Built interactive dashboards in Power BI & Excel
  • Conducted A/B testing and statistical analysis
  • Analyzed campaign KPIs including CTR, CVR, CPA, Revenue, and Monthly Active Users

💡 My focus: Turning raw data into actionable insights that drive business growth and better decision-making.

🛠 Skills

SQL
Power BI
Excel
Python

  • Databases: SQL (MySQL, MS SQL Server, Scope), COSMOS DB
  • Data Visualization: Power BI (DAX, interactive dashboards)
  • Spreadsheets: Excel (Pivot Tables, VLOOKUP, Index-Match, Data Cleaning)
  • Programming: Python (Pandas, NumPy, Matplotlib)
  • Other: Business Analysis · EDA · Campaign Analytics · A/B Testing

📂 Featured Projects

🔹 Superstore Sales Performance Analysis
SQL + Power BI dashboard analyzing category-wise sales & profit.
🔗 View Project

🔹 HR Attrition Analysis
Advanced SQL + DAX to analyze attrition drivers, job satisfaction & work-life balance.
🔗 View Project

🔹 Indian Lok Sabha Election 2024 Results
SQL + Power BI visualization of party performance, vote trends, and EVM vs Postal votes.
🔗 View Project

🔹 Adventure Works Analysis
Power BI project on revenue, profit, customer segmentation & regional trends.
🔗 View Project

👉 More projects & dashboards available here: My GitHub Portfolio

🏆 Achievements

  • 🥇 SQL Gold Badge — HackerRank
  • 🥈 SQL III — LeetCode
  • 🎖️ Ranked 4th in BCECE Exam (Bihar State)

Pinned Loading

  1. lok-sabha-election-2024-SQL-PowerBI lok-sabha-election-2024-SQL-PowerBI Public

    Data analysis of the 2024 Indian Lok Sabha Election using SQL and Power BI to extract insights on party performance, vote shares, constituency-level outcomes, and margins of victory.

    2

  2. Sales-performance-sql-powerbi Sales-performance-sql-powerbi Public

    SQL & Power BI project analyzing Superstore e-commerce data for sales, profit & performance insights across categories, regions, and customer segments.

    3 3

  3. Customer-Churn-Analysis-PowerBI Customer-Churn-Analysis-PowerBI Public

    Customer churn analysis project using Excel and Power BI. This project investigates the exit patterns of banking customers using various demographics and behavior indicators such as age, gender, cr…

    3

  4. PowerBI-AdventureWorks-Cycle-Analysis PowerBI-AdventureWorks-Cycle-Analysis Public

    Business Analysis of a fictitious company and created an Interactive Dashboard using Power BI

    1

  5. HR-Attrition-SQL-PowerBI HR-Attrition-SQL-PowerBI Public

    SQL + Power BI project analyzing employee attrition trends across departments, job roles, education levels, and salary bands. Includes interactive dashboards and HR strategy insights.

    2