Oct 03, 2022  
Course/Program Inventory 
Course/Program Inventory

CITC 2308 - Data Analytics Spreadsheets

Credit hours: 3

Prerequisites: INFS 1010 - Computer Applications  

CITC 1303 - Database Concepts  

Course Description:
This course introduces students to the intricacies of data analytical functions using spreadsheet tools. Students will learn how to identify outliers in data, group data, and bin data for analysis. Students will also learn how to perform time series analysis and work with advanced analytic features of Power BI, such as Quick Insights, AI Insights, analyze features and gain insights on data using Excel tools like PivotTables, charts and slicers.

Student Learning Outcomes:
Students will be able to:

  1. Perform statistical data summaries
  2. Identify outliers visually with Power BI
  3. Prepare data for analysis by using groups and bins
  4. Perform data analysis using key metrics, comparisons, trends, rankings, interactive dashboards, clustering techniques and time series