Skip to content
View RajayJain's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report RajayJain

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

Hi folks, I'm Rajay Ajay Jain! 👋 ✨


Data Analytics

Typing SVG


🔗 About Me


I am a passionate & aspiring Data Analyst from Goa, India, dedicated to optimizing queries and finding the stories & why hidden within numbers. I transform raw data into clear, actionable business strategies using analytical tools.

  • 🎓 B.Tech in Electrical Engineering
  • 📊 Passionate about Data Analytics & Business Intelligence
  • 💼 Experienced in Power BI Dashboard Development
  • 🌱 Currently strengthening skills in SQL, Python & Data Engineering
  • 📈 Love transforming raw data into actionable insights
  • 🎯 Targeting Data Analyst roles at top companies
  • ⚡ Fun Fact: I enjoy turning complex datasets into simple business stories

🛠️ Tech Stack & Toolkit

Python SQL Pandas Power Query DAX Power BI Excel GitHub


📂 Featured Data Projects

Here is a look at what I've been building across my 10 repositories:


🛒 Blinkit Sales Analysis

🔗 View It Here 🔎

  • Analyzed 8,523 retail transactions generating $1.20M+ in total sales across multiple outlet types and product categories.
  • Built an executive Power BI dashboard featuring 15+ KPIs, including Total Sales, Average Sales, Outlet Performance, Customer Ratings, and Inventory Distribution.
  • Developed advanced DAX measures and interactive visualizations to identify top-performing product categories and revenue-driving outlets.
  • Delivered actionable business insights that improved visibility into sales trends, outlet efficiency, and customer purchasing behavior.

📈 Power BI Data Analytics

🔗 View It Here 🔎

  • Designed and developed multiple end-to-end Power BI solutions covering data extraction, transformation, modeling, and business reporting.
  • Created 15+ DAX measures and KPIs to track revenue, profitability, customer performance, and operational efficiency.
  • Implemented star-schema data models and optimized report performance using Power Query and advanced DAX techniques.
  • Built interactive dashboards with drill-through functionality and dynamic filtering, enabling data-driven decision-making for stakeholders.

🏪 Walmart Sales Data Analysis

🔗 View It Here 🔎

  • Analyzed 1,000+ customer transactions across multiple Walmart branches to evaluate revenue performance and consumer purchasing behavior.
  • Performed exploratory data analysis using SQL and Power BI to uncover sales trends, customer preferences, and product demand patterns.
  • Identified peak sales periods, top-performing product lines, and branch-level performance opportunities through data-driven insights.
  • Developed an interactive business dashboard with 10+ key performance metrics supporting strategic planning and operational monitoring.

📊 Excel Salary Dashboard

🔗 View It Here 🔎

  • Analyzed survey data from 630+ data professionals across various countries, experience levels, and job roles.
  • Built a fully interactive Excel dashboard using Pivot Tables, Power Query, Slicers, and Dynamic Charts to visualize compensation trends.
  • Automated data preparation and transformation workflows, reducing manual analysis effort by approximately 80%.
  • Generated insights into salary benchmarks, high-paying skills, and regional compensation differences within the data analytics industry.

📜 Certifications

🏅 Microsoft Power BI Data Analyst
🏅 SQL for Data Analytics
🏅 Data Analytics Professional Certificates
🏅 Python for Data Analysis


📊 Skill Distribution & Ecosystem


🌐 Let's Connect!

Feel free to reach out if you want to collaborate on a data project, discuss query optimization, or talk about market insights!


💡 Quote of the Day

Quote of the Day


Pinned Loading

  1. Excel_Salary_Dashboard Excel_Salary_Dashboard Public

    This data jobs salary dashboard was created to help job seekers investigate salaries for their desired jobs and ensure they are being adequately compensated.

    1

  2. Blinkit_Analysis Blinkit_Analysis Public

    This data analysis project delivers deep analytics on Blinkit’s grocery network using 8,523 line items and 12 dimensions. It optimizes commercial strategy by cleaning text features, isolating finan…

    Jupyter Notebook 1

  3. Project_02_Analysis Project_02_Analysis Public

    As a data enthusiast and job seeker, I embarked on this Excel-based project to uncover valuable insights about the data science job market. Using a dataset I've curated from real-world job postings…

    1

  4. Customer_Shopping_Analysis Customer_Shopping_Analysis Public

    End-to-end data analytics project analyzing 3,900 customer purchase records to uncover shopping patterns, demographic trends, subscription impact, and product performance. The project delivers data…

    Jupyter Notebook 1

  5. Tableau Tableau Public

    This project is a Tableau workbook collection built with Superstore sales data, demonstrating core data visualization skills including chart creation, calculated fields, filters, parameters, map vi…

    1

  6. Walmart_Sales_Data_Analysis Walmart_Sales_Data_Analysis Public

    This project is an end-to-end data analysis solution designed to extract critical business insights from Walmart sales data. I utilized Python for data processing and analysis, SQL for advanced que…

    Jupyter Notebook 1