AKAbdullah Khan

Freelance • Fleet analytics client • 2022

Webfleet API to Power BI Delivery Pipeline

Built a scheduled ETL that extracts 15 API tables, applies cleansing, and publishes SharePoint CSV outputs for Power BI reporting.

Challenge

Source data had variable time windows and required deterministic cleaning before dashboard consumption.

Solution

Implemented configurable extraction windows, pandas-based transforms, and automated upload workflows on Azure VM scheduling.

Outcomes

  • Stabilized daily dashboard refresh process
  • Created reusable configuration patterns
  • Reduced manual reporting work

Technology Stack

  • Python
  • Pandas
  • Webfleet API
  • SharePoint
  • Azure VM
  • Logic Apps

Ready To Build

Want this delivery model for your team?

I can map the same principles to your architecture, timeline, and constraints.

Talk About Your ContextBack to Projects