BUS 331: ADV DATA ANALYSIS & VISUALIZATION

This course provides an in-depth examination of the statistical tools most commonly used to process, analyze, and visualize data. It will emphasize practical challenges involving real-world data using industry standard software including Excel, Power BI, and Tableau. Students will learn the fundamentals of data analysis using spreadsheets and tools such as Power BI and Tableau. They will become proficient in using basic excel functions such as VLOOKUP, HLOOKUP, and MATCH to organize, clean, and analyze data. Students will also become proficient in creating pivot tables and using Visual Basic for Applications to create macros in excel. Students will learn the skills and concepts needed to create visual displays based on quantitative and qualitative data to aid the business decision making.