---
title: "Divleen Kaur - Power BI Developer in Dehradun | Tal"
description: "Meet Divleen Kaur, Ecommerce Data Analyst | Power BI, Excel & SQL | Driving RCA, KPI Insights & Performance Marketing Analytics Across D2C & Quick Commerce based in Dehradun."
image: "https://tal.club/meet/divleen-kaur/share-image"
---

# Divleen Kaur on Tal

## Headline

Ecommerce Data Analyst \| Power BI, Excel & SQL \| Driving RCA, KPI Insights & Performance Marketing Analytics Across D2C & Quick Commerce

## About

I turn messy ecommerce data into decisions that actually move the needle — OSA gaps, ROAS drops, market share shifts, you name it\. Power BI Developer at Trailytics AI, working across D2C and quick commerce platforms, building dashboards that don't just look good — they point to root cause\. What I do: I build end\-to\-end BI solutions for ecommerce and quick commerce — from raw SQL data pulls to interactive Power BI dashboards that business teams actually use\. My focus is performance analysis: tracking KPIs like On\-Shelf Availability, Sell\-Through Rate, Market Share, Share of Search, and MRP compliance across SKUs, categories, and regions\. Results I've driven: → Built 5\+ dashboards that cut stakeholder reporting time significantly → Delivered RCA frameworks for OSA and discount leakage that surfaced actionable gaps in under 24 hours → Supported performance marketing analysis across platforms including Amazon, Blinkit, Zepto, and Swiggy Instamart, Flipkart, Bigbasket — tracking impressions, CTR, CPC, CVR, and ACoS Tools & methods I work with: Power BI · SQL · Excel · Python \(scripting & automation\) · DAX · Data Modeling · ETL pipelines · A/B test analysis · Funnel analysis · Cohort analysis Currently pursuing MBA in AI & Data Science — applying ML concepts to forecast demand shifts and surface predictive signals within BI workflows\. Open to: Data Analyst / Business Intelligence roles in ecommerce, quick commerce, or performance marketing analytics — preferably with a team that moves fast and values data\-backed decisions\. 📩 DM me or connect — always happy to talk data, dashboards, or ecom strategy\.

## Location

Dehradun

## Work experience

Power BI Developer at Trailytics AI, Nov 2025 \- Present · 7 mos, 𝑆𝑐𝑜𝑝𝑒: 𝐵𝑢𝑖𝑙𝑑𝑖𝑛𝑔 𝑒𝑛𝑑\-𝑡𝑜\-𝑒𝑛𝑑 𝐵𝐼 𝑠𝑜𝑙𝑢𝑡𝑖𝑜𝑛𝑠 𝑓𝑜𝑟 𝐷2𝐶 𝑎𝑛𝑑 𝑞𝑢𝑖𝑐𝑘 𝑐𝑜𝑚𝑚𝑒𝑟𝑐𝑒 𝑏𝑟𝑎𝑛𝑑𝑠 — 𝑐𝑜𝑛𝑠𝑜𝑙𝑖𝑑𝑎𝑡𝑖𝑛𝑔 𝑚𝑢𝑙𝑡𝑖\-𝑝𝑙𝑎𝑡𝑓𝑜𝑟𝑚 𝑒𝑐𝑜𝑚𝑚𝑒𝑟𝑐𝑒 𝑑𝑎𝑡𝑎 𝑖𝑛𝑡𝑜 𝑑𝑎𝑠𝘩𝑏𝑜𝑎𝑟𝑑𝑠 𝑡𝘩𝑎𝑡 𝑑𝑟𝑖𝑣𝑒 𝑟𝑒𝑎𝑙\-𝑡𝑖𝑚𝑒 𝑏𝑢𝑠𝑖𝑛𝑒𝑠𝑠 𝑑𝑒𝑐𝑖𝑠𝑖𝑜𝑛𝑠 𝑎𝑐𝑟𝑜𝑠𝑠 𝑐𝑎𝑡𝑒𝑔𝑜𝑟𝑦, 𝑠𝑢𝑝𝑝𝑙𝑦, 𝑎𝑛𝑑 𝑚𝑎𝑟𝑘𝑒𝑡𝑖𝑛𝑔 𝑡𝑒𝑎𝑚𝑠\. 𝐖𝐡𝐚𝐭 𝐈 𝐝𝐨: \-\- Built and maintained 5\+ production Power BI dashboards using DAX and SQL, unifying data from Amazon, Blinkit, Zepto, and Swiggy Instamart — reducing stakeholder reporting time by 15% and enabling same\-day action on SKU\-level issues \-\- Designed RCA frameworks for On\-Shelf Availability \(OSA\) gaps and discount leakage, pinpointing root causes across categories and regions within 24 hours of anomaly detection \-\- Tracked full\-funnel performance marketing KPIs — impressions, CTR, CPC, CVR, ROAS, and ACoS — across 4 quick commerce platforms, supporting data\-driven campaign optimization and budget reallocation \-\- Developed ETL pipelines and data models to consolidate multi\-source ecommerce data into unified dashboards, improving reporting accuracy and eliminating manual data consolidation \-\- Monitored MRP compliance, sell\-through rate, and Share of Search across SKUs and geographies — flagging pricing and visibility risks before they impacted revenue \-\- Partnered with category and marketing teams to translate funnel drop\-off patterns and market share shifts into concrete business recommendations, bridging the gap between raw data and strategic action 𝐓𝐨𝐨𝐥𝐬 & 𝐦𝐞𝐭𝐡𝐨𝐝𝐬: Power BI · DAX · SQL · Python \(scripting\) · Excel · ETL Pipelines · Data Modeling · RCA Analysis · Funnel Analysis · Ecommerce KPI Tracking · A/B Testing

