Leadership Team and Agenda Highlights
In this content, you will find information about the leadership team of various companies along with an agenda for a business event. The team comprises professionals specializing in business intelligence, data analysis, and more. The agenda includes topics like user stories, Alteryx server deployment, data challenges, and networking opportunities. Get insights into best practices for deploying servers and indicators for scaling with Alteryx Server.
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
Q3 Q3
Get To Know Your Leadership Team Robert Farley AE Business Solutions AE Business Solutions Business Intelligence & Analytics Solutions Architect Jared Grant Manpower Manpower Data Analyst Colleen Hayes Rexnord Rexnord Business Data Analyst John Heisler Continuus Technologies Continuus Technologies Vice President, Business Intelligence & Data Science Matt Michaelson Continuus Technologies Continuus Technologies Troy Vant Hull Zurn Zurn Director, Business Intelligence 2
Agenda 1:00 - 1:30: Welcome, swag giveaway, Welcome, swag giveaway, introductions, housekeeping items introductions, housekeeping items 1:30 - 2:15: User Story User Story, Jason Melik, Baird 2:15 2:30: Break Break 2:30 - 3:15: Alteryx Server at TDS Alteryx Server at TDS, Mya Starling, TDS 3:15 - 3:30: Break Break 3:30 - 4:00: Deploying Alteryx Server Deploying Alteryx Server, AE Business Solutions 4:00 - 4:30: Q4 Data Challenge Q4 Data Challenge, MAUG Leadership Team 3:30 - 4:30: Alteryx Doctor Office Hours Alteryx Doctor Office Hours 4:30 - 7:00: Happy Hour(s) Happy Hour(s) Stella Van Buren 3
Best practices for deploying and managing Server Content supplied from an Alteryx Inspire presentation titled Analytic Tipping Point: When and How to Scale Out Alteryx Server by Kory Cunningham, Senior Product Manager, Alteryx
Indicators you are ready to scale with Server Producing recurring reports or analysis Periodic data loading or ingesting Off-peak or overnight processing Requests for the same or almost the same workflow or analysis Need for collaboration on analytics projects Need for Self-Service analytics 8
Gather user requirements Upfront Who are your users? What departments and which users will need access? Who are the builders and who are the consumers of analytics? What kind of workflows do you have? Are they memory/disk/CPU intensive? Can they be optimized? What data sources are necessary and can they be accessed through firewalls? 9
Identify system and user Admins Assign ownership of managing the server and managing users Server Managers IT-centric System maintenance and upgrades Troubleshooting and allocating resources User managers: Alteryx-centric Departmental and user management Gallery usage and administration 10
Optimize your workflows and data Access Best Practices for workflow efficiency Maintain only the necessary data in workflow streams Understand and minimize expensive operations, like Sort and Unique Utilize the workflow performance profiling option Ensure data are as close to your server as possible When possible, store the data directly on the server Network latency is often the biggest bottleneck Where possible, utilize In-Database tools 11
Monitor Usage Utilize the Gallery Usage Report Tools Understand how your server is being used and performing Are workflows being queued up? Are there any workflows that are particularly costly? Are there users with abnormally high usage? Check the Server Logs 12
Stay up-to-date and Informed Keep systems up-to-date on the latest versions not just Alteryx Download the latest installers, release notes, and documentation Beta programs, trainings, demos, customer webinars Alteryx Community and tech support 13
First Annual Milwaukee Alteryx Users Data Challenge Data Challenge
The Problem A Jolly anonymous benefactor wants to send some holiday parcels to Milwaukee homes purchased since 2002. You are going to make some of the deliveries using a magic flying vehicle. The catch is that the vehicle can only fly 200 miles total as the crow flies. You will need to prioritize your delivery in what ever fashion you choose, there are no wrong answers are no wrong answers and the User Group will vote on which solution is the winner. 15
The Data Much of this data is fictitious or randomized in some way, please do not use for any purpose Much of this data is fictitious or randomized in some way, please do not use for any purpose other than the data challenge!! other than the data challenge!! We started with the City of Milwaukee Assessor s Office Property Sales Data Master File. https://data.milwaukee.gov/dataset/property-sales-data We picked the most popular 1000 first names from the census and the most frequent 500 last names. We created all combinations of first, middle, and last names then randomly picked them to get fake names for each residence. We geolocated all properties and give you a lat-long and spatial object. Census data on HH Income, HH Size, Poverty, and Presence of Children in the area are included. Treat these as though they belonged to the actual address. Fake data on presence of a dog, chimney, and number of parcels to be delivered are included. 16
The Rules 1) You must be a member of the Milwaukee Alteryx User Group (MAUG) to win 2) Winners will be chosen based on votes from the MAUG community (method of vote will be announced once all submissions are received). 3) Winners will be announced at the MAUG Q4 Meeting / Holiday Party MAUG Q4 Meeting / Holiday Party 4) You may augment the dataset in any way you like. 5) Alteryx swag, other awards, and bragging rights for a year go to the winners!! 17
The Challenge 1) There are some odd values in the data set, address data issues and resolve them 2) Determine a method of prioritizing your deliveries (there are no wrong answers your sequence. there are no wrong answers) this will be 3) You may choose any location in the file as your starting point. 4) You must build a sequence poly-line (spatial>poly-build) with a distance of less than 200 miles as the crow flies (spatial>spatial info). 5) Post your workflow and a short presentation or explanation to the Milwaukee Alteryx User Group Community Page https://community.alteryx.com/t5/Milwaukee-WI/gp-p/milwaukee-wi (we will start a single thread for submissions be on the lookout we will start a single thread for submissions be on the lookout). We would like to have at least some submissions do a quick presentation at the Q4 meeting! A resource you may wish to consider is a post titled Santa s First Iterative Macro community. https://community.alteryx.com/t5/Videos/Santa-s-First-Iterative-Macro/td-p/92237 No distance component in the example, but it would be great to see enhancements!! Submissions need not be this complex or utilize macros all levels of complexity are appreciated! Santa s First Iterative Macro on the 18
