CIS 275E Data Exploration and Visualization

Using tools and techniques of beginning data analysis, students will learn how to get raw data from various sources and manipulate it into a format that can be used to answer questions about business problems. From that raw data, students will learn how to visualize the relationships between data elements through charts and graphs, draw conclusions from the charts presented, and communicate their findings in a professional manner.

Credits

4

Prerequisite

CS 275 and MTH 095 

Course Learning Outcomes

Upon successful completion of this course, the student will be able to:
1. Explain the analytical process and the roles of data analyst and data scientist
2. Understand the concept of preparing a set of questions that will allow accurate data analysis and help discover relevant business insights
3. Effectively use advanced SQL aggregate functions (statistical aggregations and windowed aggregations) to perform initial exploratory data analysis on raw data
4. Effectively use tools such as Excel or Oracle to pull data from various sources to create a single reporting source
5. Effectively use graphical tools such as Excel or Tableau to represent data and show relationships between data elements
6. Create a professional proposal on a business problem, and charts and graphs showing the result, their analysis of the problem, and their resulting solution