This course is a good preparation for business intelligence or business analyst roles that do not require programming. It covers advanced Excel (data cleaning, pivot tables, chart formatting, macro use), database queries with SQL, and data visualization and exploration with business intelligence tools like Tableau. The focus is on workflow for data analysis, moving from raw data tables and databases to insights that can be presented graphically and ideally tell a data story.
The course requires weekly individual homework, in-class exercises, quizzes, and a final individual project. The final project should be a useful portfolio piece for job interviews.
Course code: MK348
INSTRUCTOR: Lynn CHERNY