Skip to content
View nitinrawat05's full-sized avatar

Block or report nitinrawat05

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

πŸ‘‹ Hi, I'm Nitin Rawat

πŸ’Ό Data Analyst | Business Intelligence Analyst πŸ“ Delhi, India

πŸ“§ nitinrawat2502@gmail.com πŸ”— LinkedIn πŸ’» GitHub 🌐 Portfolio


πŸš€ About Me

I specialize in turning raw, messy data into structured insights and business decisions.

With 2 years of experience, I have built end-to-end data solutions β€” from ETL pipelines to dashboards β€” across AI, staffing, and marketing domains.

  • ⚑ Reduced manual reporting effort by 80%
  • πŸ“ˆ Improved data accuracy by 30%
  • πŸ“Š Built dashboards used for real-time business decisions
  • πŸ”„ Integrated data from 5+ sources into unified pipelines

I work across the full data stack: Data Ingestion β†’ Transformation β†’ Modeling β†’ Visualization


πŸ› οΈ Tech Stack

πŸ“Š BI & Visualization

  • Power BI
  • Tableau
  • Plotly Dash
  • Apache Superset

🧠 Data Analysis

  • Python (Pandas, NumPy, Matplotlib, Seaborn)
  • SQL
  • PySpark

βš™οΈ Data Engineering

  • ETL Pipelines
  • Databricks
  • Delta Lake
  • AWS (S3, Lambda)
  • Snowflake
  • Microsoft Fabric

🧰 Tools

  • Excel (Pivot Tables, VBA)
  • Git & GitHub
  • Docker

πŸ’Ό Experience

πŸ”Ή Data Analyst β€” LoQal AI Ventures

  • Built end-to-end ETL pipelines using Python, SQL, AWS
  • Automated reporting β†’ reduced manual effort by 80%
  • Developed dashboards in Power BI, Tableau, Plotly Dash
  • Deployed scalable cloud-based data workflows

πŸ”Ή Data Analyst β€” Elon Staffing

  • Integrated 5+ databases into a unified data pipeline
  • Improved data accuracy by 30% using Python
  • Built KPI dashboards β†’ improved decision speed by 20%
  • Automated reports using Excel VBA (↓ 50% time)

πŸ”Ή MIS Intelligence Analyst β€” AdByteHub

  • Analyzed marketing KPIs: CTR, CPC, ROAS
  • Built Power BI dashboards for campaign tracking
  • Delivered ROI insights for business decisions

πŸ“Œ Featured Projects

πŸ“Š Marketing Analytics Dashboard

πŸ”— https://github.com/nitinrawat05/marketing-analytics-dashboard-sqlpowerbi

  • Built SQL + Power BI solution for campaign tracking
  • Designed star schema data model
  • Implemented KPIs: ROAS, CTR, CAC
  • Added funnel & cohort analysis

🏭 FMCG Sales Analytics Platform

πŸ”— https://github.com/nitinrawat05/FMCG-Sales

  • Built Databricks Medallion Architecture (Bronze–Silver–Gold)
  • Used PySpark + SQL for transformations
  • Created Tableau dashboards for business insights

πŸ‘₯ HR Analytics Dashboard

πŸ”— https://public.tableau.com/app/profile/nitin.rawat7728/vizzes

  • Analyzed 8,900+ employee records
  • Built 20+ Tableau visuals
  • Used LOD expressions & drill-down analysis

πŸ“ˆ What I Bring

βœ” Strong SQL + Data Modeling βœ” End-to-End ETL Pipeline Development βœ” Business-Focused Dashboarding βœ” Cloud + Big Data Exposure βœ” Ability to translate business problems β†’ data solutions


🎯 Currently Learning

  • LangChain
  • Hugging Face
  • TensorFlow
  • Advanced Data Engineering

🀝 Let's Connect

If you're working on data, analytics, or AI-driven products, I'd love to connect.

πŸ‘‰ Open to Data Analyst / BI / Analytics Engineer roles

Pinned Loading

  1. SQL-EDA-Analytical-Project SQL-EDA-Analytical-Project Public

    An in-depth Exploratory Data Analysis (EDA) project that leverages Python libraries like Pandas, Matplotlib, and Seaborn to uncover trends, patterns, and insights from datasets, preparing the data …

    TSQL 1

  2. Princess-EDA-ML Princess-EDA-ML Public

    A rich dataset and analysis on Disney princesses covering character traits, story elements, and social media popularity. Includes EDA and machine learning to explore cultural trends, narrative role…

    Jupyter Notebook 1

  3. SQL-DataWarehouse-Project- SQL-DataWarehouse-Project- Public

    Building a modern data warehouse With SQL server Including ETL processes Data modelling , and analytics

    1

  4. Product-Price-Dynamics Product-Price-Dynamics Public

    A Python-based analysis of product retail prices, examining price trends, tax impacts, and regional differences over time.

    Jupyter Notebook 1

  5. Decoding-Customer-Shopping-Trends-A-Modern-Analysis Decoding-Customer-Shopping-Trends-A-Modern-Analysis Public

    Jupyter Notebook

  6. sales-Analytics sales-Analytics Public

    Sales analytics dashboard in Tableau, transforming raw data into insights with multi-dimensional analysis and predictive modeling for business optimization.