BUSI 12: INTRODUCTION TO DATA ANALYTICS & BUSINESS DECISIONS
Foothill College Course Outline of Record
Heading | Value |
---|---|
Units: | 4 |
Hours: | 4 lecture per week (48 total per quarter) |
Degree & Credit Status: | Degree-Applicable Credit Course |
Foothill GE: | Non-GE |
Transferable: | CSU/UC |
Grade Type: | Letter Grade Only |
Repeatability: | Not Repeatable |
Student Learning Outcomes
- Students will perform basic data analytics tasks (e.g. data collection, manipulation, preparation, visualization, and decision) as they relate to the professional data analytics work environment
- Students will demonstrate appropriate use of basic data analytics terms and concepts
Description
Course Objectives
The student will be able to:
A. Describe data analytics/science and its applicability to business decision making
B. Apply basic data analytics methods to business decision making
C. Describe and perform basic data collection, manipulation, and preparation techniques using standard data analytics software
D. Describe standard data analytics techniques used to identify insights, including data visualization, data storytelling, exploratory data analysis
E. Present analysis insights based on standard data analytic practices
Course Content
A. Introduction to Data and Business Analytics
1. Data, big data, information
2. Definition of data analytics, data science
3. Uses of data and data analytics in business
4. Survey of popular data analytics tools
5. Comparative descriptions of job roles that work with data and analytics
B. Business Framing in Analytics
1. Data requirements, data sourcing, data collection
2. Business types and their interest in analytics
3. Business data analytics stakeholder analysis
4. Business data analytics stakeholder matrix
5. Business objective definition
6. Business objective to data solution mapping
7. Methods to communicate data analytic findings in business vs. non-business context
C. Data Preparation
1. Data analytic tool fundamentals
a. Tool structure and functionality
b. Integration to external data source
c. Static data vs. dynamic data
d. Absolute vs. relative references
e. Data paste, imputation, and filtering
f. Data cleaning best practices
g. Data cleaning and Null values
h. Merging and joining multiple datasets
D. Introduction to Data Visualization and Data Storytelling
1. Chart creation
a. Column chart
b. Line chart
c. Scatter chart
d. Combination chart
e. Sparklines
2. Univariate, bivariate, and multivariate data visualizations
3. Tufte's 5 Data Graphic Principles of data visualization
4. Data storytelling principles
E. Descriptive Statistics
1. Data variable types (continuous vs. discrete, nominal vs. ordinal)
2. Measures of center in statistics, e.g., mean, median, and mode
3. Measures of spread in statistics, such as range, quartiles/interquartile range, standard deviation, variance
4. Descriptive statistics (SUM/COUNT, SUMIF/COUNTIF, SUMPRODUCT, etc.)
5. Statistics-based data visualizations
F. Exploratory Data Analysis
1. Exploratory Data Analysis (EDA) definition
2. Applications of EDA to business insights
3. EDA-supported data visualizations
G. Communicating Data Insights
1. Data visualization communication planning and messaging
2. Data insight design principles
3. Data storytelling best practices
Lab Content
Not applicable.
Special Facilities and/or Equipment
Method(s) of Evaluation
A. Formative Activities and Assessments
B. Critical Thinking Assessments
C. Summative Assessments
D. Class Project
E. Discussion
Method(s) of Instruction
A. Lectures
B. Discussions
C. Activities
D. Problem-based learning
E. Case studies
F. Collaborative learning/peer review
G. Demonstration/modeling
H. Performance-based assessments
Representative Text(s) and Other Materials
Riche, Hurter, Diakopoulos, and Carpendale. Data-Driven Storytelling. CRC Press, 2018.
Provost and Fawcett. Data Science for Business. O'Reilly Media, 2013.
Nussbaumer Knafic. Storytelling with Data: A Data Visualization Guide for Business Professionals. Wiley, 2015.
Types and/or Examples of Required Reading, Writing, and Outside of Class Assignments
A. Reading Assignments:
1. Selected textbook readings (approx. 40 pages per week)
2. Articles
a. Example article: Scherbak, "Is data science a science: What to expect from your first data science project", Medium, March 12, 2019.
3. Case studies
4. Web research