Skip to content
View Gourab2810's full-sized avatar

Block or report Gourab2810

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

Hi , I'm Gourab Narayan Deo

Aspiring Data Analyst | Power BI • SQL • Excel • Python

Typing SVG


👨‍💻 About Me

🎓 BCA Graduate from Netaji Subhas University, Jamshedpur — passionate about transforming raw, messy data into meaningful insights and visually compelling dashboards

📊 I specialize in Data Analysis, Data Cleaning, EDA, KPI Tracking & Dashboard Development

💼 Hands-on internship experience at AI Variant and NoviTech R&D Pvt. Ltd. working on real-world business datasets

🔍 Currently actively seeking Data Analyst roles where I can contribute, grow, and deliver data-driven value

🌱 Always learning — currently deepening skills in advanced DAX, Python (Pandas, NumPy, Matplotlib, Seaborn) and SQL optimization

📍 Based in Maharashtra, India

💬 Ask me about Power BI, SQL, Excel, Data Cleaning & EDA

📬 Reach me at: gourabrya2810@gmail.com | 8509200535


🚀 What I Bring to the Table


🛠️ Tools & Technologies


💼 Professional Experience

🏢 Data Analyst Intern — AI Variant

📅 Nov 2025 – May 2026

  • Collected, cleaned, and validated structured datasets using Excel and SQL to ensure data accuracy and integrity
  • Performed exploratory data analysis to identify trends, patterns, and anomalies across business datasets
  • Developed KPI-based dashboards in Power BI to support business reporting and operational monitoring
  • Structured and documented data outputs to improve reporting efficiency and team decision-making

🏢 Data Analyst Intern — NoviTech R&D Pvt. Ltd.

📅 Oct 2025 – Nov 2025

  • Processed and transformed structured datasets using Excel and SQL
  • Conducted statistical analysis — mean, variance, and correlation — to surface actionable data insights
  • Built SQL queries for data extraction, aggregation, and reporting from relational databases

🏭 Safety Supervisor — Tata Steel, Jamshedpur

📅 Mar 2024 – May 2025 (Payroll: Trimurty Industries & Kalathil Brothers Construction Company Pvt. Ltd.)

  • Maintained and structured operational data logs, ensuring accuracy, consistency, and safety audit readiness
  • Developed performance monitoring reports and compliance documents for internal stakeholders
  • Collaborated with cross-functional teams to gather data requirements and support reporting workflows

📁 Featured Projects

🌤️ Weather & AQI Dashboard — Power BI

Live weather data fetched from WeatherAPI.com, cleaned & modeled into 3 structured tables (Current, Forecast Day, Forecast Hours), then visualized into a fully interactive dark-themed dashboard

Key Features:

  • 7-Day Temperature Forecast Line Chart
  • Air Quality Index (AQI) with full pollutant breakdown (CO, NO2, O3, PM2.5, PM10, SO2)
  • KPIs — Visibility, Pressure, Humidity, Wind Speed, UV Index, Precipitation
  • City Selector toggle (Bengaluru, Hyderabad, Kolkata)
  • Sunrise & Sunset timings + Chance of Rain bar chart

Tools Used: Power BI Power Query DAX WeatherAPI.com

🔗 View Project


🛒 E-Commerce Data Analysis — Olist E-Commerce Store

End-to-end data model integrating multiple datasets: orders, customers, and products — visualized in Tableau

Key Features:

  • Integrated multiple datasets into a unified data model
  • Tableau dashboards tracking revenue, average order value, and delivery performance KPIs
  • Identified sales trends and customer behavior patterns

Tools Used: Tableau SQL Excel

🔗 View Project


👥 HR Analytics — Employee Attrition Analysis

Analysed employee data to identify attrition patterns and key influencing factors across departments

Key Features:

  • Identified attrition patterns and key influencing factors
  • Power BI dashboards tracking attrition rate and department-level workforce trends
  • Delivered actionable insights for HR decision-making

Tools Used: Power BI Excel SQL

🔗 View Project


🛍️ Walmart Sales Analysis Dashboard — Power BI

Interactive Power BI dashboard analysing sales, profit, and quantity trends with KPI visuals

Key Features:

  • Analysed sales, profit, and quantity trends across regions
  • Designed KPI visuals for actionable business insights
  • Supported data-driven decision-making through clear reporting

Tools Used: Power BI DAX Excel

🔗 View Project


📈 GitHub Stats


🏆 GitHub Trophies


📜 Education

Degree Institution Year Score
BCA (Bachelor of Computer Applications) Netaji Subhas University, Jamshedpur Aug 2019 – Jul 2022 CGPA: 8.34

🏅 Certifications

  • 🎓 Data Analyst Certification — ExcelR (IIT Jammu Collaboration)
  • 🥇 Gold Rank Achiever — Safety Management Training

🤝 Let's Connect


💼 Open to Work

🟢 I am actively looking for Data Analyst opportunities! If you're hiring or know someone who is, feel free to reach out at gourabrya2810@gmail.com or 8509200535 I'm eager to bring my skills in Power BI, SQL, Excel & Python to a team that values data-driven decision making!


If you find my projects helpful, consider giving them a star!

Popular repositories Loading

  1. Gourab2810 Gourab2810 Public

    Hi there!

  2. Olist_store-Dashboard Olist_store-Dashboard Public

  3. Walmart_performance-Dashboard Walmart_performance-Dashboard Public

  4. HR_analysis-Dashboard HR_analysis-Dashboard Public

  5. Live_weather_and_AQI-Dashboard Live_weather_and_AQI-Dashboard Public

  6. Steel_Plant_safety-Dashboard Steel_Plant_safety-Dashboard Public