top of page

Weave Apparels

Case Study

Problem Statement

Weave Apparel’s marketing team is currently hampered by a manual data process for their “Summer Splash” campaign. Each morning, a team member must manually download a CSV file of the previous day's performance data, a process that is both slow and prone to human error. This operational bottleneck delays the analyst team's ability to generate timely, data-driven insights. Our objective is to eliminate this inefficiency.

Solution

The solution is to architect and deploy a robust, fully automated process that loads the daily campaign performance CSV into a Microsoft Fabric Lakehouse without any manual intervention.

Copy Activity Source_edited.jpg
Copy Activity Destination.png
Lakehouse.png

A data pipeline using the Copy Activity was deployed:

  • Source: A fixed folder where the marketing team drops the daily CSV export.

  • Destination: A Lakehouse Delta table.

  • Load strategy: Overwrite the target table each run to avoid any duplicate accumulation

Copy Activity Schedule.png

The pipeline is triggered to activate at a fixed time everyday for the campaign duration. In case of a failed run, the team is notified automatically via an Outlook email and MS Teams message mentioning the time at which the failure occurred.

Business Impact

  • 100% automation of daily ingestion

  • ~1 business day latency (analysts get data the same morning)

  • Higher accuracy & consistency (no manual file handling)

  • Faster decisions for the marketing team with reliable morning availability

bottom of page