ISA 401: An Undergrad Course on Business Intelligence & Data Visualization

This repo contains my lecture notes (created in R Markdown) for an undergraduate business intelligence and data visualization course. The course is divided into three main phases:

• Phase 1: Extracting, Transforming and Loading Data -- I chose to utilize the R programming language as the software tool of choice for this phase. Other instructors at Miami use Power BI (a Microsoft software tool for this purpose).
• Phase 2: Data Visualization, which covers both basic principles behind data visualization and how to make charts. Many of our students are expected to learn Tableau for their jobs and hence, I mix Tableau and Power BI (to mantain consistency with other sections taught at my school) and introduce some neat charts from R along the way due to my belief that scripted languages provide a good understanding of the grammar of making good graphics.
• Phase 3: A Very Short Introduction to Exploratory/Visual Data Mining Tools.

Schedule

The raw .Rmds for all presentations can be found under the folder titled lectures. The schedule below has links to the associated GitHub Pages where the generated HTML slides are hosted. The schedule below is for the Fall 2024 semester.

Week	Date	Topic	Slides (Hosted Page)	Slides (PDF)	Slides (PPTX)
01	08/26	Introduction to Data Viz and BI	01_introduction.html	01_introduction.pdf	01_introduction.pptx
	08/28	Introduction to R	02_introduction_to_r.html	02_introduction_to_r.pdf	02_introduction_to_r.pptx
02	09/04	Data Import and Export in R	03_data_import_export.html	03_data_import_export.pdf	03_data_import_export.pptx
03	09/09	Web Scraping in R	04_scraping_webpages.html	04_scraping_webpages.pdf	04_scraping_webpages.pptx
	09/11	No Class: Fadel at a Conference	--	--	--
04	09/16	Web Scraping in R (Cont.)	04_scraping_webpages.html	04_scraping_webpages.pdf	04_scraping_webpages.pptx
	09/18	Scraping Multiple Pages in R	06_scraping_multiple_webpages.html	06_scraping_multiple_webpages.pdf	06_scraping_multiple_webpages.pptx
05	09/23	Introduction to APIs	07_intro_to_apis.html	07_intro_to_apis.pdf	07_intro_to_apis.pptx
	09/25	Tidy Data	08_tidy_data.html	08_tidy_data.pdf	08_tidy_data.pptx
06	09/30	Technically Correct and Consistent Data	09_technically_correct_and_consistent_data.html	09_technically_correct_and_consistent_data.pdf	09_technically_correct_and_consistent_data.pptx
	10/02	Technically Correct and Consistent Data (Cont.)	09_technically_correct_and_consistent_data.html	09_technically_correct_and_consistent_data.pdf	09_technically_correct_and_consistent_data.pptx
07	10/07	Intro to Data Correction and Imputation	11_data_correction_and_imputation.html	11_data_correction_and_imputation.pdf	11_data_correction_and_imputation.pptx
	10/09	Exam 01	--	--	--
08	10/14	Exam 01 Recap	--	--	--
	10/16	Fundamentals of Data Visualization	14_fundamentals_data_viz.html	14_fundamentals_data_viz.pdf	14_fundamentals_data_viz.pptx
09	10/21	Lab 01: Tableau Intro	--	--	--
	10/23	Lab 02: Power BI Intro	--	--	--
10	10/28	Commonly Used Charts	17_commonly_used_charts.html	17_commonly_used_charts.pdf	17_commonly_used_charts.pptx
	10/30	Time Series Charts	18_ts_charts.html	18_ts_charts.pdf	18_ts_charts.pptx
11	11/04	Spatial and Spatiotemporal Charts	19_spatial_and_spatiotemporal_charts.html	19_spatial_and_spatiotemporal_charts.pdf	19_spatial_and_spatiotemporal_charts.pptx
	11/06	High Dimensional Charts	20_high_dimensional_charts.html	20_high_dimensional_charts.pdf	20_high_dimensional_charts.pptx
12	11/11	Exam 02: Fundamentals of Data Viz	--	--	--
	11/13	Business Reporting	22_business_reports.html	22_business_reports.pdf	22_business_reports.pptx
13	11/18	Data Mining Overview	23_data_mining_overview.html	23_data_mining_overview.pdf	23_data_mining_overview.pptx
	11/20	Clustering Intro	24_clustering_intro.html	24_clustering_intro.pdf	24_clustering_intro.pptx

Acknowledgments

• Phase I has benefited heavily from the following references:
  • The excellent STATS 220 Data Technologies course by @earowang.
  • The manuscript An Introduction to Data Cleaning with R.
  • Hadley Wickham's excellent books (R For Data Science and Advanced R).
• Phase III capitalizes on the third edition of Mining of Massive Datasets.

Old Versions of the Course

• The Spring 2024 version of the course can be accessed by clicking on the tag titled spring2024.

• The Fall 2023 version of the course can be accessed by clicking on the tag titled fall2023.

• The Fall 2022 version of the course can be accessed by clicking on the tag titled fall2022.

• The Spring 2022 version of the course can be accessed by clicking on the tag titled spring2022.

Notes

• I did my best to add references whenever possible. If I missed a reference, please let me know (via a pull request, PR).
• If you have identified mistakes/typos, please let me know.