Applied Business Project 2

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

<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

2.

2.1. Tabular Data Representation

<insert your solution for Task 2.1>

2.2. Treemap Charts of financial data – your company

<insert your treemap chart for Task 2.2> - your company

2.3. Treemap Charts of financial data – a competitor

<insert your treemap chart for Task 2.3> - a competitor

2.4. 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

3.

3.1. Tabular Data for Sustainability Visualization

<insert your solution for Task 3.1 here>

3.2. Sustainability Visualization (Radar Chart)

<insert your solution for Task 3.2>

3.3. Sustainability Assessment (150 words)

<insert your solution for Task 3.3>

Task 4: Assessing your stock the Warren Buffet Way

4.

4.1. Selection of Criteria and Visualization Chart Type

4.1.1. Criterion identifier and description

<insert your solution for Task 4.1.1>

4.1.2. Selected chart type

<insert your solution for Task 4.1.2>

4.2. Visualization Assessment (150 words)

<insert your solution for Task 4.2 here>

4.3. Buffet Assessment Data Visualization

<insert your visualization for Task 4.3 here>

MIS 111 Fall 2022 Version 1.0 Page 3 of 3