Skip to content
Connecting data pipelines...
Kavish NagpalDATA & PRODUCT ANALYTICS
ROLES: PRODUCT ANALYST • BI & DATA ANALYST • UX ANALYST • AUTOMATION SPECIALIST

BridgingDataAnalytics,UXResearch&AutomationintoMeasurable Product Decisions.

I analyze clickstream data to find growth bottlenecks, conduct UX research to understand user friction, and build Power BI dashboards and n8n automations. Bridging SQL data, user insights, and product strategy into measurable business results.

Product Analyst
BI & Data Analyst
UX Analyst & Researcher
Workflow Automation Specialist
Growth Analyst
Product Strategy
Portrait of Kavish Nagpal
KAVISH NAGPALProduct Analytics • BI • UX Research • Automation
Scroll to view case studies ↓
DATA STACK
SQLPower BIPythonAzure Synapse
//
UX STACK
FigmaUX ResearchUsability Testing
//
AUTOMATION STACK
n8nWebhooks APIAI Workflows
//
DELIVERY STACK
JiraGitHubNext.js
//
DATA STACK
SQLPower BIPythonAzure Synapse
//
UX STACK
FigmaUX ResearchUsability Testing
//
AUTOMATION STACK
n8nWebhooks APIAI Workflows
//
DELIVERY STACK
JiraGitHubNext.js
//
DATA STACK
SQLPower BIPythonAzure Synapse
//
UX STACK
FigmaUX ResearchUsability Testing
//
AUTOMATION STACK
n8nWebhooks APIAI Workflows
//
DELIVERY STACK
JiraGitHubNext.js
//
DATA STACK
SQLPower BIPythonAzure Synapse
//
UX STACK
FigmaUX ResearchUsability Testing
//
AUTOMATION STACK
n8nWebhooks APIAI Workflows
//
DELIVERY STACK
JiraGitHubNext.js
//
CAPABILITIES // DISCIPLINE TRIAD

Where I Can Help

Balancing analytical insight, interface thinking, and automated systems to solve operational friction.
DISCIPLINE TRIAD // CONNECTED NODES:
DATA (SQL & Analytics)
UX (User Research & Figma)
AUTOMATION (n8n & Webhooks)
DATA

Product Analytics

Deconstructing clickstream logs and user session events to map funnel drop-offs and behavioral trends.

Capability // Production ReadyEXPLORE →
UX

UX Research & Usability

Shadowing support loops and mapping customer wireframes to translate cognitive friction into clear design requirements.

Capability // Production ReadyEXPLORE →
DATA

Decision Intelligence

Synthesizing qualitative user feedback with database schemas to drive data-driven product decisions.

Capability // Production ReadyEXPLORE →
DATA

Dashboard Strategy

Configuring near-real-time Power BI data layers and DAX semantic models for operations leadership.

Capability // Production ReadyEXPLORE →
AUTOMATION

Workflow Automation

Setting up automated n8n routing loops and status alert dispatches across Jira boards and communication nodes.

Capability // Production ReadyEXPLORE →
UX

Product Discovery

Ideating interface wireframes and aligning B2B user journeys based on clickstream funnel drop-off diagnostics.

Capability // Production ReadyEXPLORE →
PORTFOLIO SHOWCASE // FLAGSHIP CASE STUDIES

Selected Case Studies & Interactive Technical Proofs

Each project features a sharp strategic overview (Objective & Metrics) coupled with a live interactive proof environment.

Flagship Banking Workspace

FinTrust OS

Role: Lead Data & Product Analyst

Digital Banking Operations & KYC Risk Cockpit

Onboarding Conversion+18%
Verification Latency-28%
Product AnalyticsSQLPower BIUX ResearchAutomationBanking
[ Open Workspace ]
B2B MSME Operating System

VyapaarSetu

Role: Product & Automation Analyst

B2B Operating System & Live Command Center for MSMEs

Data Latency Reduction-30%
Decision Speed+25%
n8nFigmaKPI DashboardsMSME OSSQL
Peer-to-Peer Marketplace Flow

SwapSkill

Role: UX Analyst & Product Strategist

Peer-to-Peer Skill Exchange & User Pathways Platform

Marketplace Retention+20%
Onboarding Drop-offs-35%
FigmaMixpanelUser PathwaysSkill Marketplace
Behavioral Retention Engine

Music Streaming Analytics

Role: Product Data Analyst

2M+ Event Log Behavioral Retention Engine

Platform Growth Segment70%
Cohort Precision94%
SQLPythonPower BIDAXSARIMAX
PROFESSIONAL JOURNEY // DOMAIN CHAPTERS

Career & Experience

End-to-end expertise spanning UX research, clickstream data engineering, and business automation.

R1 RCM Healthcare

Senior Data & Product Analyst
Focus: Business Intelligence, Data Products & Interface Design
  • Architect automated SQL, Python, and Power BI pipelines that reduce enterprise reporting turnaround times by 40%.
  • Lead high-fidelity dashboard redesigns in Figma to streamline executive decision paths, resulting in a 25% uptick in stakeholder engagement.
  • Facilitate product alignment between business owners, engineers, and US-based directors to translate complex workflows into clear visualizations.
  • Manage cloud data warehousing workflows in Azure Synapse to establish scalable, near-real-time executive reporting layers.
Technology Stack & Tooling
SQLPower BIPythonAzure SynapseFigmaJiraPower QueryData Lake

Belz Instruments

Operations & Data Analyst
Focus: Operational Analytics & Performance Systems
  • Deconstruct operational clickstream events and database logs to optimize checkout funnel performance and system speed.
  • Develop predictive customer churn metrics and automate reporting schedules, providing leadership with early action items.
  • Interface with customer support to align user interface complaints with quantitative database schema bottlenecks.
  • Design and maintain interactive Tableau dashboards and automate manual data extraction workflows using Python, enabling teams to rapidly identify and resolve operational inefficiencies.
