Home / UTO Event Calendar / ASU Data Conference

ASU Data Conference 2020: Slaying the Data Monsters

November 16 - 20, 2020

Daily from 9:00 a.m. - 12:00 p.m.

Digital Immersive Conference

In the frequently murky and confusing forest that composes the ASU data landscape, lurks an army of frightful monsters. Traversing these woods, one may encounter dirty data beasts, quarrelsome queries, and vexatious visualizations. But fear not! For in this, the fourth annual ASU Data Conference, we invite you to join us for an impressive array of presentations, trainings, and other fabulous events that will help you level up your data skills, navigate challenges in finding and accessing ASU data, and create opportunities to meet fellow data adventurers. 

The theme of this year’s event is “Slaying the Data Monsters,” and will be virtually set in a medieval-era fantasy game where you and other practitioners from across the ASU data realm can pick characters (Data Citizens, Apprentices, Knights, and Wizards) and join forces in learning, up-skilling, and creatively problem-solving challenges across our data landscape.

Come prepared for a week of interactive, highly immersive activities. Join multiple sessions and earn badges for “slaying” data monsters, or just pop into the sessions that work for you. Now get ready to slay those data monsters, and don’t forget to bring your creativity and your 20-sided dice!

Data Conference Logo

Daily Agenda

Missed a session?

Don't worry we have you covered!  All sessions have been recorded and are available for you, just click the titles below to watch. Want more content? Subscribe to the ASU University Technology Office YouTube page for great content all year long. 

9:00 a.m. - 10:00 a.m. 
Welcome!
10:00 a.m. - 11:00 a.m.
Keynote: Tim Lant 
Fighting Pandemics with Data: Operationalizing Data to Inform the Scientific Response to COVID-19

Dr. Tim Lant will talk about efforts at ASU and around the state of Arizona to operationalize models and data during the COVID-19 response to inform the scientific response. He will highlight key phases of the response with examples of data analyses that informed decisions and outcomes. He will discuss underlying policy factors, how different this pandemic has been from others, and the need for continued scientific investigations to support public health by working closely together. He will also discuss the role of scientific preparedness in deploying rapid response capabilities in data sciences and a vision for what activities ASU should be contemplating how to prepare for future unexpected events.

11:00 a.m. - 12:00 p.m.
Breakout Reactions & Wrap Up

 

9:00 a.m. - 9:15 a.m
Your Daily Data Inspiration
 
9:30 a.m. - 10:20 a.m.   
Dinah the Data Masher of Discord
Behind the Viz - The rise of the Biodesign Critical Covid-19 Trends Dashboards

Combining Python Scripts, SSIS Packages, SQL and Tableau to make the Biodesign Critical Covid-19 Trends Dashboards. 

 

Dorumel the Documenter
The ASU Data Catalog in Collibra

 

How to use Collibra.  

Lindel, Guidon of Confusion
EP_STDNT_ENRL_SESS: Report ASU Online Students with Ease

 

 EdPlus generated an enriched version of PS_STDNT_ENRL called EP_STDNT_ENRL_SESS. This table allows quick reporting of online students by session (not term) and includes many convenience flags to make reporting on online students a breeze.

 

 
Byte Size Breakouts (10 mins each)
Lindel, Guidon of Confusion Dinah the Data Masher of Discord  Cra'ag the Code Confounder  Buzludzha, Architect of Chaos



Quick Overview of Zoom Data: A very brief summary of what is available from the data collected through Zoom sessions, and what you need to know about using it -- with an emphasis on Sync class students.

Intro to Alteryx Macros: A brief overview of how Alteryx macros work and what goes into building them.

Pivot Mining: A brief overview of the pivot mining algorithm and how to use the available macros to expedite the types of exploratory analyses conducted with pivot charts and tables.

SQL Development: "Best" Practices & Considerations: A brief list of concepts to help improve your SQL processing time, future maintenance, and collaborator interpretability.

Data Architecture - Operations vs. Analytics: A brief overview of considerations to make when capturing and structuring data, based on often-conflicting operational and analytical downstream use cases.

9:30 a.m. - 11:10 a.m.
Double Session
Dinah the Data Masher of Discord
Introduction to Alteryx

 

