Pallavi Pathak
BI Analyst
About
Business Intelligence Analyst with 4+ years turning high-volume, fast-moving data into decision-ready insight for business leaders. Extremely proficient in SQL and Power BI (DAX, Power Query, data modelling), with hands-on experience running exploratory data analysis, hypothesis testing, root-cause analysis, forecasting and metric definition. Skilled at mapping business processes to their underlying data flows, building models and prototypes, and translating descriptive and diagnostic analytics into specific, actionable recommendations. Strong working knowledge of probability and statistics, a track record of linking analytics to business strategy, and exceptional bilingual (English/Hindi) written and verbal communication for explaining complex issues simply to cross-functional stakeholders.
Skills & Expertise (27)
Work Experience
Business Analyst
Line Code
Jun 2026 - Present
Run exploratory analysis and root-cause diagnostics on operational data across website development, logistics, immigration and staffing service lines, giving management centralized KPI visibility. Use SQL and Advanced Excel extensively to extract, clean, validate and reconcile data from multiple service areas, improving reporting accuracy and consistency. Build interactive Power BI reports using DAX, Power Query and data modelling to define and track metrics for leads, service performance, client activity, revenue and operational KPIs. Automate recurring data preparation and reporting with Power Query and Python (Pandas), reducing manual effort and turnaround time for business reports. Partner with Sales, IT and Senior Management to surface performance trends, test hypotheses and support faster, data-driven decisions.
Data & Insights Analyst
India Today Group
Nov 2025 - May 2026
Delivered real-time data monitoring and diagnostic analysis for the Data Intelligence Unit, covering concurrent political and economic events to support editorial decision-making. Used SQL, Excel and Power Query to extract, transform, validate and consolidate multi-source datasets into reliable reporting datasets; worked with Google Cloud Platform (GCP). Built data-quality and reconciliation checks across government, international and proprietary datasets, applying professional skepticism to flag discrepancies and limitations. Applied Python for data cleaning, hypothesis testing and exploratory analysis of high-volume datasets, accelerating recurring workflows. Delivered rapid-turnaround Power BI and Excel reports highlighting trends and actionable, decision-ready insights for leadership.
Data and Insight Analyst
Aajtak Digital
Nov 2021 - Nov 2025
Built and maintained Power BI dashboards and Excel reports to track real-time performance and define metrics across simultaneous English and Hindi news operations. Used SQL and Excel for data extraction, cleansing, validation and reconciliation across multiple reporting sources, maintaining consistent, accurate datasets. Coordinated with reporting and publication teams to map business processes to data flows and convert raw data into standardized, actionable insights, improving consistency across 2+ daily operations.
Education
Master's in Journalism and Mass Communication - Makhanlal Chaturvedi University
2019 - 2021 · Afghanistan
Bachelor of Commerce - Banasthali University
2016 - 2019 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (27)
Click a skill to find developers with the same skill
