Intensive Data and Analytics Workshop June 11 th

Intensive Data and Analytics Workshop June 11 th, 2019 Ron Freeze, University of Arkansas

Access to Resources Faculty Registration n University of Arkansas Access n n n Request Access https: //request. informationsystems. uark. edu/login Register and get email for your logon credentials From AAA Workshop Drop. Box n Logon to HTTPS: //waltonlab. uark. edu 2

UARK Logon Procedure 1. 2. 3. 4. 5. Go to HTTPS: //waltonlab. uark. edu Select VMWare Horizon HTML access Enter username & password & GACL domain Open File Explorer and make sure you can see the S: drive, the AAA-June 2019 folder and the folder with your username Make sure there are two files in the AAAJune 2019 folder (an excel and text file) 3

Workshop Objective The objective of this workshop is to provide faculty participants with training and access opportunities to implement analytics projects in their classrooms. 4

Today’s Agenda n Introduction n n Overview of University of Arkansas resources University of Arkansas Tutorials n n SAS Enterprise Guide Tutorial SAS VIYA Tutorial 5

Timeline: 3: 10 pm – 4: 50 pm n n (15 min) Introduction to University of Arkansas (15 min) University of Arkansas Programs n n Undergraduate Program Graduate Program Interdisciplinary Program (25 min) SAS Enterprise Guide Tutorial == BREAK 4: 10 pm (~10 minutes) == n (25 min) SAS VIYA Tutorial n (10 min) Discussion & Wrap-up 6

Sam M. Walton College Enterprise Systems n Enterprise System – Information Systems Department n n Exercises, Use Cases, and Labs n n https: //walton. uark. edu/enterprise/datasets. php Request System Access n n https: //walton. uark. edu/enterprise/overview. php Datasets n n https: //walton. uark. edu/enterprise/exercises-usecases-labs/index. php Systems n n https: //walton. uark. edu/enterprise/ https: //request. information-systems. uark. edu/login Walton College Accounting Department n https: //accounting. uark. edu/ 7

8

Enterprise Systems Datasets n n Acxiom Demographics data (Personix) n 2013 US demographics data; 853 columns; 1. 3 million rows Dillard’s Department Stores n n Actual data (except cost); 6 tables (transaction 72 million rows); additional customer table which allow Geo Graphs Hallux Productions – artificial 3 NF relational database Sam’s Club n 6 ½ years Sam’s club data; 4 terabytes +; 25 billion + rows Nielsen n 2012 actual data with anonomous retailer; 3 regions of retail information – ACV, RM; categories and subcategories

Information Systems Programs Ø Ø Ø BSBA, Information Systems Degree – Undergraduate Concentrations • Business Analytics • Enterprise Information Systems • Enterprise Resource Planning BSBA -- Interdisciplinary Minors • Business Analytics • Enterprise Resource Planning Graduate Certificate Programs • Business Analytics • Enterprise Information Systems • Enterprise Resource Planning Master of Information Systems • Business Analytics • Enterprise Information Systems • Enterprise Resource Planning MS, Statistics and Analytics & MBA • Business Analytics Track

Information Systems Minors BUSINESS ANALYTICS ENTERPRISE RESOURCE PLANNING Interdisciplinary Minor ERP Minor (15 hrs) Business Analytics Minor (15 hrs) BSBA Walton College Majors: Ø Required Courses: • Accounting • Business Analytics & Visualization • Business Intelligence • Practicum - Applied Business Analytics Ø Elective Courses: • ERP Fundamentals (recommended) • Approved Upper Division Electives (3 hours) • Business Economics • Finance • General Business • Information Systems • Management • Marketing • Retail • Supply Chain • ERP Fundamentals • ERP Configuration & Implementation Ø Elective Courses: • Seminar in ERP Development (recommended) • Approved Upper Division Electives (6 hours)

Data Analytics for Accounting Richardson, Teeter, Terrell 1/e

Remote Desktop Access n VMware Access n n Save to your S: drive n n https: //waltonlab. uark. edu Enterprise Systems Network Drive (S: ) Files Needed for Hands On participation (S: AAA-June 2019) n n WCOB_Dillards. TUN-Export-KPIs. xlsx WCOB_Dillards. TUN-Export-KPIs. txt

Application Access n SAS Enterprise Guide n n n Select SAS Enterprise Guide Begin Tutorial SAS VIYA n n n Open a browser in VMWare https: //wcobviya. uark. edu Begin Tutorial

Thank you……