11/07/2026 updated
100 % available
Data Analyst | Product Analytics | SQL, Power BI & Excel Expert
Gaya, India
Only remote
Post Graduate Diploma in Data Science, IIIT BengaluruSql Data WarehouseMicrosoft Analysis ServicesAnalytic ApplicationsBusiness AnalysisData ControlData IntegrationData TransformationDatasheetsData VisualizationDatabase AnalysisData-Flow AnalysisGoogle AnalyticsIntelligence AnalysisData IntelligencePython (Programming Language)
SQL & Data Extraction
Proficiency in SQL including Joins, CTEs, Aggregations, Window Functions, and CASE Statements for extracting and analyzing data, understanding table structures, metric definitions, and data relationships for accurate product analysis.
Power BI & Dashboard Development
Hands-on experience building interactive Power BI dashboards to track revenue, admissions, funnel conversion, course performance, feature adoption, payment metrics, and user trends, enabling stakeholders to monitor business performance and identify actionable insights.
Funnel, Retention & Cohort Analysis
Expertise in funnel analysis, retention and churn analysis, cohort analysis, and KPI performance analysis to understand user behavior, identify conversion friction points, and support data-informed business decisions.
Excel & Reporting
Advanced Excel skills including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, and KPI Tracking for building recurring reports and presenting trends and insights through charts, tables, and visual analysis.
Python
Knowledge of Python as part of the technical skill set for data analysis and processing tasks.
AWS Quicksight
Familiarity with AWS Quicksight as a BI tool for data visualization and business intelligence reporting.
Data Validation & Data Quality
Experience in data validation and ensuring data quality to support accurate reporting for leadership reviews and reliable analytical outputs.
KPI & Business Metrics Monitoring
Monitoring of daily and weekly business KPIs including revenue, admissions, conversion, payment success, and retention, as well as social media KPIs such as reach, impressions, engagement, follower growth, and content performance.
Advertising & Campaign Performance Analysis
Analysis of advertising performance metrics including CTR, conversion rate, and ROI to evaluate campaign performance and support monetization and audience-targeting decisions.
Statistical Analysis & Segmentation
Application of statistical analysis and segmentation techniques to identify high-value user segments, engagement patterns, and performance trends supporting business strategy.
Proficiency in SQL including Joins, CTEs, Aggregations, Window Functions, and CASE Statements for extracting and analyzing data, understanding table structures, metric definitions, and data relationships for accurate product analysis.
Power BI & Dashboard Development
Hands-on experience building interactive Power BI dashboards to track revenue, admissions, funnel conversion, course performance, feature adoption, payment metrics, and user trends, enabling stakeholders to monitor business performance and identify actionable insights.
Funnel, Retention & Cohort Analysis
Expertise in funnel analysis, retention and churn analysis, cohort analysis, and KPI performance analysis to understand user behavior, identify conversion friction points, and support data-informed business decisions.
Excel & Reporting
Advanced Excel skills including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, and KPI Tracking for building recurring reports and presenting trends and insights through charts, tables, and visual analysis.
Python
Knowledge of Python as part of the technical skill set for data analysis and processing tasks.
AWS Quicksight
Familiarity with AWS Quicksight as a BI tool for data visualization and business intelligence reporting.
Data Validation & Data Quality
Experience in data validation and ensuring data quality to support accurate reporting for leadership reviews and reliable analytical outputs.
KPI & Business Metrics Monitoring
Monitoring of daily and weekly business KPIs including revenue, admissions, conversion, payment success, and retention, as well as social media KPIs such as reach, impressions, engagement, follower growth, and content performance.
Advertising & Campaign Performance Analysis
Analysis of advertising performance metrics including CTR, conversion rate, and ROI to evaluate campaign performance and support monetization and audience-targeting decisions.
Statistical Analysis & Segmentation
Application of statistical analysis and segmentation techniques to identify high-value user segments, engagement patterns, and performance trends supporting business strategy.
Experience
Professional experience0 - 5 years
Freelancer since2024
Languages
EnglishFluent
Project history
Analyzed the end-to-end user conversion funnel identifying a 42% drop-off from course exploration to Add to Cart. Monitored daily and weekly business KPIs including revenue, admissions, conversion, payment success, and retention. Analyzed Standard, Prime, and Pass Course performance across admissions, revenue, conversion, and user behavior. Evaluated Wishlist, Ask Doubt, and Refer & Earn features and analyzed Wishlist user behavior and purchase conversion. Built interactive Power BI dashboards to track revenue, admissions, funnel conversion, course performance, feature adoption, payment metrics, and user trends.
Analyzed user engagement data including logins, listening time, and listening frequency to identify behavioral patterns, engagement trends, and changes in product performance. Extracted and analyzed data using SQL. Conducted retention and churn analysis to understand subscriber behavior, loyalty patterns, and drop-off points. Built dashboards and recurring reports to monitor key product and business KPIs. Analyzed advertising performance metrics including CTR, conversion rate, and ROI.
Analyzed Facebook and Instagram performance for client pages across the film and healthcare sectors, evaluating content performance, audience engagement, and growth trends. Tracked and analyzed daily social media KPIs including reach, impressions, engagement, follower growth, and content performance. Evaluated content and audience performance to identify high-performing content and engagement patterns. Created structured reports and dashboards to present social media trends and performance insights to business and marketing teams.