THE CHALLENGE

The Azure Data Factory Space was challenging due to
broad Customer bases and known ETL Friction Points:

  • many platforms and methods to run ETL workloads

  • No ETL Sanitizing or global geo-redundant storage

  • No Automation (authored, tested and run manually)

  • No Data Verification or Enterprise security / encryption

  • No Standard User Interface for configuring pipelines

THE SOLUTION

A Unified, Integrated platform for automated workloads that “lifts and shifts” customers into the cloud:

  • Standard Scripting Language to automate scenarios

  • Visual Authoring Tool (Pipeline Builder) to configure DB operations remotely, across any platform, globally

  • Built Roadmap for isometric Cloud Scenario Builder

  • Built Unified Migration tools for common ETL/prep tasks

THE RESULTS

40% increase in downloads of ADF’s enhanced
Visual ETL toolset in only 3 months’ time!

  • 50% increase in Paid Azure ETL Subscriptions

  • 250k DLs of Visual Authoring (Pipeline Builder)

  • 100k DLs for VPA / ADF Mobile (iOS/Android)

  • Executive Sponsorship for Scenario Builder prototype

  • 40% Overall usage increase for Data Factory on Azure

UX RESEARCH PROCESS

The Existing Data Factory Toolset had legacy and usability challenges to surmount, as an outgrowth of the on-premise database management landscape.
Considering our competition and then contrasting it with Microsoft’s approach helped me to:

  • Conduct User Interviews to capture unknown UX issues

  • Leverage IoT device metadata and telemetry for analytics

  • Use App Instrumentation for user insight

    • Data Science tools can mine data for usage patterns

    • Automation can drive predictive systems

  • Run Usability Studies to find and solve user friction points

  • Launch award-winning cross-platform cloud data experiences

02_interDes-3_Brainstorming_Slug_v01.png
Personas_1.png
Personas_2.png

USER JOURNEYS

WORKFLOWS & USAGE SCENARIOS

Organizational-Model.png

VISUAL DEVELOPMENT

PROTOTYPES