Conquering Automatic Data Challenges with Alteryx: Office Edition
"Join the Alteryx User Group's hands-on session covering data input, cleaning, and transformation in Excel. Learn how to handle JSON hierarchies, encoded polylines, and more for efficient data analysis. Enhance your data preparation skills and streamline your workflow with Alteryx tools."
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Alteryx User Group August 2016
Agenda Demonstration Conquering Automatic Data with Alteryx Hands on With Alteryx Excel Edition
Reminder Before We Get Started Find answers quickly with enhanced search and content recommendations Create valuable connections with peers and industry experts Submit your ideas to help us improve our products Earn reputation and rewards for your contributions Share your knowledge with the community Read insightful blog posts by data gurus Learn from real world examples* Join today: http://community.alteryx.com http://https://community.alteryx.com/t5/Portland-ME/gp-p/portland-me
Use Case 1: Automatic Office Challenge What we will cover: 1. Data input using web download tool. 2. Parsing JSON hierarchies. 3. Handling encoded polylines using Alteryx macros and binary functions. 4. Outputting multiple data sources. 5. Using data in Tableau.
Hands On With Alteryx Excel Edition What we will cover: Dynamic data input from multiple files and worksheets. Conforming poorly structured data using common Alteryx tools. Using transformation and summary tools Outputting data to multiple sources.
Why Todays Exercise Matters The New York Times reports that data scientists spend from 50 percent to 80 percent of their time collecting and preparing unruly digital data, even before it can be analyzed.
Step 1: Data Sources/Input Overview Excel is commonly used by business areas to track important data. Very often this data is formatted in a way that makes sense to the user, but is not well suited for databases and analytics. Goal 1. Download sample data from Amazon S3 and use the Alteryx input tool to pull data from all worksheets with the name Company Overview. Lets use Alteryx to conform a sample dataset that contains local company and product data. 2. Use the dynamic input tool to pull product data from all remaining sources. The link below contains the data used in this exercise. There are 10 workbooks each with 5 worksheets. https://console.aws.amazon.com/s3/home?region=us-west- 2#&bucket=pmugfiles&prefix=
Step 2: Cleaning Data Overview We now how two sets of data. Company and product. Each set is poorly formed and not suitable for use by reporting tools. Goal 1. Using Alteryx to clean company overview information. Final table should contain 7 columns: Company name, Tax ID, Situs State, Street Address, Zip Code, and Industry. 2. Repeat the process for product information. This time dynamically rename your column headers. 3. Use a join tool to create a third consolidated dataset.
Step 3: Output Data Overview Now to make the data useful for reporting by end users. This is done by outputting the data to storage. Goal 1. Use any Alteryx output tool to store your work to separate data files.