Presentation from the Alteryx vendor who will go over how to get started in Alteryx.
10:30 a.m. - 11:20 a.m.      
Vlad the Visualizer
Accelerated Degree Programs: Adapting Data and Technology to Leverage Graduate Opportunities

 

ASU offers many accelerated degree options designed to help students continue their education beyond the undergraduate level. These "4+1" programs offer students the opportunity to earn both a bachelor's and a master’s degree in as little as 5 five years. This presentation will explore the following:
  • Overview of Accelerated Degree (4+1) process
  • Introduction of 4+1 data and available reports
  • Recent and future additions to 4+1 tools
  • 4+1 Dashboard
Dorumel the Documenter
Map to Treasure - an EdPlus approach to documentation and standards

 

This presentation will discuss some of the methods and tools the EdPlus data analysis team currently uses to document our database tables. Content may also include report design standards. (Not really sure what audience level this belongs in. It might depend on the direction the content takes - i.e., overview versus DIY).
Lindel, Guidon of Confusion
Analytics 101

 

 This presentation will go over how to find things in the Analytics Portal as well as cover all of the different report types and how to use them to get the data you need when you need it. We will cover who builds reports, what options are out there and where to get started.
Vlad the Visualizer
SWIRL: Methods and Tools to Visualize and Analyze Student Retention and Major Migration Patterns
 
 At the 2019 conference, we presented the use of interactive Sankey diagrams to visualize student retention and movement between the first and second year of college (Swirl). The 2020 presentation will build on our previous work in this area, exploring alternative visualizations (e.g., mosaic, chord graphs) and analyses. Contextual information as to how these visualizations and analyses support decision-making around student services' successful practices in The College will also be discussed.

 

9:00 a.m. - 9:15 a.m.
 
Your Daily Data Inspiration
 
9:30 a.m. - 10:20 a.m.
 
 
Buzludzha, Architect of Chaos
 The Actionable Analytics Data Mart
 The who, what, where, when, why, and how of the project, with an emphasis on how it will benefit different types of audiences.
Lindel, Guidon of Confusion
 Student Profile Data
 This presentation will cover the most commonly requested student records data and explore concepts such as New/Returning/Continuing, major, campus, enrollment status, academic level, and GPA. Note that this is not about the Student Profile displayed in Salesforce.
Vlad the Visualizer
 iPOS: Graduate Progress Tracking Tool

 ASU’s interactive Plan of Student (iPOS) is a custom-built application for graduate students, support staff, advisors and faculty. The iPOS provides a suite of tools for tracking a graduate student's progress, courses and program milestones.

The presentation will explore the following:

  • iPOS Overview
  • Introduction of iPOS data and available reports
  • Recent additions to iPOS (staff advisor assignments, online defenses)
  • iPOS Progress Audit Tracker Dashboard
 9:30 a.m. - 11:10 a.m.
Double Session 
Aramil, Titan of Transformation
 Power Query 101
 This training will cover how to use the powerful but little known component of Excel called "Power Query". We will cover how to connect to enriched datasets easily and with little friction. This will be a hands on training format. Excel 2016 is recommended.
Aramil, Titan of Transformation
 Advanced Alteryx
 This will be a presentation by the vendor Alteryx who will go over more advanced topics.
 10:30 a.m. - 11:20 a.m. 
  
 
 Byte Size Breakouts (10 mins each)

Lindel, Guidon of Confusion  Vlad the Visualizer 

EP_TERM_SESSION & EP_TERM_VW: EdPlus generated EP_TERM_SESSION and EP_TERM_VW to quickly decode STRM or term_sess_code into easily discernible values. Additionally, this table and view incorporate many associated fields like term/session dates (start, tuition reimbursement deadline, census dates, and more), academic/calendar/fiscal year, short descriptions, long descriptions, and so much more.

What's New in EdPlus Dashboards: EdPlus has created a number of innovative Tableau Dashboards designed to view student onboarding funnels in various forms. The interesting features we’ll discuss will include the ability to view metrics based on an adjustable ‘top of the funnel’ metric, the ability to show year-over-year and year-to-date funnel information based on different time frames, and dynamic data definitions.

