AEM 2830 - VBA and Python for Business Analytics

Spring. 3 credits. Letter grades only (no audit).

Forbidden Overlap: due to an overlap in content, students will not receive credit for both AEM 2830 and CS 1110.
Prerequisite: AEM 2010. Enrollment preference given to: Dyson students.

R. Moghimi.

Data-driven decision making and the use of analytical approaches are critical skills for success in business. Analytics skills are increasing in demand and in many cases, are required for business professionals. The new technologies and development such as personal electrical devices, social media, online shopping, etc., resulted in exponential growth in the amount of data we generate and collect on a daily basis. Companies are highly interested in extracting knowledge from these sources. To be able to manipulate and analyze large structured and unstructured dataset, you need to learn how to code. In this course, by learning VBA (Visual Basic for Applications), you will take your Excel skills to the next level. You will learn how to design and code an algorithm and manipulate datasets. In the second part of the semester, you will learn a more advanced coding language called Python. Python is a very strong language for data analysis.

Outcome 1: Program VBA, a strong tool that adds a great deal of functionality to Excel.

Outcome 2: Execute operations in Python, a strong open source coding language.

Outcome 3: Develop algorithmic thinking.

Outcome 4: Utilize and understand Basic Data Structures.

Outcome 5: Utilize and understand Conditional Branching and Looping.

Outcome 6: Build Procedures and Functions in VBA, and Functions in Python.

Outcome 7: Develop skills in building models to solve real-world business problems.