BA 269 Advanced Excel and Data Visualization

Presents advanced features of Excel for solving business problems. Includes data extraction, model-building, and data presentation. Introduces key concepts in data visualization using industry standard software. Emphasizes data storytelling to create compelling and persuasive presentations that contribute to decision making.

Credits

4

Prerequisite

BA 169Z and MTH 095 or higher, or instructor consent

Course Learning Outcomes

Upon successful completion of this course, the student will be able to:
1. Load and transform data from a variety of sources using Power Query
2. Sort, filter, and manipulate data using dynamic array functions
3. Use forecasting and data analysis tools to solve business problems
4. Create effective data visualizations using common business analytics software, e.g. Power BI, Tableau
5. Use data to create and deliver compelling business presentations