Data Literacy

Students will handle real problems that occur with «messy » data and reporting, requiring retrieval from databases, cleaning, reformatting, investigating for meaning and presenting their findings in a visual manner. They will access data « in the cloud » using SQL clients, as they will in an enterprise setting, and summarize data as requested by many managers.

 

This module includes the following courses:

  • Business Analytics: advanced Excel and SQL
  • Excel Basics: data cleaning, types, filtering, sorting, descriptive stats
  • Guerrilla Data Analysis
  • Excel Advanced: formulae, pivot tables, Excel dashboards and reports
  • Excel Charts and Stats: advanced model stats and good charting techniques
  • SQL: intro, download the client, connect to cloud server
  • SQL: more advanced queries, big data & SQL
  • Data Visuals with Tableau & Power BI
  • Tableau Dashboards: dashboards and stories videos
  • SQL to Tableau and Excel, Reporting – project to put it all together
  • Python Coding Bootcamp
  • Setup / Installation of Anaconda
  • Introduction to Coding: variables, methods
  • Loops and Conditional Statements
  • Data Structures
  • I/O
  • Using NumPy for Marketing Data Analysis
  • Statistics for Market Research using R
  • Installation / Setup of R: how to install packages
  • Descriptive Statistics
  • Hypothesis Testing
  • PCA
  • Working with Panel Data
  • Charting Results with ggplot