Maps and Legends: An Introduction to the Study Abroad Dashboard: This presentation will be an introduction to the new Study Abroad Office dashboard that allows users to identify and track ASU students through the pre-departure, onsite and post-program phases of their study abroad experience.

 
Buzludzha, Architect of Chaos
Zoom Data - the Good, the Bad, and the 500k records being added every day
 All the ins and outs of the data being captured through Zoom meetings, with a heavy emphasis on Sync classroom and student use.
 Vlad the Visualizer
Executive Retention Dashboard 
 Overview of the Executive Retention and Graduation Rates Dashboard. We will discuss the process around the need for the dashboard, the gathering of the data, dashboard design, development, and QA involvement. We will also discuss lessons learned and future steps in this ongoing project.

 

9:00 a.m. - 9:15 a.m
 
Your Daily Data Inspiration
 
9:30 a.m. - 10:20 a.m.   
  
Lindel, Guidon of Confusion
Data Analytics Success Hub Introduction - and My Reports Retirement
Introducing a central location for enriched enterprise datasets for building your own reports.
Vlad the Visualizer
Health Check Compliance
Curious about how the data behind the Health Check works and what the reporting looks like? Attend this presentation to hear about the myriad ways ASU uses your Health Check data to keep the campus safe and healthy.
9:30 a.m. - 11:10 a.m.
Double Session
 
 
Idea Hackathon: ASU Data Environment Improvement
The purpose of this session is to empower the ASU data community to drive and shape improvements in our data environment. The long session will begin with a short presentation summarizing the results of a survey of the ASU data community. The results of that survey will be used to identify the most commonly identified "data monsters." The majority of the double session will be spent in break-out groups working through solutions. A data-driven approach to taming data monsters!
Aramil, Titan of Transformation
DIY Data Empowerment
Have you ever had an event or a special project and wished you could have a mini-application built to help you manage things? Find out how to build your own mini-application using Google Forms and Alteryx. We will have demos and hands-on learning so you can really learn how to be fully empowered!
10:30 a.m. - 11:20 a.m.  
  
Aramil, Titan of Transformation
Deploying Machine Learning Models to Production with AWS Sagemaker
An overview of how AWS Sagemaker fits into the model development lifecycle, with examples of projects currently in production. The goal is to give the audience a basic understanding of what Sagemaker does (and what it doesn't).
 
Vlad the Visualizer
Success Coach Salesforce Case Triggers: How We’re Making Them More Efficient and Impactful
Part 1: Overview of the steps we are taking to deliver trigger cases to Success Coaches more quickly and with fewer problems.

Part 2: Overview of the analysis project we are embarking on to assess the impact (in terms of Success Coach workloads, as well as Success Student retention and academic achievement) of the current trigger types and how prioritization of triggers could improve outcomes.
 
Vlad the Visualizer
Utilizing the New College Retention Dashboard
This will highlight my college’s retention dashboard and include a member or members of the retention team to discuss how they utilize the dashboard.
 
Vlad the Visualizer
Human Resources - Analytics
How HR Analytics reports can be used to help ASU departments to be more strategic and predictive in using HR data on recruitment, hiring, compensation, retention, turnover, benefits, onboarding, and employee performance. We will show the current HR metric reporting and what the future holds. The knowledge that we will provide will assist departments to understand how they can use HR data to have an impact on decision making and performance.

*Click on the session titles below to join via Zoom. 

9:00 a.m. - 9:15 a.m.
 
Your Daily Data Inspiration
 
9:30 a.m. - 10:20 a.m.  
    
Vlad the Visualizer
Making year-to-year enrollment comparison analytics more digestible
Reports that track and compare current enrollment versus prior year walk a line between comprehensiveness and readability, and it can be difficult to find key take-aways in a report with hundreds of data points. This year, in the lead up to the fall semester, the College of Health Solutions created a new dashboard to supplement reporting from University Registrar Services and other sources with the intention of making enrollment comparisons easily digestible by college leadership.
Dinah the Data Masher of Discord
Data Reconciliation: Aligning ASU Online Census Enrollment Numbers
Walk-through of the steps our project team has taken to identify and document differences in the logic – both operational and source-driven – used to generate the census numbers reported by the Enrollment Analysis Unit and by EdPlus
Vlad the Visualizer
Survey Research Database Design and Interactive Results Presentation in Tableau ---- Illustrated by PhD Career Pathways Survey Dashboard
To sustainably maximize the effect of survey research findings, this session takes PhD Career Pathways survey as an example to illustrate 1) relational survey database design structure, ex. database normalization for flexibility; 2) visualization design of findings in dashboard, ex. effects of results presented in different ways, including quantitative and qualitative data; 3) survey design and analysis pitfalls; 4) doctoral student’s career aspirations and alumni’s professional landscapes.
 Cra'ag the Code Confounder
