Abstract: This article presents a multi-stage guided technical project coding Python scripts for utilizing Amazon Web Services (AWS) to work with a document-store database called DynamoDB. Students doing this project should have taken an introductory programming class (ideally in Python) and a database class to have experience with Python coding and database manipulation/querying in a relational environment. Students learn new data formats (Python dictionaries, JSON text data, key-value storage structures) and learn how to transform data from one format to another. They also gain experience with data visualization. The project was first carried out in a business intelligence (BI) course during Spring 2020 semester in the midst of COVID and included video tutorials. Since then, it has been refined and used each semester the BI course is taught.

Keywords: Programming, NoSQL, Business intelligence, Cloud computing, Active learning, Flipped classroom

Download This Article: JISE2023v34n1pp41-48.pdf

Recommended Citation: Mitri, M. (2023). Teaching Case: Using Python and AWS for NoSQL in a BI Course. Journal of Information Systems Education, 34(1), 41-48.