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