About
Prakhar has around 8 years of experience working as a data analyst across e-commerce, edtech, fintech, logistics, and B2B SaaS environments. His work has consistently been at the intersection of product and marketing analytics — using data to answer questions about where users drop off, which channels actually drive retention, and how to run experiments that produce reliable results rather than noise.
He started Data Analyst Interview after spending time helping friends and colleagues prepare for data analyst roles. The material he put together for that — SQL question banks, case study frameworks, Python exercises — turned out to be more useful than most of what was publicly available, so it became a website.
He has an engineering background from Shri G S Institute of Technology & Science and holds advanced certifications in SQL and Google Analytics. He has received the Excellence Monthly Award during his career in analytics.
Work Experience
Led product analytics across onboarding, activation, engagement and conversion flows. Built the company-wide KPI framework covering AARRR metrics. Ran A/B tests on onboarding flows and pricing screens. Built multi-touch attribution models combining CRM, web, call and email data. Automated analytics pipelines using Python, dbt, BigQuery and Airflow — reduced manual workload by 40%. Improved ROAS by 23% through GTM team collaboration on data-backed campaigns.
BigQuerydbtAirflow
PythonSalesforceHubSpot
GA4GTMLookerPower BI
Drove analytics for new product launches and user lifecycle mapping — from signup through onboarding, module completion, and payment. Identified major drop-offs in learning modules; UX changes based on this analysis increased module completion by 22%. Optimised the lead-to-paid funnel by 17% through campaign testing and targeted messaging. Built multi-touch attribution combining CRM and performance marketing data.
HubSpotSalesforceGA4
MetabaseTableauLooker Studio
GTMOutreach
Built dashboards and reporting across supply-demand, seller performance, repeat users and category growth using BigQuery, MySQL and Postgres. Built cohort and retention models to identify high-value buyer segments — reactivation campaigns boosted retention by 15%. Integrated CRM and marketing data to analyse acquisition efficiency; improved ROAS by 20%. Automated ETL processes using Python, Airflow and Cloud Functions.
BigQueryMySQLPython
AirflowPower BIMetabase
HubSpotMeta Ads
First professional analytics role. Built reporting, worked on e-commerce and content performance analytics, and began developing the data communication skills — translating technical findings for non-technical audiences — that later shaped the approach behind Data Analyst Interview.
Technical Skills
Data & SQL
SQL — BigQuery, DataGrip, Metabase, Snowflake
dbt (data build tool)
Airflow (pipeline orchestration)
ETL automation, Cloud Functions
Python
Pandas — data manipulation & analysis
NumPy — numerical computing
Scikit-learn — ML projects
Matplotlib — visualisation
Dashboards & BI
Tableau
Looker Studio
Power BI
Metabase
Analytics & CRM
GA4, GTM — tracking & attribution
Salesforce, HubSpot — CRM data
A/B testing & experimental design
Multi-touch attribution modelling
Certifications
🏆
SQL (Advanced) Certificate
HackerRank
📊
Advanced Google Analytics
Google
🎖️
Excellence Monthly Award
Received during professional tenure
Education
Bachelor of Technology (B.Tech)
Shri G S Institute of Technology & Science
Articles by Prakhar