Winning the SQL Battle
ASU is under attack by VexSQL, a monster unleashing unruly and slow performing SQL. Fight VexSQL by writing pristine and robust SQL. The DW team calls on all SQL developers to join the crusade. Together we will train on best practices for SQL that is coherent, efficient, readable and performant. Level up on Oracle/Redshift differences to ward off VexSQL’s power as ASU prepares for the transition. The session is for contenders who grapple with SQL mano a mano, vs. a GUI tool.
 Cra'ag the Code Confounder
The surprisingly intuitive vocabulary of SQL
Structured Query Language, or SQL (often pronounced like “see-quill”), is an essential element of your professional data toolbox. While the way you analyze and present data will vary widely, SQL is often the only way to actually get that data. In this training, I’ll introduce you to a language that really is surprisingly intuitive and teach you what you need to know to become productive and self-sufficient.
10:30 a.m. - 11:20 a.m.
 
Closing
 

Vlad the Visualizer

Visualizations don't tell good stories

Dorumel the Documenter

Clear communication and promulgation

Lindel, Guidon of Confusion

Does not know where to find data

Dinah the Data Masher of Discord

Struggles to bring data together

Cra'ag the Code Confounder

-3 against well-tuned SQL queries

Buzludzha, Architect of Chaos

Buzludzha, Architect of Chaos

Cannot withstand order and organization

Aramil, Titan of Transformation

Terrified of successful workflows

Lindel, Guidon of Confusion - Data Finding Badge
Data Finding Badge
The Data Finding badge is given to those that know their limitations and therefore have upskilled to learn where to find reports, how to ask for new ones and where to go with questions.

Claim Now

Vlad the Visualizer- Data Visualization & Reporting Badge
Data Visualization & Reporting Badge
The Data Visualization & Reporting Badge is given to those that have spent time this week learning the ins and outs of data visualizations including best practices and how to ask the right questions.

Claim Now

Buzludzha, Architect of Chaos - Data Structure Badge
Data Structure Badge
The Data Structure badge is earned by those who have learned how to clean up data quickly and easily. By earning this badge they've shown that no data scares them no matter how messy it is.

Claim Now

Aramil, Titan of Transformation - Data Tools Badge
Data Tools Badge
The Data Tools badge is earned by those who have learned the best tools to use for their particular problem. Whether it's creating an awesome query or figuring out where to go, these folks know what to use when and they're not afraid to do so.

Claim Now

Cra_ag the Code Confounder- SQL Badge
SQL Badge
The SQL badge is earned by adventurers who have leveled-up their coding skills and learned some SQL - Structured Query Language. They now know how to write amazing SQL and are not afraid to use it.

Claim Now

Dinah the Data Masher of Discord- Data Wrangling Badge
Data Wrangling Badge
The Data Wrangling badge is earned by adventurers who are not afraid to take data from many different sources and wrangle it into something beautiful and useful for all to behold.

Claim Now

Dorumel the Documenter- Documentation Badge
Documentation Badge
The Documentation badge is earned by those who create excellent documentation or know how to find and use existing documentation. These adventurers can tell you how to do something and who to talk to about it.

Claim Now

Data Conference Badge- Data Hero!
Data Hero Badge
The Data Hero Badge is a rare honor and only bestowed upon the finest warriors. These adventurers not only have earned three other badges, but they know their persona and are ready to take on any future data monsters that might come their way.

Claim Now

Previous Events: 

2019    2018