Academic Catalog

BUSI 12: INTRODUCTION TO DATA ANALYTICS & BUSINESS DECISIONS

Foothill College Course Outline of Record

Foothill College Course Outline of Record
Heading Value
Effective Term: Summer 2024
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

This course is an overview of data analytics and their use in making business decisions, covering a broad selection of topics along the life-cycle of data analytics (business objective; data collection, cleansing, transformation; data analysis, data visualization/storytelling; data-based decision making). Professional skills, such as communication, presentation, and data storytelling, are presented. Students will acquire a basic working knowledge of data analytics through hands-on projects and study in a variety of business, engineering, social sciences, or life sciences domains. Issues of ethics, leadership, and teamwork are highlighted.

Course Objectives

The student will be able to:

  1. Describe data analytics/science and its applicability to business decision making
  2. Apply basic data analytics methods to business decision making
  3. Describe and perform basic data collection, manipulation, and preparation techniques using standard data analytics software
  4. Describe standard data analytics techniques used to identify insights, including data visualization, data storytelling, exploratory data analysis
  5. Present analysis insights based on standard data analytic practices

Course Content

  1. 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
  2. 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
  3. Data preparation
    1. Data analytic tool fundamentals
      1. Tool structure and functionality
      2. Integration to external data source
      3. Static data vs. dynamic data
      4. Absolute vs. relative references
      5. Data paste, imputation, and filtering
      6. Data cleaning best practices
      7. Data cleaning and Null values
      8. Merging and joining multiple datasets
  4. Introduction to data visualization and data storytelling
    1. Chart creation
      1. Column chart
      2. Line chart
      3. Scatter chart
      4. Combination chart
      5. Sparklines
    2. Univariate, bivariate, and multivariate data visualizations
    3. Tufte's 5 Data Graphic Principles of data visualization
    4. Data storytelling principles
  5. 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
  6. Exploratory Data Analysis
    1. Exploratory Data Analysis (EDA) definition
    2. Applications of EDA to business insights
    3. EDA-supported data visualizations
  7. 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

When taught as an online distance learning section, students and faculty need ongoing and continuous internet and email access.

Method(s) of Evaluation

Methods of Evaluation may include but are not limited to the following:

Formative activities and assessments
Critical thinking assessments
Summative assessments
Class project
Discussion

Method(s) of Instruction

Methods of Instruction may include but are not limited to the following:

Lectures
Discussions
Activities
Problem-based learning
Case studies
Collaborative learning/peer review
Demonstration/modeling
Performance-based assessments

Representative Text(s) and Other Materials

Sharda, Delen, and Turban. Business Intelligence, Analytics, and Data Science: A Managerial Perspective, 4th ed.. 2021.

Favero and Belfiore. Data Science for Business and Decision Making. 2019.

Riche, Hurter, Diakopoulos, and Carpendale. Data-Driven Storytelling. 2018.

Types and/or Examples of Required Reading, Writing, and Outside of Class Assignments

  1. Reading assignments:
    1. Selected textbook readings (approx. 40 pages per week)
    2. Articles
      1. 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

Discipline(s)

Business