Skip to main content
Iktisha Prasad

Iktisha Prasad

Final-year B.Tech CSE(AI) student and Data Analyst Intern

Talent
LucknowMember since May 14, 2026
SQLPythonJavaMySQLSQLitePower BITableauDAXPower QueryKPI ReportingDashboardingData VisualizationETL AutomationData CleaningData ModelingStar Schema DesignRevenue Recognition ReportingCohort AnalysisChurn & Retention ModelingLTVBehavioral SegmentationPandasNumPyMatplotlibAdvanced ExcelMicrosoft ExcelDashboard DevelopmentPipedreamARPUUnit Economics
·

Hire this person

Send a job offer directly to this candidate

SQLPythonJavaMySQLSQLite

About

Final-year B.Tech CSE(AI) student and Data Analyst Intern with hands-on experience building production BI dashboards, automating ETL pipelines, and standardizing KPI reporting in a live corporate environment. Proficient in SQL, Python, Power BI, Tableau, and DAX, with a track record of turning operational data into decisions stakeholders act on — including churn, retention, and unit-economics analysis across a 5+ dashboard portfolio.

Experience

Data Analyst Intern - A Box of Stories

(2026-02 - 2026-06)

  • Built and maintained 5+ live Power BI dashboards (Daily Sales, Subscriptions, UK & US Revenue Recognition) tracking MRR, churn, retention, and sales performance across 60+ engineered DAX measures.
  • Automated end-to-end ETL pipelines using Power Query (M) and Pipedream to ingest and reconcile data from Shopify, ReCharge, and Seal APIs, cutting manual reporting effort by 10+ hours/week.
  • Audited and validated a 70+ field REST API schema, identifying and resolving data inconsistencies (date formats, type mismatches, null values) to safeguard downstream analytics accuracy.
  • Built behavioral and tenure-based churn segmentation across product categories to flag at-risk customer cohorts, supporting proactive retention strategy for the business team.
  • Designed unified Daily Sales and cross-channel KPI dashboards consolidating Shopify and Seal & Recharge data, iterating on visuals and filters based on stakeholder requirements.
  • Developed unit economics dashboards tracking LTV, ARPU, and net margin to support revenue and profitability decisions.

Education

B.Tech - Computer Science & Engineering (Artificial Intelligence) - KIET Group of Institutions, AKTU (2027)

Class XII - CBSE (2022)

Class X - CBSE (2020)

Reviews

Related