Power BI developer at Trailytics AI, May 2025 \- Nov 2025 · 7 mos, 𝐿𝑎𝑖𝑑 𝑡𝘩𝑒 𝐵𝐼 𝑓𝑜𝑢𝑛𝑑𝑎𝑡𝑖𝑜𝑛 𝑓𝑜𝑟 𝑒𝑐𝑜𝑚𝑚𝑒𝑟𝑐𝑒 𝑎𝑛𝑎𝑙𝑦𝑡𝑖𝑐𝑠 𝑟𝑒𝑝𝑜𝑟𝑡𝑖𝑛𝑔 — 𝑏𝑢𝑖𝑙𝑑𝑖𝑛𝑔 𝑆𝑄𝐿\-𝑑𝑟𝑖𝑣𝑒𝑛 𝑃𝑜𝑤𝑒𝑟 𝐵𝐼 𝑟𝑒𝑝𝑜𝑟𝑡𝑠 𝑎𝑛𝑑 𝐾𝑃𝐼 𝑑𝑎𝑠𝘩𝑏𝑜𝑎𝑟𝑑𝑠 𝑐𝑜𝑛𝑠𝑢𝑚𝑒𝑑 𝑑𝑎𝑖𝑙𝑦 𝑏𝑦 𝑠𝑎𝑙𝑒𝑠, 𝑠𝑢𝑝𝑝𝑙𝑦 𝑐𝘩𝑎𝑖𝑛, 𝑎𝑛𝑑 𝑐𝑎𝑡𝑒𝑔𝑜𝑟𝑦 𝑡𝑒𝑎𝑚𝑠\. \-\- Built Power BI reports powered by SQL data pulls, structuring ecommerce datasets for multi\-team consumption across sales and supply chain functions \-\- Tracked core ecommerce KPIs — OSA, MRP compliance, and sell\-through rate — across product categories and regional markets, enabling weekly performance reviews \-\- Developed Excel\-based analysis models for ad\-hoc business reporting, accelerating category\-level decision turnaround \-\- Automated data fetch workflows using Python scripts, reducing recurring manual data preparation effort across reporting cycles \-\- Contributed to DAX calculations and data modeling within a live production Power BI environment, gaining full\-stack BI development exposure 𝐓𝐨𝐨𝐥𝐬 & 𝐦𝐞𝐭𝐡𝐨𝐝𝐬: Power BI · SQL · DAX · Excel · Python · KPI Reporting · Data Preparation

