Data & Analytics

Parse and process CSV files

Transform data between formats (JSON, XML, CSV)

Set up analytics tracking (GA4, Mixpanel, PostHog)

Create data processing pipeline

Generate reports from data

Create charts and visualizations (Chart.js, D3)

Export data in multiple formats

Create ETL (Extract, Transform, Load) scripts

Validate data integrity and format

Set up A/B testing framework

Write advanced Excel formulas (VLOOKUP, INDEX-MATCH, XLOOKUP, dynamic arrays)

Write Excel VBA macros for automation and data processing

Write Google Apps Script for Sheets automation