Skip to content
View piyushxx07's full-sized avatar
👾
1%
👾
1%

Block or report piyushxx07

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.

Content in all repositories owned by your account will be closed.
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
piyushxx07/README.md

Hi, I'm Piyush Kumar 👋

Data & Implementation Analyst | Business Intelligence | Automation | Python • SQL • Power BI

Typing SVG

About Me

I am a Data & Implementation Analyst focused on business intelligence, dashboard development, automation, and customer-facing analytics.

I like building projects that do more than show charts. My focus is to understand the business problem, clean the data, build the model, create meaningful KPIs, and present insights that help teams make better decisions.

I have worked on analytics projects across:

  • Healthcare operations
  • Supply chain and logistics
  • Personal finance analytics
  • Retail sales performance
  • Customer retention and segmentation
  • Music and streaming analytics
  • Omnichannel retail analytics
  • Ecommerce discovery and funnel analysis

My focus: Business Problem → Data Model → Dashboard → Insight → Action


Tech Stack

Data, BI & Analytics



Web, Automation & Tools


Featured Projects

Hospital Analytics

Healthcare Operations Dashboard

End-to-end hospital operations dashboard built to monitor patient flow, billing, bed occupancy, doctor performance, medicine stock, and hospital finance.

Business Focus

  • Patient flow analysis
  • Billing and revenue tracking
  • Bed occupancy monitoring
  • Doctor performance analysis
  • Medicine stock visibility
  • Executive healthcare KPIs

Tech Used

Supply Chain Analytics

Logistics & Operations Dashboard

End-to-end supply chain dashboard built to analyze suppliers, procurement, inventory, production, shipments, logistics, customers, and sales performance.

Business Focus

  • Supplier performance
  • Inventory optimization
  • Shipment delay analysis
  • Procurement tracking
  • Product quality monitoring
  • Revenue and customer analysis

Tech Used

Personal Finance Analytics

Finance Dashboard with Advanced DAX

Interactive personal finance dashboard built to track income, expenses, savings, monthly growth, and financial trends using dynamic Power BI reporting.

Business Focus

  • Income and expense tracking
  • Savings performance analysis
  • Monthly growth calculation
  • Dynamic KPI cards
  • Time intelligence analysis
  • Custom tooltip insights

Tech Used

Under Armour

Customer Retention Analytics

Customer analytics project focused on churn, repeat purchases, RFM segmentation, loyalty behavior, and retention strategy for a retail brand use case.

Business Focus

  • Churn analysis
  • Customer segmentation
  • RFM modeling
  • Loyalty behavior analysis
  • Repeat purchase analysis
  • Retention strategy building

Key Numbers

  • 200K customers
  • 3M transactions
  • 2M sessions
  • 600K recommendation events
  • 18.57% churn rate
  • 55.10% churn among one-time buyers

Tech Used

Starbucks Sales Analytics

Retail Sales Intelligence Dashboard

Retail sales dashboard built to monitor revenue, order trends, customer activity, hourly sales behavior, and transaction-level insights.

Business Focus

  • Sales revenue analysis
  • Hourly order trends
  • Customer activity tracking
  • Product sales performance
  • Transaction-level reporting
  • Daily store performance

Tech Used

Sephora Analytics

Omnichannel Beauty Retail Dashboard

Omnichannel beauty retail analytics project built to understand customer journey, product performance, search behavior, campaign activity, and recommendation performance.

Business Focus

  • Omnichannel retail analysis
  • Product and brand performance
  • Customer journey tracking
  • Search and recommendation analytics
  • Campaign performance analysis
  • Revenue and funnel insights

Key Numbers

  • 503K+ customers
  • 1.3M+ reviews
  • 350K sessions
  • 896K impressions
  • 222K clicks
  • $1.173M revenue

Tech Used

Spotify Analytics

Music & Streaming Dashboard

Interactive music analytics dashboard designed to explore artist performance, song popularity, album types, explicit content trends, and playlist insights.

Business Focus

  • Artist ranking
  • Song popularity analysis
  • Album type distribution
  • Explicit vs non-explicit trends
  • Monthly and yearly popularity trends
  • Playlist and content insights

Tech Used

DiscoverIQ

Ecommerce Discovery Analytics

Ecommerce analytics project focused on search behavior, product discovery, funnel drop-offs, conversion movement, revenue decline, and customer journey analysis.

Business Focus

  • Search and discovery analytics
  • Funnel drop-off analysis
  • Conversion tracking
  • Product and category performance
  • Customer segment analysis
  • Revenue movement analysis

Key Numbers

  • 6.54M sessions
  • 3.09M users
  • 268K products
  • 726 brands
  • Revenue dropped from $27.02M to $20.36M
  • Conversion dropped from 2.82% to 2.05%

Tech Used


My Working Style

I don’t just build dashboards. I try to understand the business behind the dashboard.

My rules

  • Start with the business question
  • Clean the data before trusting the numbers
  • Build KPIs that decision-makers can understand
  • Use dashboards to explain, not decorate
  • Convert insights into actions
  • Keep improving every project

What I Like Working With

Most used in my learning and projects

Skill Where I Use It
SQL KPIs, joins, segmentation, business analysis
Python Data cleaning, EDA, automation, backend logic
Power BI Dashboards, storytelling, executive reporting
DAX KPI measures, time intelligence, dynamic calculations
Power Query ETL, data transformation, model preparation
MongoDB App data storage and workflow automation
OpenAI API AI-powered document generation and automation
Excel Data source preparation and reporting
Tableau Dashboarding and visual analytics

GitHub Activity


Contribution Graph


Current Learning Direction

  • SQL for analytics and interviews
  • Power BI dashboard storytelling
  • DAX and Power Query
  • Python for data analysis and automation
  • Business intelligence reporting
  • Customer behavior analytics
  • Healthcare and operational analytics
  • Supply chain and logistics analytics
  • Retail and finance analytics
  • Client-facing implementation support
  • Professional communication

Portfolio


“From noise to insight, from insight to action.”

Popular repositories Loading

  1. discoveriq-ecommerce-product-discovery-analytics discoveriq-ecommerce-product-discovery-analytics Public

    DiscoverIQ is a Power BI analytics project that transforms large-scale ecommerce behavior data into product discovery insights, ranking opportunities, funnel analysis, and conversion optimization r…

    Jupyter Notebook

  2. Under-Armour-Customer-Retention-Personalization-Experimentation-Analytics Under-Armour-Customer-Retention-Personalization-Experimentation-Analytics Public

    SQL + Power BI ecommerce analytics project analyzing customer churn, RFM segmentation, cohort retention, personalization performance, and A/B testing uplift for a synthetic Under Armour dataset.

    Jupyter Notebook

  3. sephora-omnichannel-ecommerce-intelligence sephora-omnichannel-ecommerce-intelligence Public

    End-to-end Sephora-style omnichannel ecommerce analytics project using SQL, Python, and Power BI to analyze revenue, funnel performance, search discovery, campaigns, customers, inventory risk, reco…

    Jupyter Notebook

  4. Data-Analytics-Bootcamp-Certification Data-Analytics-Bootcamp-Certification Public

    Data-Analytics-Bootcamp-Completion-Certification

  5. Hospital-Analysis-Dashboard Hospital-Analysis-Dashboard Public

    🏥 End-to-End Hospital Analytics Dashboard | Power BI • DAX • Power Query | Interactive healthcare business intelligence solution for patient analytics, doctor performance, hospital operations, medi…

    Python

  6. piyushxx07 piyushxx07 Public

    Hello world, this is my profile