Ankit Kumar Sen – Data Analyst | SQL, Power BI & Marketing Analytics
Hi, I’m Ankit Kumar Sen — a Data Analyst with 4+ years of experience in marketing analytics, SEO, and performance data analysis. I specialize in SQL, Power BI, and Google Analytics to transform raw data into actionable business insights.
Improved ROI by 12% through data-driven campaign analysis and optimization.
Tools & Skills I Use to Solve Business Problems
🧠 Data Analysis
SQL
Joins | Group By | Aggregations | Filtering
Excel
Pivot Tables | XLOOKUP | Power Query
Data Cleaning & Transformation
Missing Values | Data Formatting
📊 Data Visualization
Power BI
DAX | Data Modeling | Dashboard Design
Looker Studio
Interactive Dashboards | Reporting
⚙️ Analytics Tools
Google Analytics 4
Traffic Analysis | User Behavior
Google Tag Manager
Event Tracking | Data Collection
Featured Projects 🚀
Real-world data analytics projects focused on solving business problems using SQL, Power BI, and marketing data.
🔥 Marketing Performance & ROI Analysis
Analyzed multi-channel marketing data to optimize ROI, CAC, and budget allocation using dashboards and business insights.
View Case Study →Lead Funnel Drop-Off Analysis
Identified conversion leaks in funnel stages and improved performance using data-driven insights.
View Project →Sales & Marketing Dashboard
Unified sales & marketing data into a single dashboard to track revenue and performance KPIs.
View Project →SQL Business Insights Analysis
Used SQL (JOIN, GROUP BY) to extract insights and analyze performance trends.
View Queries →A/B Testing Analysis
Analyzed experiment results and conversion impact to support data-driven decisions.
View Analysis →GA4 Analytics Dashboard
Built GA4 dashboard tracking leads, calls, and user behavior for business insights.
View Dashboard →Experience & Professional Background
Turning data into insights to improve business performance, optimize funnels, and support data-driven decisions.
Executive – Digital Marketing (Analytics-Focused)
IRM Enterprises Pvt. Ltd. | Sep 2025 – Present
- Analyzed multi-market performance data to evaluate ROI, CPL, and conversion efficiency.
- Built GA4 & Looker Studio dashboards for leadership reporting and strategic decisions.
- Identified funnel drop-offs and optimization opportunities improving lead quality.
- Delivered data-driven insights to support budget allocation and performance growth.
Digital Marketing Analyst
Tuchware Technologies Pvt. Ltd. | Sep 2022 – Aug 2025
- Analyzed multi-channel data (website, campaigns, offline) to identify growth opportunities.
- Built 5+ Power BI dashboards tracking CAC, ROI, and funnel performance.
- Improved campaign ROI by 12% through A/B testing and performance analysis.
- Performed funnel analysis (Traffic → Leads → Conversion) to identify revenue leakages.
Social Media Marketing Executive
VOSO Store | Apr 2021 – Aug 2022
- Tracked campaign performance metrics and supported reporting.
- Assisted in data collection and basic analysis for marketing optimization.
Certifications & Professional Learning
Continuous learning in data analytics, dashboards, and business intelligence to solve real-world problems.
Google Analytics 4 (GA4)
Web Analytics • Funnel Tracking • User Behavior
GoogleAdvanced Excel & SQL for Analytics
Data Analysis • Reporting • Business Insights
Data AnalyticsPower BI & Dashboard Design
KPI Dashboards • Data Modeling • Visualization
Power BIGoogle Data Analytics Professional Certificate
End-to-End Data Analysis • SQL • Data Cleaning • Visualization
CourseraLet’s Connect
Looking for a Data Analyst who can turn data into actionable insights and drive business decisions? Let’s connect and discuss how I can add value to your team or project.