Page 1 of 14
This content is protected and may not be shared, uploaded, or distributed.
ITP 487 – Enterprise Data Analytics
Units: 4
Section 32058R, Spring 2024, Noon–1:50PM MW
Section 32059R, Spring 2024, 2–3:50PM MW
Location: ZHS 352
Instructor: Mike Lee
Contact Info: mikelee@usc.edu
Office Hours: bit.ly/professorlee
Learning Assistants:
• NOON Section:
o Lead: Amy Jiang ([email protected])
o Section: Devon Chow
([email protected])
o Section: Jun Yang
([email protected])
• 2PM Section:
o Lead: Leilani Ventura
([email protected])
o Section: Caitlyn Hurray
([email protected])
o Section: Allen Mercado
([email protected])
See bit.ly/professorlee for latest info
IT Help:
USC IT (ITS): https://itservices.usc.edu/contact/
Viterbi IT: https://viterbi.usc.edu/resources/vit/contact-us.htm
Course Description
While the increased capacity and availability of data gathering and storage systems have allowed
enterprises to store more information than ever before, most organizations still lack the ability to
effectively consolidate, arrange, and analyze this vast amount of data. Digital transformation using data
analytics techniques has become a highly sought-after skill in business, engineering, services, science,
health, and other industries.
This course will explore the theory and practice of the following areas:
• Enterprise Organizational Structure and Decision Making
• Enterprise Data Warehouses
• Data Analytics used by Enterprises
• USC Applied Data Analytics Methodology (ADAM)
Learning Objectives
After completing the course, students will be able to
Page 2 of 14
This content is protected and may not be shared, uploaded, or distributed.
• Understand the organizational structure of enterprises (large organizations)
• Understand how enterprises make major technology decisions
• Define enterprise data analytics and its drivers
• Describe the components of an enterprise data warehouse
• Model the relational database required for an enterprise data warehouse
• Extract, cleanse, consolidated, and transform heterogeneous data into a single enterprise data
warehouse
• Explore any data set and apply a repeatable approach to data analytics to gain relevant insights
• Apply data analytics techniques that is in demand by enterprises
Prerequisite(s): ITP 320 or ITP 249
Remote Attendance
This course does not support remote attendance. Lectures will not be recorded or available on Zoom, there
are short in-person individual/group activities during many class meetings and exams are in-person.
Course Notes
All course materials will be made available through Blackboard. These include:
• Lecture slides
• In-class exercises
• Homework assignments
• Readings
• Software details and instructions for accessing Viterbi Virtual Lab
• Grades and feedback
• Office hours
• Online discussion forums will be used for out-of-class discussions
Announcements made in class and content posted in Blackboard will supersede the contents of this
syllabus.
USC Technology Support Links
Zoom information for students
Blackboard help for students
Software available to USC Campus
Technological Proficiency and Hardware/Software Required
The assignments for this class will include both reading assignments as well as hands-on computer
assignments. Students must bring their laptop computers (phones/tablets are not sufficient) to lecture
sessions to participate in hands-on activities. Students will be given tutorials to gain familiarity with
software tools.
Most of the enterprise software required for the class is Windows based or delivered via the cloud. The
software will be provisioned through the Viterbi Virtual Lab, Amazon Web Services, Google Cloud, and/or
installed your computer. Specifically, students will be using:
• SAP BW/4HANA (cloud)
• Eclipse for SAP BW Modeling (installed locally or Viterbi Virtual Lab)
• SAP Analysis for Microsoft Excel (installed locally or Viterbi Virtual Lab)
• Amazon Web Services/RDS (cloud)
• ChatGPT and other Generative AI tools (semester specific)
Page 3 of 14
This content is protected and may not be shared, uploaded, or distributed.
• Relational Database/SQL (cloud)
• Google Colab/Python/Pandas (cloud)
• Github (cloud)
• Python/Pandas
• SQL
• * Microsoft Power BI (optional – windows only)
• * Google Big Query/Shopify (optional)
* bonus exercises that students may use to add to resume skill sets
VITERBI VIRTUAL LAB – VMWARE VDI
Some software can also be accessed via Virtual Desktop by logging into the General Desktop at:
http://mydesktop.vlabs.usc.edu. If prompted enter http://mydesktop.vlabs.usc.edu as the VDI server. See
blackboard for additonal instructions on installing.
Alternatively, you can install the required software on your Windows machine (no support will be
provided). Instructions will be posted on Blackboard.
Readings and Supplementary Materials
Reading and supplementary materials will be announced in class and published on Blackboard.
Description and Assessment of Assignments
Homework: Most homework is computer based. Homework should be turned in to Blackboard. Grading will
be based on completeness, accuracy, and timeliness. Feedback will be provided through Blackboard. These
are individual effort assignments. One homework assignment will be dropped (lowest score) from your
grade calculation.
In-Class Exercises: are guided Q&A and hands-on exercises that are used to spark additional discussion and
deeper understanding of the materials and concepts before the student leaves the class. Announcement of
in-class exercises may or may not be given prior to the class. In-class exercises can be team or individual
exercises. The score used for grading is the percentage of in-class exercises completed and turned in in-
class. Two in-class exercises will be dropped (lowest scores) from your grade calculation.
Exams: Each exam will be comprised of 1) in-person and in-class multiple-choice part during class-time and
2) take-home project that you will have several days to complete. Details will be posted on Blackboard.
Grading Breakdown
Homework 30%
In-Class Exercises 10%
Midterm 25%
Quiz 10%
Final 25%
TOTAL 100%
Grading Scale
Course final grades will be determined using the following scale:
A 95-100
A- 90-94
B+ 87-89
B 83-86
Page 4 of 14
This content is protected and may not be shared, uploaded, or distributed.
B- 80-82
C+ 77-79
C 73-76
C- 70-72
D+ 67-69
D 63-66
D- 60-62
F 59 and below
Grading Timeline
Grading will typically be completed 7 days after submission. Any variations will be announced in class or on
Brightspace. Regrade requests must be submitted within a week of the grades being published unless
otherwise communicated in class.
Generative AI Policy
Use of Generative AI technologies, including ChatGPT, are encouraged and allowed unless explicitly stated
otherwise. YOU MUST CITE THAT YOU USED THE TECHNOLOGY AND INCLUDE ALL PROMPTS THAT YOU
HAVE USED.
Policies
Students are expected to attend and participate in lecture discussions, in-class exercises, and team
meetings.
Assignments turned in late will have 25% of the total points deducted from the graded score for each late
day.
No make-up exams (except for documented medical or family emergencies) will be offered. If they will not
be able to attend an exam due to an athletic game or other valid reason, then they must coordinate with
the instructor before the exam is given. They may arrange to take the exam before they leave, with an
approved university personnel during the time they are gone, or within the week the exam is given. If
students do not take an exam, then they will receive a 0 for the exam. Accommodations religious
observance must be arranged with the Professor at least two weeks before the exam.
If students need accommodations authorized by OSAS (Office of Student Accessibility Services), notify the
instructor at least two weeks before the exam. This will allow time for arrangements to be made.
Sharing of course materials outside of the learning environment
SCampus Section 11.12(B)
 
