Welcome to our 4-part Back-to-School Fall Series with Alteryx!
As a participant in this series, we will walk you through setting up pieces of our back end (fictitious) school system with Alteryx! Along the way you will learn how to apply the automation and analytics system to your role, while having a little fun in the process.
Week 0: Orientation for Back-to-School with Alteryx! September 6th, 2022
In this 30-minute preliminary session we will connect to the platform that will be used over the course of the next month and ensure you are able to log in and access all resources. This is scheduled for a 30-minute session but may take as few as 10 minutes to get you online.
Registration: https://alteryx.webex.com/alteryx/onstage/g.php?MTID=e39b35e263081c202f49c2aea0c815e91
Week 1: Student Registration September 13th, 2022
Oh no! Our website went through a migration during the registration period. As a result, we have students whose registrations ended up on our database, others whose registrations logged to Google Sheets, and a third set of campers whose information was collected onsite and is in Excel. During this 90-minute session we’ll get all of the data blended and clean up anything that still looks a little messy. The data we collect and blend in this session will be used in follow-on sessions to create Iterative Macros (Week 2) and Predictive Models (Week 3)!
How does this relate to your job in the real world? You will learn the following skills:
- Data Blending from a variety of sources for future analysis
- Clickable and repeatable data cleansing
- Annotation and how to cleanly document all data manipulation for auditing purposes
Common applicable use cases
- Finance reconciliation
- Audit automation and documentation
- Automation and scheduling of email notifications for late utility payments
- Scheduled data cleansing and loads into a warehouse or database
- Pushing automated updates to dashboards or other sources routinely
Registration Link: https://alteryx.webex.com/alteryx/onstage/g.php?MTID=ee0cf4b0b41e2fdb1b15463471a8dfd4a
Week 2: Classroom Assignments September 20th, 2022
Assigning students to the right teacher and classroom can be challenging! A multitude of factors has to be taken into account when pairing students with teachers like age, grade, special needs and learning styles. To ensure that our students are highly successful this year we will build an iterative macro that assigns students to classrooms while considering the data that we collected and blended in Week 1. This fast and automatable way of assigning students to classrooms gives students and families time to prepare for their up-coming school year.
How does this relate to your job in the real world? You will learn the following skills:
- How to iterate or loop through data making assignments in an automated way.
- How to combine the work of different analytical projects into a single report in an additive manner.
Common applicable use cases
- Shipping optimization
- Using iterative processes for scheduling and assigning case workers to cases or vice versa (i.e. assigning help desk tickets to servicers)
- Overtime assignments based on calculated rules
- Inspection scheduling based on risk vs timed schedule
Registration Link: https://alteryx.webex.com/alteryx/onstage/g.php?MTID=e2bc0bebdfe05d2b5c3ca9f288becfe3a
Week 3: Preparing in advance for Tutoring Sessions September 27th, 2022
School can be fun, but also a little stressful for some kids. No worries! As part of our back-to-school initiative we will use predictive analytics to prepare for students who may need some extra tutoring throughout the year. In this session we will build a model to determine which students should be assigned to an extra 30-mins of individual tutoring each week.
How does this relate to your job in the real world? You will learn the following skills:
- How to use predictive analytics to build models.
- How to use your data to gain greater insights and get ahead of potential problems.
Common applicable use cases
- Use predictive analytics to plan for equipment maintenance and inevitable equipment failures
- Predict employee attrition rates
- Predicting the likelihood of student enrollment and student churn
- Prediction of employee injury
Registration Link: https://alteryx.webex.com/alteryx/onstage/g.php?MTID=ec62b60538b9e518f9e634c183355dd15
Week 4: It’s Report Card time! October 4th, 2022
Yes, the dreaded report card! Luckily, Alteryx makes creating and scheduling reports easy and fun. We can also automate the process of sending Report Cards via email to parents. This week will delve into the possibilities of reporting in Alteryx along with a demonstration of how to post workflows on the Server Gallery and schedule them. Additionally, easy-to-use interface tools allow teachers to update student reports on the fly. Now we are ready for school to start!
How does this relate to your job in the real world? You will learn the following skills:
- How to create and add permissions to a central repository for your analytic outputs.
- How to create a multi-media report.
Common applicable use cases
- Utilize a server environment for secure sharing of data and outputs at worker and enterprise levels
- Creating a repository for end users to gain access to ad-hoc queries or parameterized outputs
Registration Link: https://alteryx.webex.com/alteryx/onstage/g.php?MTID=e0358a3e710d2c1a1068792976a51a908
Register for the Orientation and all 4 weeks of our Back-to-School series! All data and system access will be provided prior to the orientation kickoff. (Registration is limited to 50 participants so don’t wait!)
