Skip to content
View Mohan81020's full-sized avatar

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.

Please don't include any personal information such as legal names or email addresses. Maximum 250 characters, 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
Mohan81020/README.md

👋 Hi, I'm Mohan Kumar

Data Analyst | SQL | Power BI | Excel | Python
🎓 B.Tech (NIT Jamshedpur) · 💼 1.8 years as Business Analyst (Affine)

🔎 About Me

I’m a Data Analytics Enthusiast with experience in data analysis, business intelligence, and reporting automation.
At Affine, I worked on Microsoft Bing Ads and Azure Campaign Analytics projects, where I:

  • Automated reporting pipelines (60% less manual work 🚀)
  • Built interactive dashboards in Power BI & Excel
  • Conducted A/B testing & KPI analysis (CTR, CVR, CPA, Retention, Revenue)

💡 My focus: turning raw data into actionable insights that help businesses grow.

🛠 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

💼 Experience

Business Analyst — Affine, Bengaluru

  • Delivered campaign insights for Microsoft Bing Ads & Azure.
  • Built Power BI dashboards & Excel reports around key KPIs.
  • Automated 10+ Azure campaign reports (cutting delivery time by 60%).
  • Performed statistical analysis & forecasting to optimize campaigns.

📂 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

🎓 Education

B.Tech — Metallurgical & Materials Engineering
National Institute of Technology (NIT), Jamshedpur

🏆 Achievements

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

📬 Connect With Me

LinkedIn
Gmail
GitHub

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.

    1

  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…

    1

  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.

    1