Technology Stack & Tooling
SQLPythonExcelTableauProcess OptimizationPerformance Insights
// TELEMETRY AUDIT // PRODUCTION RESULTS

Measurable Product Outcomes

These metrics represent concrete, production-verified changes—from slower reporting and higher drop-offs to faster insight, higher adoption, and better UX for operators. Every percentage and milestone is derived directly from shipped production achievements. No estimated projections.

REPORT // ENTERPRISE DATA PRODUCTS (R1 RCM)

BI Operational Pipelines

Implemented Azure Synapse data integration layers and Power BI semantic models serving healthcare operations leadership.

Data Pipeline Latency
Reporting Turnaround Time
4+ days 0 hrs(Near-Real-Time)

[Problem] Leadership spent hours weekly compiling manual data exports.

[Action] Built automated Azure Synapse ETL pipelines and Power BI DAX semantic models.

[Outcome] Reduced latency to near-real-time executive dashboard visibility.

User Engagement Index
Dashboard Adoption
Low Spreadsheets Higher WAU

[Problem] Low operational metric adoption due to scattered, inconsistent spreadsheets.

[Action] Standardized visual hierarchy and created a unified KPI reporting layout.

[Outcome] Established single source of truth dashboard, boosting leader engagement index.

REPORT // TRANSACTION FUNNELS (BELZ INSTRUMENTS)

Checkout Telemetry

Mapped clickstream events in SQL to isolate payment bottlenecks and prototype checkout design solutions.

Checkout Friction
Friction Drop-off Isolated
20% drop-off 0%@ Step 3 Payment

[Problem] High checkout abandonment observed on step 3 payment selection step logs.

[Action] Mapped clickstream event logs in SQL and isolated input form bottlenecks.

[Outcome] Redesigned layout options, decreasing step 3 checkout friction to 12%.

Checkout Conversion Rate
Targeted Conversion Lift
Friction Abandonment Verified Lift

[Problem] Checkout payment delays and rigid mobile fields causing cart abandonment.

[Action] Restructured mobile button alignment and wallet checkout flows in Figma.

[Outcome] Optimized checkout speed, delivering a verified conversion lift in wallet checkout.

REPORT // PORTAL USABILITY (HEALTH-TECH PORTAL)

Information Architecture

Redesigned dense menu clusters and user flow structures to improve operators' daily billing speed.

Search Path Latency
Operator Time-to-Insight
4.2 min 0.0 min(Post-Redesign)

[Problem] Clinical billing operators spent over 4 minutes searching dense menus for daily tasks.

[Action] Conducted card sorting, condensing 18 nested category menus into 5 primary tabs.

[Outcome] Halved operator search paths, reducing average time-to-insight to 2.1 minutes.

Clinical Usability Index
Qualitative Satisfaction
3.6 score 0.0 / 5.0(CSAT Uplift)

[Problem] Complex billing validation forms caused high operator error rates and user frustration.

[Action] Designed context-specific real-time validation error alerts in high-fidelity mockups.

[Outcome] Improved form usability, raising post-launch satisfaction index from 3.6 to 4.2.

APPROACH & MINDSET

Where Analytics Meets Product

I operate at the intersection of data analytics, UX research, product strategy, and automation—connecting all four into a single, cohesive workflow.

Data-Led Discovery

Every project begins with data. Analyzing funnel metrics, session logs, and user activity reveals where real friction exists before designing solutions.

User-Centric Validation

Quantitative data shows where users struggle; qualitative research explains why. Combining both ensures every feature solves a real problem.

Automated Scale

Insights are only as valuable as their execution. Turning manual processes into automated workflows ensures sustainable, long-term impact.

CORE CAPABILITIES // HOVER TO EXPLORE
FOCUS AREA

Analytics × Product Strategy

EXPLORE →
FOCUS AREA

Product Strategy × UX Research

EXPLORE →
FOCUS AREA

UX Research × Automation

EXPLORE →

Hover over any capability above to see how analytics, research, and automation connect.

OPERATIONAL PRINCIPLE

"The best products are built when data, user research, and workflow automation work in harmony to solve clear problems."

TECHNICAL SPECIFICATION

Data & Capabilities Playbook

A breakdown of technical competencies, telemetry schemas, and analytical workflows.

capabilities_spec_v1.0

COMPETENCY MATRIX

Core technical skills across data analytics, UX research, and workflow automation.

Data Analytics & BI

SQL Query Tuning95%
Power BI / DAX Data Models90%
Python / Predictive Analytics85%
Azure Synapse Data Pipelines80%

UX Research & Design

Figma Interactive Wireframing95%
Usability Testing & Interviews90%
Information Architecture85%
Design Systems & Tokens95%

Product & Automation

n8n Workflow Automation90%
AI Agent Orchestration85%
API & Webhook Integrations80%
Product Metrics & Funnels90%
SPECIFICATION ENGINE ACTIVEPORTFOLIO SPECIFICATIONS
FAQ

Common Questions & Insights

CONTACT // CONNECTION

Let's Solve Business Problems

Let's collaborate on building data-driven product solutions, automating analytics pipelines, or bridging UX research with business intelligence.

Direct Inbox
iamkavishnagpal@gmail.com
Professional Grid🔗 LinkedIn Profile ↗
Code Repository🔗 GitHub Code ↗
© 2026 DATA & PRODUCT ANALYTICS. HANDCRAFTED IN INDIA.
ALL RIGHTS RESERVED // PERSONAL PORTFOLIO