Visual Analytics
Due Date 04/24/2022 11:00 PM
First phase the assignment idea:
The first task is to find a dataset and identify a business problem or a series of interesting questions. You must analyze and visualize real-world data. In order for you to have the greatest chance of success with the final outcome, it is important that you choose a manageable dataset.
1. The data should be readily accessible and large enough that multiple relationships can be explored. As such, your dataset must have at least 8 Measures and 8 dimensions. (exceptions can be made but you must discuss with me first).
2. To assist you in choosing a feasible problem and dataset, check with me by email about your idea for approval by 04/12/2022.
3. Informal discussions with the professor can help to refine the assignment.
4. Here are some links you can check to get data (but not limited to, so you can still do your search and find a dataset):
Popular open data repositories:
UC Irvine Machine Learning Repository: http://archive.ics.uci.edu/ml/index.php
Kaggle datasets: https://www.kaggle.com/datasets
Amazon’s AWS datasets: https://registry.opendata.aws/
Data Portals: http://dataportals.org/
Open Data Monitor: https://opendatamonitor.eu/frontend/web/index.php?r=dashboard%2Findex
Assignment Requirements:
You need to use and apply the Visual Analytics concepts that we discussed in the class.
1. Data Discovery: Show how to use Tableau as a tool to explore the dataset to understand what data you have visually. For example, you can generate at least four graphs to discover some relationship between fields.
2. Questions: Your visualization must be able to answer the proposed questions. A good question may involve in two or more attributes (variables) and related to time or spatial information. You may need to revise your questions several times to tell a good story. You must have five questions.
3. Calculations: You must use Table calculations along with another type of calculations (like Row-Level, Aggregate calculations or LoD expressions). Explain why you used this type of calculation. You need to use at least 4 calculations.
4. Visualization: At least 8 or more different visualizations must be used. Use different types of visualizations. Make sure to follow the guidelines to create informative and effective charts.
5. Dashboard : must be included. The dashboard must be interactive. You need to have at least one parameter. You need to design the dashboard by following the dashboard format guidelines.
Assignment Report (Word Document):
A narrative description of the business problem should be addressed.
1. Introduction: Start with a draft of the introduction section of your assignment. This introduction should introduce your business problem and the potential solution.
2. Explore the Data: Describe what Tableau Techniques you used to discover and understand the data. List all the charts that you created with enough description about each.
3. Questions: Clearly state all the five business questions.
4. Calculations: Describe all the calculations that have been made to the data. Include the functions, charts and the results.
5. Visualization: Include screenshots for all the generated charts along with the Dashboard. Under each graph, discuss how this chart answered the business question and the find the insights.
6. Conclusion: Write down your final results and conclusion about the findings. Suggest solutions/actions that the business needs to take in order to solve the problems.
7. Format: APA
Submission Checklist:
1. Dataset file: original file and the modified one in case if you did any modifications.
2. Tableau workbook (.twbx).
3. Report document (.doc).
