Apr 25, 2024  
Course/Program Inventory 
    
Catalog Navigation
  Catalog Home
  All Courses
  Community College Course Inventory
  Community College Common Course Libraries
  TCAT Course Inventory
  TCAT Program Inventory
  Articulation Agreements
  Tennessee Transfer Pathways
  TCAT to CC Articulation Brochure
HELP
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