Marketing Lead at Banasthali Vidyapith, Aug 2022 \- Jun 2025 · 2 yrs 11 mos, Alwar, Rajasthan, India, 𝐿𝑒𝑑 𝑑𝑖𝑔𝑖𝑡𝑎𝑙 𝑚𝑎𝑟𝑘𝑒𝑡𝑖𝑛𝑔 𝑜𝑝𝑒𝑟𝑎𝑡𝑖𝑜𝑛𝑠 𝑎𝑐𝑟𝑜𝑠𝑠 𝑎 𝑢𝑛𝑖𝑣𝑒𝑟𝑠𝑖𝑡𝑦 𝑝𝑙𝑎𝑡𝑓𝑜𝑟𝑚 — 𝑤𝘩𝑒𝑟𝑒 𝑡𝑟𝑎𝑐𝑘𝑖𝑛𝑔 𝑐𝑎𝑚𝑝𝑎𝑖𝑔𝑛 𝑚𝑒𝑡𝑟𝑖𝑐𝑠 𝑎𝑛𝑑 𝑎𝑛𝑎𝑙𝑦𝑧𝑖𝑛𝑔 𝑐𝘩𝑎𝑛𝑛𝑒𝑙 𝑝𝑒𝑟𝑓𝑜𝑟𝑚𝑎𝑛𝑐𝑒 𝑠𝘩𝑎𝑝𝑒𝑑 𝑎𝑛 𝑎𝑛𝑎𝑙𝑦𝑡𝑖𝑐𝑎𝑙 𝑎𝑝𝑝𝑟𝑜𝑎𝑐𝘩 𝑡𝑜 𝑐𝑜𝑚𝑚𝑢𝑛𝑖𝑐𝑎𝑡𝑖𝑜𝑛 𝑠𝑡𝑟𝑎𝑡𝑒𝑔𝑦\. \-\- Tracked campaign performance metrics — reach, engagement rate, and CTR — across digital channels, using data analysis to refine content strategy and improve audience targeting \-\- Built Excel\-based marketing performance dashboards to monitor multi\-channel KPIs, translating weekly trend data into actionable strategy recommendations \-\- Managed end\-to\-end campaign execution across social and digital platforms, iterating on content strategy based on performance data to consistently improve engagement outcomes \-\- Developed stakeholder reporting frameworks to communicate campaign results to institutional leadership — building presentation and data storytelling skills directly applicable to BI reporting 𝐓𝐨𝐨𝐥𝐬 & 𝐦𝐞𝐭𝐡𝐨𝐝𝐬: Excel · Google Analytics · Social Media Analytics · Campaign Tracking · Stakeholder Reporting

Marketing Intern at VADS GROUP, Jul 2023 \- Aug 2023 · 2 mos, Remote, 𝑆𝘩𝑜𝑟𝑡\-𝑡𝑒𝑟𝑚 𝑚𝑎𝑟𝑘𝑒𝑡𝑖𝑛𝑔 𝑟𝑜𝑙𝑒 𝑠𝑢𝑝𝑝𝑜𝑟𝑡𝑖𝑛𝑔 𝑑𝑖𝑔𝑖𝑡𝑎𝑙 𝑐𝑜𝑚𝑚𝑢𝑛𝑖𝑐𝑎𝑡𝑖𝑜𝑛 𝑎𝑛𝑑 𝑐𝑜𝑛𝑡𝑒𝑛𝑡 𝑠𝑡𝑟𝑎𝑡𝑒𝑔𝑦 𝑓𝑜𝑟 𝑎 𝑠𝑡𝑟𝑎𝑡𝑒𝑔𝑖𝑐 𝑐𝑜𝑚𝑚𝑢𝑛𝑖𝑐𝑎𝑡𝑖𝑜𝑛𝑠 𝑓𝑖𝑟𝑚\. \-\- Supported content creation and digital communication workflows, gaining exposure to campaign planning and multi\-channel execution \-\- Tracked basic engagement metrics across social platforms to evaluate content performance

Social Media Marketing Intern at The Closet Shuffle, Sep 2022 \- Oct 2022 · 2 mos, New Delhi, 𝑆𝑢𝑝𝑝𝑜𝑟𝑡𝑒𝑑 𝑠𝑜𝑐𝑖𝑎𝑙 𝑚𝑒𝑑𝑖𝑎 𝑚𝑎𝑟𝑘𝑒𝑡𝑖𝑛𝑔 𝑓𝑜𝑟 𝑎 𝐷2𝐶 𝑓𝑎𝑠𝘩𝑖𝑜𝑛 𝑏𝑟𝑎𝑛𝑑 𝑑𝑢𝑟𝑖𝑛𝑔 𝑒𝑎𝑟𝑙𝑦 𝑒𝑐𝑜𝑚𝑚𝑒𝑟𝑐𝑒 𝑔𝑟𝑜𝑤𝑡𝘩\. \-\- Created and scheduled social content, monitoring post\-level performance metrics to improve engagement rates \-\- Assisted in tracking follower growth and content reach across Instagram and Facebook