Distribution or use of notes or recordings based on university classes or lectures without the express
permission of the instructor for purposes other than individual or group study is a violation of the USC
Student Conduct Code. This includes, but is not limited to, providing materials for distribution by services
publishing class notes. This restriction on unauthorized use also applies to all information, which had
been distributed to students or in any way had been displayed for use in relationship to the class, whether
obtained in class, via email, on the Internet or via any other media. (See Section C.1 Class Notes Policy).
Page 5 of 14
This content is protected and may not be shared, uploaded, or distributed.
Course Schedule
Week
Date
See Blackboard for Due Dates
1
1/8
1/10
2
1/15
1/17
HW1: ER Diagram – you will
create a data dictionary and ER
diagram from narratives
TAKE HOME: Install MySQL
Workbench on Laptop
Page 6 of 14
This content is protected and may not be shared, uploaded, or distributed.
3
1/22
1/24
HW#2 - AWS/RDS – you will be
implementing the ER diagram
that you previously designed in
LucidChart in the lab the you
previously built int AWS/RDS.
You will also load and query the
data using SQL.
4
1/29
1/31
HW#3 – Generative AI/ChatGPT –
you will leverage generative AI
tools to launch a new product
Page 7 of 14
This content is protected and may not be shared, uploaded, or distributed.
5
2/5
2/7
6
2/12
HW#4 – Star Schema Warehouse
– you will load transactional DDL
files, design star schema, load
the star schema from tables from
the transactional tables using
staging tables.
2/14
2/19
Page 8 of 14
This content is protected and may not be shared, uploaded, or distributed.
7
2/21
Assigned Video Lecture
8
2/26
2/28
9
3/4
HW#5 - InfoObjects
3/6
10
3/11
3/13
Page 9 of 14
This content is protected and may not be shared, uploaded, or distributed.
11
3/18
HW#6 – InfoProviders
3/20
HW#7 - Queries
12
3/25
HW#8- Analysis for Excel
Page 10 of 14
This content is protected and may not be shared, uploaded, or distributed.
3/27
13
4/1
4/3
14
4/8
HW#9 – Pandas for Analytics
4/10
Page 11 of 14
This content is protected and may not be shared, uploaded, or distributed.
15
4/15
HW#10 – Data Visualization
4/17
HW#11 – Analysis Techniques
16
4/22
4/24
Finals
Exam
* Data sets change each semester. Data set listed is the possible data set that will be used.
Page 12 of 14
This content is protected and may not be shared, uploaded, or distributed.
Statement on Academic Conduct and Support Systems
Academic Integrity:
The University of Southern California is a learning community committed to developing successful scholars
and researchers dedicated to the pursuit of knowledge and the dissemination of ideas. Academic
misconduct, which includes any act of dishonesty in the production or submission of academic work,
comprises the integrity of the person who commits the act and can impugn the perceived integrity of the
entire university community. It stands in opposition to the university’s mission to research, educate, and
contribute productively to our community and the world.
 
