Skip to content
View rai502's full-sized avatar
💭
Open to Data Analyst opportunities
💭
Open to Data Analyst opportunities

Block or report rai502

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

Ritesh Sharma

Data Analyst | E-commerce & Business Intelligence

Entry-level Data Analyst with hands-on experience in SQL, Power BI, PostgreSQL, Python (data cleaning), and Excel, focused on transforming data into actionable business insights.

I build end-to-end analytics solutions covering data cleaning, transformation, exploratory analysis, KPI reporting, business analysis, and dashboard development.


Skills

Languages & Databases

  • SQL
  • Python (data cleaning)
  • PostgreSQL

Business Intelligence & Analytics

  • Power BI
  • DAX
  • Power Query
  • Microsoft Excel
  • Exploratory Data Analysis
  • KPI Reporting
  • Business Analysis
  • Dashboard Development

Tools

  • Git & GitHub
  • VS Code
  • DBeaver

Featured Projects

Olist E-commerce Business Intelligence Dashboard

End-to-end Business Intelligence analysis of Brazil's Olist e-commerce marketplace.

  • Analyzed 99,441 orders, 96,096 customers, and 3,095 sellers
  • Analyzed $13.22M in revenue
  • Investigated sales, customers, products, sellers, delivery, payments, and customer reviews
  • Identified a potential churn-risk segment despite a 4.09/5 average review score
  • Identified significant revenue concentration in São Paulo

Tools: PostgreSQL · SQL · Power BI · Power Query · DAX

View Repository


Pricing & Discount Impact Analysis

Power BI analysis of how discounting affects sales volume, profitability, and profit margins.

  • Analyzed 100,000 retail transactions
  • Analyzed $2.51B in sales and $375.53M in profit
  • Examined the relationship between discounts, sales volume, profit, and margins
  • Found profit margin declined from 20.01% at no discount to 11.97% at the highest discount tier
  • Segmented discount strategies by customer and region

Tools: PostgreSQL · SQL · Power BI · Power Query · DAX

View Repository


Certifications

  • IBM SkillsBuild — Data Analytics
  • Google Analytics Certification — 2026
  • Tata Data Visualisation: Empowering Business with Effective Insights

Education

Bachelor of Commerce (B.Com)
Western College of Commerce and Business Management
July 2023 – April 2026

CGPA: 7.20 / 10


Languages

  • English — Professional
  • Hindi — Native
  • Japanese — Intermediate

Career Focus

Interested in opportunities as a:

Data Analyst · E-commerce Analyst · Product Analyst · Business Intelligence Analyst


Connect

LinkedIn · GitHub

Popular repositories Loading

  1. olist-ecommerce-Business-Intelligence-Dashboard olist-ecommerce-Business-Intelligence-Dashboard Public

    End-to-end Business Intelligence project analyzing Brazil's Olist e-commerce marketplace using PostgreSQL, Power BI, Power Query, and DAX to uncover sales, customer, product, seller, delivery, paym…

    2

  2. Pricing-Discount-Impact-Analysis Pricing-Discount-Impact-Analysis Public

    Power BI & SQL analysis of discount strategy, profitability, product pricing, customer segments, and regional performance.

  3. rai502 rai502 Public