BUSI 12: INTRODUCTION TO DATA ANALYTICS & BUSINESS DECISIONS
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 demonstrate appropriate use of basic data analytics terms and concepts
- 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
Description
Course Objectives
The student will be able to:
- Describe data analytics/science and its applicability to business decision making
- Apply basic data analytics methods to business decision making
- Describe and perform basic data collection, manipulation, and preparation techniques using standard data analytics software
- Describe standard data analytics techniques used to identify insights, including data visualization, data storytelling, exploratory data analysis
- Present analysis insights based on standard data analytic practices
Course Content
- Introduction to data and business analytics
- Data, big data, information
- Definition of data analytics, data science
- Uses of data and data analytics in business
- Survey of popular data analytics tools
- Comparative descriptions of job roles that work with data and analytics
- Business framing in analytics
- Data requirements, data sourcing, data collection
- Business types and their interest in analytics
- Business data analytics stakeholder analysis
- Business data analytics stakeholder matrix
- Business objective definition
- Business objective to data solution mapping
- Methods to communicate data analytic findings in business vs. non-business context
- Data preparation
- Data analytic tool fundamentals
- Tool structure and functionality
- Integration to external data source
- Static data vs. dynamic data
- Absolute vs. relative references
- Data paste, imputation, and filtering
- Data cleaning best practices
- Data cleaning and Null values
- Merging and joining multiple datasets
- Data analytic tool fundamentals
- Introduction to data visualization and data storytelling
- Chart creation
- Column chart
- Line chart
- Scatter chart
- Combination chart
- Sparklines
- Univariate, bivariate, and multivariate data visualizations
- Tufte's 5 Data Graphic Principles of data visualization
- Data storytelling principles
- Chart creation
- Descriptive statistics
- Data variable types (continuous vs. discrete, nominal vs. ordinal)
- Measures of center in statistics, e.g., mean, median, and mode
- Measures of spread in statistics, such as range, quartiles/interquartile range, standard deviation, variance
- Descriptive statistics (SUM/COUNT, SUMIF/COUNTIF, SUMPRODUCT, etc.)
- Statistics-based data visualizations
- Exploratory Data Analysis
- Exploratory Data Analysis (EDA) definition
- Applications of EDA to business insights
- EDA-supported data visualizations
- Communicating data insights
- Data visualization communication planning and messaging
- Data insight design principles
- Data storytelling best practices
Lab Content
Not applicable.
Special Facilities and/or Equipment
Method(s) of Evaluation
Formative activities and assessments
Critical thinking assessments
Summative assessments
Class project
Discussion
Method(s) of Instruction
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
- Reading assignments:
- Selected textbook readings (approx. 40 pages per week)
- Articles
- Example article: Scherbak, "Is data science a science: What to expect from your first data science project", Medium, March 12, 2019
- Case studies
- Web research