Applied Business Project 2 – Data Visualization
You MUST use this template for your report
and submit your ABP-2 report to D2L as a PDF file.
Name: Lastname, Firstname (UA Email address)
Project: ABP-2 – Data Visualization
Task 1: ETL of Transactional Data
1.1. Extract of Extracted Data (from Yahoo! Finance)
<insert the Header plus only the first 10 rows of your downloaded CSV datafile here>
Important Note: Be sure your solution for Task 1.1 copies the data directly from your text editor
(as lines of “text” and not as an image) so that your solution matches the unformatted data in
the CSV file shown in the assignment guidelines. You must use a text editor for this task. You
cannot open your CSV file using Word, Pages, Excel, Sheets or other similar applications.
1.2. Stock Price Summary Table (Based on Full Data Set)
<insert your solution for Task 1.2 table here>
1.3. Stock Price Summary Table Formulas
1.3.1. Excel Formula for the Daily Open Low
<insert your Excel formula for Task 1.3.1 here>
1.3.2. Excel Formula for the Daily Open High
<insert your Excel formula for Task 1.3.2 here>
1.3.3. Excel Formula for the Daily Open Range
MIS 111 Spring 2022 Version 1.0 Page 1 of 3
Applied Business Project 2 – Data Visualization
<insert your Excel formula for Task 1.3.3 here>
1.4. Data Visualizations (Stock Trading Prices)
<insert your visualization solution for Task 1.4 graph>
1.5 Data Visualizations (Trading Volume)
<insert your solution for Task 1.5 graph>
1.6 Assessment of how Visualizations can inform an investor (150 words)
<insert your written Assessment for Task 1.6 here>
Task 2: Comparative Market and Financial Strength
1.5. Tabular Data Representation
<insert your solution for Task 2.1>
1.6. Treemap Charts of financial data – your company
<insert your treemap chart for Task 2.2> - your company
1.7. Treemap Charts of financial data – a competitor
<insert your treemap chart for Task 2.3> - a competitor
1.8. Treemap Charts of financial data – a company ourside your industry
<insert your treemap chart for Task 2.4> - an unrelated company
2.5 Value of a Treemap Chart in Investment Analysis (150 words)
<insert your solution for Task 2.5 here>
Task 3: Profiling Corporate Sustainability
1.9. Tabular Data for Sustainability Visualization
<insert your solution for Task 3.1 here>
1.10. Sustainability Visualization (Radar Chart)
<insert your solution for Task 3.2>
1.11. Sustainability Assessment (150 words)
MIS 111 Spring 2022 Version 1.0 Page 2 of 3
Applied Business Project 2 – Data Visualization
<insert your solution for Task 3.3>
Task 4: Assessing your stock the Warren Buffet Way
1.12. Selection of Criteria and Visualization Chart Type
1.12.1. Criterion identifier and description
<insert your solution for Task 4.1.1>
1.12.2. Selected chart type
<insert your solution for Task 4.1.2>
1.13. Visualization Assessment (150 words)
<insert your solution for Task 4.2 here>
1.14. Buffet Assessment Data Visualization
<insert your visualization for Task 4.3 here>
MIS 111 Spring 2022 Version 1.0 Page 3 of 3
