Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

New York City, NY

Welcome & Guidelines

Find tips to make the most of your User Group experience.

LEARN MORE

2/20 New York City Alteryx User Group Meeting

LaurenU
Alteryx Alumni (Retired)
‎01-25-2018 07:04 PM

2/20 NYC Alteryx User Group Meeting - RSVP TODAY!2/20 NYC Alteryx User Group Meeting - RSVP TODAY!

Join the New York City Alteryx User Group! Attend to start networking with peers, exchange ideas, and improve skill sets that will help maximize your potential with Alteryx.

 

Our hosts will need a guest list, please make sure to register! Thank you for your understanding!

DATE AND TIME

Tue, February 20, 2018

5:30 PM – 7:00 PM EST

Add to Calendar

LOCATION

KPMG - The Heritage Center

345 Park Avenue

New York, NY 10154

View Map

 

AGENDA

 

5:30pm-5:45pm: Welcome and Introductions

5:45pm-6:15pm: User Group Challenge - Let's review your results from the workflow shared before the meeting

6:15pm-6:45pm: Alteryx Academy and Certification - Review Community Responses. Have feedback? Share!

6:45pm-7:00pm: Closing - Updates on Alteryx Product and User Group Feedback

 

REGISTER TODAY

 

Reply
0 Likes
10 REPLIES 10
WSData_dup_359
7 - Meteor
‎04-28-2018 10:20 AM

For the macro bit, you could call Excel from a [Run Command] module.  Inside that Excel file you could have a macro that launches on an open event.  That macro could do its work and then save the results.

 

As far as the estimation of ingesting multiple Excel files and transforming the data into a single database.

 

  1. How you will access those sheets (do you need to build FTP calls (more complex) or will they be local (less complex)
  2. How many Excel files/Sheets would be a consideration
  3. Whether or not those files/sheets all share a common schema (layout)
  4. Is the data clean (or do you need to QC it on ingestion)
  5. Less important, but always good to know, size of the data in each sheet (across all sheets)
  6. Do you need to build a UI (analytic App) that let's users select directories, locations, file name(s)/type(s)?
  7. Do you need business logic to transform the data (aggregate, allocate, deaggregate, calculate new measures, etc.)

 

If your requirements call for a fixed directory with multiple Excel workbooks that share a common schema, the project will be much smaller than if you need to provide a UI that retrieves the files from a server and all of the files have different formats.

 

To estimate the project, break down the main components.

 

  1. Access of files
  2. Transforming into common data shape
  3. Data cleansing/hygiene
  4. Data transformation
  5. Persisting the data (database write)
  6. Etc.
Reply
Labels