Data Sheet
Alteryx Designer
Enabling Self-Service Data Analytics
for Your Entire Organization
The repeatable workflow As a business analyst, you may be all too familiar with the complicated and painful
environment inherent in Alteryx nature of the analytic process. You often need one set of software tools to gather,
Designer allows you to: cleanse, and blend information from the ever-growing number of data sources,
a different set to build and publish analytic models, and still more applications
• Connect to and cleanse data
to put your time-critical information into the hands of business decision-makers.
from data warehouses, cloud
And that’s if you even attempt these steps yourself without relying on a centralized
applications, spreadsheets,
analytics department staffed by data scientists with other priorities.
and other sources
• Easily join data from Alteryx changes everything you know about the convoluted and time-consuming
multiple sources analytic process, empowering data analysts and line-of-business users to perform
their own analytics. Alteryx Designer provides a single platform that lets you rapidly
• Perform analytics—predictive,
process large volumes of data without writing any code. With the ability to access,
statistical, and spatial—
prep, blend, and analyze all your data and output analytic results to all popular
using the same intuitive
formats using a repeatable workflow, you eliminate the analytic latency inherent
user interface
in traditional approaches. The result? Deeper insights in hours rather than weeks.
Prep, Blend, and Analyze Data—All in a Single Platform
To do your job as a business analyst, you must access and blend data from many
sources: internal data from spreadsheets and data warehouses, third-party data
from external data providers, and cloud-based data from social media applications,
Big Data stores, and other SaaS platforms. Typically, this means leveraging multiple
tools—and even multiple people—to pull together all the relevant data you
need for your analytics.
Not anymore. Alteryx eliminates the inefficiencies inherent in legacy BI and analytic
tools with a self-service analytics platform. Using Alteryx Designer, you can access,
prep, and blend your data up to 100X faster than with other approaches. And because
Alteryx Designer enables you to complete the full range of analytic needs in a single,
repeatable workflow and without any programming, you’ll speed through the
previously time-consuming analytic process, leaving you with more time to perform
value-added analysis.
Prep, blend, and analyze all your
data using a repeatable workflow
for deeper insights in hours instead
of weeks
Alteryx Designer enables you to access That means another bottleneck and
practically any data source, including: level of indirection while you wait
for someone else to create your
• Data warehouses and databases,
analytic application.
such as Oracle, Microsoft SQL Server,
SAP, Teradata, Pivotal Greenplum,
Now, Alteryx puts the power of
and more, with the option of in-
predictive analytics in your own hands.
database or in-memory processing
With Alteryx Designer, you can turn
• ERP and cloud-based applications, your raw data into actionable insight
such as Salesforce.com, Marketo, with drag-and-drop tools that let you
and Google Analytics create and run your own predictive
analytics with no programming. Using
• Hadoop data stores, including
the Alteryx visual interface and more
Cloudera and MapR distributions
than 40 predictive tools based on the
• NoSQL databases, such as MongoDB R open-source statistical language,
you can quickly and easily predict
• Flat files and Office applications,
customer behavior, determine future
such as Microsoft Excel and Access
inventory requirements, identify new
• Social media data from Twitter, retail store locations, and more.
Facebook, and Foursquare
Alteryx Designer lets you easily include
• Third-party data from Experian, D&B,
any of the following predictive analytics
TomTom, and the U.S. Census Bureau
without any programming:
• Legacy analytics platforms, such as
• Predictive modeling techniques,
SPSS and SAS
such as linear and logical regression
and decision trees
Make Better Business
Decisions with Powerful • Clustering techniques, such as
R-Based Predictive Analytics K-centroid clustering and principal
component analysis
You know that the most accurate
business decisions are based on • Data investigation techniques,
forward-looking, predictive analytics such as scatter plots and
rather than on past performance association analysis
or simple guesswork. Unfortunately,
most predictive analytics tools
require statistical experts with
specialized training to code complex
algorithms and complicated models.
2
Advanced spatial analytics tools in
Alteryx Designer enable drive-time
calculations, trade area analysis,
spatial matching, and more
Let Location Matter by Including With Alteryx Designer, you can add
Spatial Analytics in Your Analysis spatial context, such as:
Thanks to the explosive growth • Geocoding and standardization
of mobile computing and social of addresses
media, most consumer and business
interactions now include a location • Data blending on spatial aspects
data-point, making spatial analysis an • Trade area creation and analysis
increasingly significant component
in data analysis. Who is buying your • Drive-time analytics
product, where are they located, • Mapping and geographic
how far away do they live from and visualization
how long does it take them to reach
the nearest store—these questions all
Deploy and Share Analytics at Scale
factor into the decision-making process.
But, as with predictive analytics, Your job is not done after you run
geospatial and location intelligence your analysis: now you need to get
has been the domain of a small number the insight ready for and into the
of experts who cannot scale to meet hands of other business users and
the needs of growing businesses decision-makers. Often, you spend as
with an increasing dependence much or more time recreating reports,
on analytics. refreshing data, or packaging the
results for consumption by others as
Alteryx Designer enables you to easily you do running the actual analysis.
append pre-packaged location data What’s involved? Cutting and pasting
from TomTom to the rest of your data into reports, changing data formats
set using an intuitive, drag-and-drop for visualization tools, and updating
interface, so you can not only visualize files to feed into other systems. All of
where events are taking place, but which wastes time and introduces
also understand their impact on errors, negating the power and
your business. Now you can conduct timeliness of the insight itself.
advanced location-based calculations,
such as drive-time, trade area, and Alteryx Designer helps you opera
spatial matching and point creation tionalize, automate, and streamline
analyses, in your same analytic sharing of data insights throughout
workflow—and make location- your organization. Alteryx Designer
based decisions that make sense helps you operationalize your analytics
for your business. by deploying production processes
that make it easy to schedule and scale
analytics across your organization.
3
Once you’ve completed your analysis, What’s more, you can schedule all of
you can output analytic results to these outputs to refresh automatically,
all popular formats, including native using the optional desktop automation
Tableau, QlikView, or Microsoft Power add-on. With it, you can schedule
BI file formats, for data visualization. workflows to run as often as the data
You can also publish analytic apps that changes—nightly, weekly, quarterly,
empower others in your organization or on any schedule that meets your
to get customized insights. And you needs. The result? Your decision-
About Alteryx can create beautiful custom reports makers always have access to the
Alteryx is the leader in self-service data featuring tables, charts, and maps latest information and insights,
analytics. Alteryx Analytics provides that bring your insights to life. improving the quality of your business
analysts with the unique ability to easily decisions and enhancing your
prep, blend, and analyze all of their data competitive advantage.
using a repeatable workflow, then
deploy and share analytics at scale for
deeper insights in hours, not weeks. Desktop System Requirements Supported File Formats
Analysts love the Alteryx Analytics Minimum Flat Files
platform because they can connect to • Microsoft Windows 7 or later (64-bit) • ASCII
• Quad Core i7 (single chip) • Comma Separated Value – CSV
and cleanse data from data warehouses, • 3GHz or faster processor • dBASE file format – DBF
cloud applications, spreadsheets, • 8G RAM • Hyper Text/Extensible Markup Language –
and other sources, easily join this data • > 1 TB free disk space HTM/HTML/XML
Recommended • IBM SPSS file format – SAV
together, then perform analytics— • Microsoft® Access database – MDB/ACCDB
• Microsoft Windows 7 or later (64-bit)
predictive, statistical, and spatial— • Quad Core i7 (single chip) • Microsoft Excel® spreadsheet –
using the same intuitive user interface, • 3GHz or faster processor XLS/XLSX/ XLSM
• 16G RAM • Qlik – QVX
without writing any code. Thousands • SAS binary file format – SAS7BDAT
• > 1 TB free disk space
of companies and data analysts • Tableau – TDE
worldwide rely on Alteryx daily. In-Database Support Relational Database Files
• Apache Hive • Object Linking and Embedding
Visit www.alteryx.com or call • Amazon Redshift Database – OLE-DB
1-888-836-4274. • Impala • Open Database Connectivity – ODBC
• Microsoft Azure SQL Data Warehouse • Oracle® – OCI
• Microsoft SQL Server
• Oracle Spatial Files
• Spark SQL • Alteryx Spatial Zip – SZ
• Teradata • ESRI® ArcMap® Shape _ SHP
(includes .SHP, .DBF, .SHX, .PRJ)
Supported Databases • ESRI Personal Geodatabase® – MDB/PGDB
• Amazon Aurora • Google Keyhole Markup Language – KML
• Amazon Redshift • Grid and Classified Grid – GRD/GRC
• Amazon S3 • MapInfo Professional® Interchange
• Apache Hive Format – MID/MIF
• Cassandra • MapInfo Professional Table – TAB
• Cloudera Impala (includes .TAB, .DAT, .MAP, .ID, .IND)
• Databricks • SDF – Autodesk® Spatial Data Files
• ESRI GeoDatabase (read-only support)
• Exasol Reporting Formats
• Google BigQuery • Adobe® Portable Document Format – PDF
• Hadoop Distributed File System • Alteryx Markup Language – PCXML
• Hortonworks • Hyper Text Markup Language – HTML
• HP Vertica • Microsoft Excel – XLS/XLSX
• IBM DB2 • Microsoft PowerPoint – PPT/PPTX
• IBM Netezza® • Microsoft Word – DOC/DOCX
• Microsoft Azure SQL Data Warehouse • Portable Network Graphics – PNG
• Microsoft SQL Server® • Rich Text Format – RTF
• MongoDB Tools/Macros
• MySQL® • Adobe Analytics
• Netsuite • Foursquare
• Oracle • Google Analytics
• Pivotal Greenplum Database • Google Sheets
• SAP Hana • Marketo
• SQLite • Microsoft Azure ML
• Sybase® • Microsoft Power BI
• Teradata® and Teradata Aster • Microsoft SharePoint
• Salesforce.com
For a complete list of system requirements, • Tableau
and supported data sources visit: – Alteryx Web Data Connector for Tableau
www.alteryx.com/TechSpecs – Publish to Tableau Server
3345 Michelson Dr., Ste. 400, Irvine, CA 92612 • Twitter
+1 714 516 2400
www.alteryx.com Alteryx is a registered trademark of Alteryx, Inc. 6/16
