IT server
Use Case

Enterprise Data Consolidation

Create a single data repository that provides optimal data governance and availability across your organization

IT server

Business Problem

As enterprises make decisions on data from different sources, such as customer analytics, marketing campaign results and sales pipelines, they must connect and blend that data for a full picture. But when different users apply different methods to consolidate the same data, discrepancies arise. That can lead to different departments misunderstanding customer signals, inaccurately reporting financial results or reaching different conclusions on key performance indicators (KPIs).

Alteryx Solution

With an automated process that cleans and unifies all company data into a single repository, users are assured that they’re all looking at the same data. They can then apply the same business rules to make calculations like KPIs and pipeline status.

The main benefits of creating and enforcing a single data source are:

  • Data Governance – Enforce calculation rules before data is extracted, reducing the time needed to arrive at results and ensure everyone is working from the same data
  • Transparency – State which calculations are used at every point throughout the workflow
  • Efficiency – Enable users to find and extract their own data, thereby reducing the burden on data science and analytics teams

With Alteryx, you can:

  • Create a Designer workflow that connects to multiple data sources like Snowflake, Salesforce and MongoDB, and maintain it with Data Connection Manager (DCM)
  • Create a transparent process that blends data and applies business rules automatically
  • Schedule an extract-transform-load (ETL) process that runs hourly to populate, consolidate and update your data repository

    Data Sources Simplified Workflow

    	062 Enterprise Data Consolidation

    1 - Data Connection

    Use an Alteryx Data Connector to automate extraction from sources like MongoDB, Salesforce and Box

    2 - In-Database Capabilities

    Perform data prep and blend with the In-Database toolkit before extraction

    3 - Prep and Blend

    Easily combine data from all sources into a single data pipeline and automate application of business rules like KPI calculations

    4 - Update Scheduling

    Schedule your workflow to populate and update your data repository using Alteryx Server

    Additional Resources

    snowflake logo on phone

    Starter Kit for Snowflake

    salesforce building

    Starter Kit for Salesforce


    Starter Kit for Analytic Apps

    AWS logo

    Starter Kit for AWS

    Data Preparation and Analytics

    Data Governance and Auditability | Alteryx

    Transform Your Analytics

    Get ready to unlock hidden insights in your data.