Digital Marketing Intern at Photoshooto, May 2022 \- Sep 2022 · 5 mos, Bengaluru, 𝐷𝑖𝑔𝑖𝑡𝑎𝑙 𝑚𝑎𝑟𝑘𝑒𝑡𝑖𝑛𝑔 𝑖𝑛𝑡𝑒𝑟𝑛𝑠𝘩𝑖𝑝 𝑠𝑢𝑝𝑝𝑜𝑟𝑡𝑖𝑛𝑔 𝑏𝑟𝑎𝑛𝑑 𝑣𝑖𝑠𝑖𝑏𝑖𝑙𝑖𝑡𝑦 𝑎𝑛𝑑 𝑐𝑜𝑛𝑡𝑒𝑛𝑡 𝑝𝑒𝑟𝑓𝑜𝑟𝑚𝑎𝑛𝑐𝑒 𝑓𝑜𝑟 𝑎 𝑝𝘩𝑜𝑡𝑜𝑔𝑟𝑎𝑝𝘩𝑦 𝑠𝑒𝑟𝑣𝑖𝑐𝑒𝑠 𝑝𝑙𝑎𝑡𝑓𝑜𝑟𝑚\. \-\- Managed social media content calendar, tracking engagement and reach metrics to assess channel performance \-\- Supported SEO and paid campaign monitoring, developing foundational skills in digital performance tracking

## Education

Master of Business Administration \- MBA, Data Science and AI, Graphic Era Deemed to be University

Bachelor of Commerce \- BCom, Business/Commerce, Digital Marketing, Banasthali Vidyapith

[View the original profile](https://tal.club/meet/divleen-kaur)

```json
{
  "@context": "https://schema.org",
  "@graph": [
    {
      "@type": "Person",
      "@id": "https://tal.club/meet/divleen-kaur#person",
      "name": "Divleen Kaur",
      "url": "https://tal.club/meet/divleen-kaur",
      "image": "https://tal.club/meet/divleen-kaur/profile-photo.jpg",
      "description": "Meet Divleen Kaur, Ecommerce Data Analyst | Power BI, Excel & SQL | Driving RCA, KPI Insights & Performance Marketing Analytics Across D2C & Quick Commerce based in Dehradun.",
      "jobTitle": "Power BI Developer",
      "worksFor": {
        "@type": "Organization",
        "name": "Trailytics AI"
      },
      "hasOccupation": {
        "@type": "Occupation",
        "name": "Power BI Developer"
      },
      "homeLocation": {
        "@type": "Place",
        "name": "Dehradun"
      },
      "alumniOf": [
        {
          "@type": "EducationalOrganization",
          "name": "Graphic Era Deemed to be University"
        },
        {
          "@type": "EducationalOrganization",
          "name": "Banasthali Vidyapith"
        }
      ],
      "mainEntityOfPage": {
        "@id": "https://tal.club/meet/divleen-kaur#webpage"
      }
    },
    {
      "@type": "ProfilePage",
      "@id": "https://tal.club/meet/divleen-kaur#webpage",
      "url": "https://tal.club/meet/divleen-kaur",
      "name": "Divleen Kaur on Tal",
      "description": "Meet Divleen Kaur, Ecommerce Data Analyst | Power BI, Excel & SQL | Driving RCA, KPI Insights & Performance Marketing Analytics Across D2C & Quick Commerce based in Dehradun.",
      "dateModified": "2026-06-10T13:55:59.130Z",
      "isPartOf": {
        "@id": "https://tal.club/#website"
      },
      "mainEntity": {
        "@id": "https://tal.club/meet/divleen-kaur#person"
      },
      "primaryImageOfPage": {
        "@type": "ImageObject",
        "url": "https://tal.club/meet/divleen-kaur/profile-photo.jpg",
        "contentUrl": "https://tal.club/meet/divleen-kaur/profile-photo.jpg",
        "caption": "Divleen Kaur profile photo on Tal"
      },
      "inLanguage": "en-IN"
    }
  ]
}
```