Vidhi Abhay Bhatt
Vidhi Bhatt is a data and BI analyst based in Berlin, with an MSc in Data Analytics and three years in television audience measurement at TAM Media in India, where she built audience-engagement reporting in SQL, dbt, Power BI and Tableau. On the Genyad blog she covers the measurement side of video advertising: how the metrics are defined, what the published benchmarks actually say, and the arithmetic behind the calculators.
What Vidhi writes here
- Metric definitions and formulas: hook rate, thumbstop rate, completion rate, frequency
- Reading the published platform and agency benchmarks, and where they disagree
- The arithmetic in the free calculators, including where each model breaks down
- Audience measurement and reporting methodology
And what she does not
- Creative direction and scriptwriting, which come from the team running Genyad's own campaigns
- Media buying and account management
- Video production and editing craft
Experience
Operations Officer, VFS Global
November 2025 to present
High-volume application processing and case handling in Salesforce Service Cloud, against SLAs and documented operating procedures.
BI Analyst, Customer Success, Bettermile, Berlin
August 2023 to July 2024
Introduced a customer-facing KPI, built weekly analytical reporting in AWS QuickSight, and analysed driver journey data to find operational efficiency. Reported monthly to C-level. Held as a working student alongside the MSc.
Content Analyst, TAM Media, India
November 2019 to April 2022
Television audience measurement. Built SQL and dbt models on Snowflake and audience-engagement dashboards in Power BI and Tableau, automated recurring reporting in Python, and worked with marketing and analytics teams on content planning. This is the media-measurement experience the benchmark and metrics work on this site draws on.
Education and certifications
| Qualification | Institution | When |
|---|---|---|
| MSc Data Analytics | Berlin School of Business and Innovation | October 2022 to July 2024 |
| BSc Chemistry | The Maharaja Sayajirao University of Baroda | 2014 to 2017 |
| dbt Fundamentals | dbt Labs | Certification |
| Google Cloud Big Data and Machine Learning Fundamentals | Google Cloud | Certification |
| Developing Data Models with LookML | Google / Looker | Certification |
| BigQuery for Data Warehousing | Google Cloud | Certification |
| Exploring and Preparing your Data with BigQuery | Google Cloud | Certification |
| Databases and SQL for Data Science with Python | IBM | Certification |
| Google Data Analytics Capstone | Coursera | Certification |
Tools and methods
| Area | Tools |
|---|---|
| Languages and querying | SQL, Python |
| BI and reporting | Tableau, Power BI, Looker, AWS QuickSight, Excel (advanced) |
| Modelling and pipelines | dbt, Snowflake, BigQuery, Apache Airflow |
| Analysis | Predictive modelling, Customer segmentation, Forecasting, Data warehousing |
| Languages | English (C1), German (B1) |