All students are expected to submit assignments that represent their own original work, and that have been
prepared specifically for the course or section for which they have been submitted. You may not submit
work written by others or “recycle” work prepared for other courses without obtaining written permission
from the instructor(s).
 
Other violations of academic integrity include, but are not limited to, cheating, plagiarism, fabrication (e.g.,
falsifying data), collusion, knowingly assisting others in acts of academic dishonesty, and any act that gains
or is intended to gain an unfair academic advantage.
 
The impact of academic dishonesty is far-reaching and is considered a serious offense against the
university. All incidences of academic misconduct will be reported to the Office of Academic Integrity and
could result in outcomes such as failure on the assignment, failure in the course, suspension, or even
expulsion from the university.
 
For more information about academic integrity see the student handbook or the Office of Academic
Integrity’s website, and university policies on Research and Scholarship Misconduct.
 
Please ask your instructor if you are unsure what constitutes unauthorized assistance on an exam or
assignment, or what information requires citation and/or attribution.
Course Content Distribution and Synchronous Session Recordings Policies
USC has policies that prohibit recording and distribution of any synchronous and asynchronous course
content outside of the learning environment.
Recording a university class without the express permission of the instructor and announcement to the
class, or unless conducted pursuant to an Office of Student Accessibility Services (OSAS) accommodation.
Recording can inhibit free discussion in the future, and thus infringe on the academic freedom of other
students as well as the instructor. (Living our Unifying Values: The USC Student Handbook, page 13).
Distribution or use of notes, recordings, exams, or other intellectual property, based on university classes or
lectures without the express permission of the instructor for purposes other than individual or group study.
This includes but is not limited to providing materials for distribution by services publishing course
materials. This restriction on unauthorized use also applies to all information, which had been distributed to
students or in any way had been displayed for use in relationship to the class, whether obtained in class, via
email, on the internet, or via any other media. (Living our Unifying Values: The USC Student Handbook, page
13).
Students and Disability Accommodations:
USC welcomes students with disabilities into all of the University’s educational programs. The Office of
Student Accessibility Services (OSAS) is responsible for the determination of appropriate accommodations
for students who encounter disability-related barriers. Once a student has completed the OSAS process
(registration, initial appointment, and submitted documentation) and accommodations are determined to
Page 13 of 14
This content is protected and may not be shared, uploaded, or distributed.
be reasonable and appropriate, a Letter of Accommodation (LOA) will be available to generate for each
course. The LOA must be given to each course instructor by the student and followed up with a discussion.
This should be done as early in the semester as possible as accommodations are not retroactive. More
information can be found at osas.usc.edu. You may contact OSAS at (213) 740-0776 or via email at
osasfrontd[email protected].
Support Systems:
Counseling and Mental Health - (213) 740-9355 – 24/7 on call
Free and confidential mental health treatment for students, including short-term psychotherapy, group
counseling, stress fitness workshops, and crisis intervention.
988 Suicide and Crisis Lifeline - 988 for both calls and text messages – 24/7 on call
The 988 Suicide and Crisis Lifeline (formerly known as the National Suicide Prevention Lifeline) provides free
and confidential emotional support to people in suicidal crisis or emotional distress 24 hours a day, 7 days a
week, across the United States. The Lifeline is comprised of a national network of over 200 local crisis
centers, combining custom local care and resources with national standards and best practices. The new,
shorter phone number makes it easier for people to remember and access mental health crisis services
(though the previous 1 (800) 273-8255 number will continue to function indefinitely) and represents a
continued commitment to those in crisis.
Relationship and Sexual Violence Prevention Services (RSVP) - (213) 740-9355(WELL) – 24/7 on call
Free and confidential therapy services, workshops, and training for situations related to gender- and power-
based harm (including sexual assault, intimate partner violence, and stalking).
Office for Equity, Equal Opportunity, and Title IX (EEO-TIX) - (213) 740-5086
Information about how to get help or help someone affected by harassment or discrimination, rights of
protected classes, reporting options, and additional resources for students, faculty, staff, visitors, and
applicants.
Reporting Incidents of Bias or Harassment - (213) 740-5086 or (213) 821-8298
Avenue to report incidents of bias, hate crimes, and microaggressions to the Office for Equity, Equal
Opportunity, and Title for appropriate investigation, supportive measures, and response.
The Office of Student Accessibility Services (OSAS) - (213) 740-0776
OSAS ensures equal access for students with disabilities through providing academic accommodations and
auxiliary aids in accordance with federal laws and university policy.
USC Campus Support and Intervention - (213) 740-0411
Assists students and families in resolving complex personal, financial, and academic issues adversely
affecting their success as a student.
Diversity, Equity and Inclusion - (213) 740-2101
Information on events, programs and training, the Provost’s Diversity and Inclusion Council, Diversity
Liaisons for each academic school, chronology, participation, and various resources for students.
USC Emergency - UPC: (213) 740-4321, HSC: (323) 442-1000 – 24/7 on call
Emergency assistance and avenue to report a crime. Latest updates regarding safety, including ways in
which instruction will be continued if an officially declared emergency makes travel to campus infeasible.
USC Department of Public Safety - UPC: (213) 740-6000, HSC: (323) 442-1200 – 24/7 on call
Non-emergency assistance or information.
Page 14 of 14
This content is protected and may not be shared, uploaded, or distributed.
Office of the Ombuds - (213) 821-9556 (UPC) / (323-442-0382 (HSC)
A safe and confidential place to share your USC-related issues with a University Ombuds who will work with
you to explore options or paths to manage your concern.
Occupational Therapy Faculty Practice - (323) 442-2850 or [email protected]c.edu
Confidential Lifestyle Redesign services for USC students to support health promoting habits and routines
that enhance quality of life and academic performance.