August 14 th 2019 Ron Freeze University of Arkansas Rhonda Syler University of Arkansas Lakshmi Iyer Appalachian State University Liz Moran SAS Academic Programs James Harroun SAS Academic Programs ID: 816128
Download The PPT/PDF document "SIGDSA Workshop: Analytics and Visualiz..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
SIGDSA Workshop: Analytics and Visualization with SAS
August 14th, 2019Ron Freeze, University of ArkansasRhonda Syler, University of ArkansasLakshmi Iyer, Appalachian State UniversityLiz Moran, SAS Academic ProgramsJames Harroun, SAS Academic Programs
Slide2Access to ResourcesFaculty RegistrationUniversity of Arkansas AccessRequest Access https://request.information-systems.uark.edu/login Register and get email for your logon credentialsLogon to
https://waltonlab.uark.eduVMWare virtual desktopOpen Chrome – https://wcobviya.uark.edu 2
Slide3UARK Logon ProcedureGo to https://waltonlab.uark.eduSelect VMWare Horizon HTML accessEnter username & password & GACL domain
Open File Explorer and make sure you can see the S: drive, the AMCIS2019 folder and the folder with your usernameMake sure there are two files in the AMCIS2019 folder (an excel and text file)3
Slide4SIGDSA Workshop Objective
Provide participants a forum to learn and discuss curricula strategies, learn about resources and provide exercises on data analytics and big data curricula. Insights into the
program development from both a Business College and University level are provided.
In addition, the workshop will include
classroom
instruction
methods
. These methods have been used and incorporated at both Appalachian State and University of Arkansas. All
materials
and resources are available to the participants of the workshop.
4
Slide5Analytics Team ContactRon Freeze, University of Arkansas rfreeze@Walton.uark.eduRhonda Syler, University of Arkansas
rsyler@Walton.uark.edu Lakshmi Iyer, Appalachian State University iyerLs@appstate.edu James Harroun, SAS Academic Programs James.Harroun@sas.com
Liz Moran, SAS Academic Programs Liz.Moran@sas.com
Slide6Introduction Overview of University of Arkansas resourcesUniversity of Arkansas – Enterprise SystemsAppalachian State University – Analytics CurriculumSAS Academic ProgramsUniversity of Arkansas TutorialsDillard’s Dataset using SAS VIYA
SAS Tutorial – Dillard’s DatasetCourse Discussion & Wrap-up
6
Today’s Agenda
Slide7Timeline: 7:30 am – 11:30 am
7:30 am (30 min) Coffee, Pastries and Network Building8:00 am (10 min) Introduction of Workshop Coordinators8:10 am (15 min)
University of Arkansas Resources & Curriculum8:25 am
(15 min)
Appalachian State University – Analytics Curriculum
8:40 am
(20 min)
SAS Academic Programs
9:00 am
(60 min) University of Arkansas Tutorial – SAS VIYA
10:00 am
== BREAK ==
10:15 am (60 min)
SAS Tutorial
– SAS VIYA
11:15 am
(15 min) Course Discussion & Wrap-up11:30 am Conclusion of workshop
7
Slide8Sam M. Walton College Enterprise Systems
Enterprise System – Information Systems Departmenthttps://walton.uark.edu/enterprise/ Exercises, Use Cases, and Labshttps://walton.uark.edu/enterprise/exercises-usecases-labs/index.php Systemshttps://walton.uark.edu/enterprise/overview.php
Datasetshttps://walton.uark.edu/enterprise/datasets.php
Request System Access
https://request.information-systems.uark.edu/login
Walton College Accounting Department
https://accounting.uark.edu/
8
Slide99
Slide10Enterprise Systems DatasetsAcxiom Demographics data (Personix)2013 US demographics data; 853 columns; 1.3 million rows
Dillard’s Department Stores Actual data (except cost); 6 tables (transaction 72 million rows); additional customer table which allow Geo GraphsHallux Productions – artificial 3NF relational databaseSam’s Club6 ½ years Sam’s club data; 4 terabytes +; 25 billion + rowsNielsen
2012 actual data with anonomous retailer; 3 regions of retail information – ACV, RM; categories and subcategories
Slide11BSBA, 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 Programs
Slide12Information Systems Minors
BUSINESS ANALYTICS
Interdisciplinary Minor
ENTERPRISE
RESOURCE PLANNING
Interdisciplinary Minor
Business Analytics & Visualization
Business Intelligence
Practicum - Applied Business Analytics
ERP Fundamentals (recommended)
Approved Upper Division Electives (3 hours)
Required Courses:
Elective Courses:
ERP Fundamentals
ERP Configuration & Implementation
Seminar in ERP Development (recommended)
Approved Upper Division Electives (6 hours)
Required Courses:
Elective Courses:
Accounting
Business Economics
Finance
General Business
Information Systems
Management
Marketing
Retail
Supply Chain
BSBA Walton
College Majors:
Business Analytics Minor (15
hrs
)
ERP Minor (15
hrs
)
Slide13Analytics Programs
Master of Science in Applied Data Analytics (36 hours)
msanalytics.appstate.edu
1 year Full- time with the option to complete part time during the day
36 credit hours:
27 core hours; 9 hours of electives.
Five concentrations:
Supply Chain, Sustainability, Marketing, Healthcare, and Interdisciplinary Analytics
Business Analytics Graduate Certificate (15 hours)
Professional non-degree Certificate
being developed by Dr. Joseph
Cazier
, director of
Center for Analytics Research and Education(CARE)
program targets data savvy managers that can bridge business and analytics
Core Courses (27 hours)
Problem Analysis and Quantitative
Methods
Data Programming
Data Management
Project Management and Visualization
Web Analytics, Data Privacy, and Security
Forecasting and Time Series Models
Applied Econometrics
Applied Analytics Project (6)
OR
Thesis (6)
Operations and Supply Chain Management (Required)
Strategic Sourcing and Logistics Management
Six Sigma, Lean and Quality Management
Analytical Models for Supply Chain Management
International Experience with Supply Chain focus
Supply Chain Concentration:
Marketing Strategy and Applications
Marketing Analytics
International Marketing
International Experience with Marketing focus
Marketing
Data Mining & Knowledge Discovery in Scientific Data
Introduction to Operations Research
Biostatistics (4)
Advanced GIS
Six Sigma, Lean and Quality Management
Analytical Models for Supply Chain Management
International Experience with Analytics focus
Interdisciplinary
Sustainable Business for a Global Economy (Required)
Sustainability Performance Assessment
Biostatistics
Benefit-Cost Analysis
Environmental Economics and Policy
Advanced GIS
International Experience with Sustainability focus
Sustainability
Healthcare
Foundations of the US Healthcare System (Required)
Healthcare Informatics (Electronic health records, coding, legislation and reform,
etc
)
Healthcare Analytics
Performance Improvement Concepts and Applications in Healthcare
36 credit hours:
27 core hours + 9 hours of electives
Post-Bacc Business Analytics Certificate Program
Total hours: 15
Core Courses (9 hours)
Problem Analysis and Quantitative Methods
Fundamentals of Business Analytics
Data Management
Electives – 6 hours (from the following or others approved by program director
Web Analytics, Data Privacy, and Security
MBA 5870 - Analytical Models for Supply Chain Management
ECO 5740 - Forecasting and Time Series Models
Applied Analytics Project
Slide16FormatOnline Non-Credit One Year Analytics Certificate 5 Classes each 9 weeks (with 1 week break in between)
Rolling admissionYear RoundCan start at any 10 week breakJointly offered with SAS on the
Viya Platform
Each week will deliver content Monday through Thursday for ~45 minutes
~15 Minutes of a video lecture focusing on the theory and goal
~25 Minutes of exercises to apply what they learned
~10 Minutes show and tell directed exercise with lab video and follow along
~15 On your own challenge assignment with clear goals, but less direction
~5 Minutes review of key concepts including sharing solution to challenge assignment (video)
A project will open on Friday to complete over the weekend. The purpose of the project is to tie all the learning from the week together by doing some applied work on realistic data. The goal is for them to spend 2-3 hours of focused time on the project.
Target
Tech Savvy Business Leaders with an interest in analytics
From companies located through the US
Need to commit 8 to 10 hours a week for 1 year
Pilot conducted in 2019 Spring
Partnered with University of Arkansas
16
Professional non-degree Certificate Program Format and Target
Slide17SAS Academic ProgramsSupport for Teaching and Learning
Slide18At SAS, we’re passionate about empowering communities through education.We’re an analytics company, but we make much more than software. We believe in the difference that begins with innovative, creative minds using what they know to change the world. Our commitment to education is sharing the power of knowledge with people at every level of education – professors, students, researchers and independent learners. The
SAS Academic Program supports industry partnerships with academia, delivers technology and resources for teaching and learning, and provides products and services at no cost to schools.Our Mission:
Slide1911%
of business leaders strongly agree that graduating students have the skills their businesses need
95%
of Chief Academic Officers rate their institution as very/somewhat effective at preparing students for work
“A New Vision for American Education: A Merger of Work and School.” Brandon Busteed, Gallup, Education Commission of the States, Washington, DC, 2018
Slide20Convergence
UAR
Network
Industry
Data
Academic
Collaboration
Viya
Software
Slide21Support for Educators and Learners
Academic Programs
Joint Programs
Academic Badging
Software
University Edition
SAS OnDemand for Academics
Viya
for Learners
Education Resources
Teaching Materials
e-Learning
Tutorials
e-Textbooks
Academic Workshops/SAS Days
Curriculum Consulting
Guest Speakers
Copyright © SAS Institute Inc. All rights reserved.
Academic Programs Reach
Degrees, Joint Certificate Programs, Events
19K+
Certifications Awarded
16K+
Educators and Learners in Workshops
300+
Joint Programs
70+
SAS Days
Outreach
178k+
Educators and Learners Actively Using SAS University Edition
70K+
Educators and Learners Using SAS OnDemand for Academics
56
Countries Supported by SAS Global Academic Program
Slide23Parallel & Serial, Pub / Sub,
Web Services, MQs
Source-based
Engines
Microservices
UAA
Query
Gen
Folders
CAS Mgmt
Data Source Mgmt
Analytics
GUIs
etc…
BI
GUIs
Env
Mgr
Model
Mgmt
Log
Audit
UAA
UAA
Data Mgmt GUIs
In-Memory Runtime Engine
In-Database
In-Hadoop
In-Stream
Solutions
APIs
Platform
Analytics
Data Management
Fraud and Security Intelligence
Business Visualization
Risk Management
!
Customer Intelligence
Cloud Analytics Services (CAS)
Data Enablement
IT Enablement
Developer Enablement
Solutions Enablement
Cloud Enablement
Slide24Visual Interfaces
Programming Interfaces
API Interfaces
MULTIPLE INTERFACES, SINGLE CODE BASE
Slide25Virtual Desktop AccessVMware Access
https://waltonlab.uark.edu Save to your S: driveEnterprise Systems Network Drive (S:)Files Needed for Hands On participation (S:AMCIS2019)WCOB_DillardsTUN-Export-KPIs.xlsxWCOB_DillardsTUN-Export-KPIs.txt
Slide26UsernamesPassword – GohogsUA1
UserName
Name
Email
UserName
Name
Email
AMCIS50
AMCIS66
AMCIS51
AMCIS67
AMCIS52
AMCIS68
AMCIS53
AMCIS69
AMCIS54
AMCIS70
AMCIS55
AMCIS71
AMCIS56
AMCIS72
AMCIS57
AMCIS73
AMCIS58
AMCIS74
AMCIS59
AMCIS75
AMCIS60
AMCIS76
AMCIS61
AMCIS77
AMCIS62
AMCIS78
AMCIS63
AMCIS79
AMCIS64
AMCIS80
AMCIS65
AMCIS81
Slide27Application AccessSAS VIYAOpen a browser in VMWarehttps://wcobviya.uark.edu Begin TutorialDillard’s Sales
Top 10 Zip Codes for 2015Geographic View by StateMidwest Area View by Zip Code
Slide28Thank you……