Tag: Data Visualization

Data Visualization

Posted on | by Brian Leakey

You serve as the Deputy Chief Financial Officer of your city government. Recent

discussions in upper-level management meetings highlight concerns about the

government’s financial performance. Juliet Sweeting, the city’s Chief Financial

Officer (CFO) asked you to help benchmark your city’s financial performance against

another city of similar size. You have been tasked to create a Dashboard in Excel

that can use to compare your city to any other city. The comparison will be done with

ratios commonly used to evaluate the financial health of city governments.

Your goal is to choose another city similar to yours and compute the ratios for each

city. Create a dashboard whereby Ms. Sweeting, CFO can easily read and

understand the results in 30 seconds or less.

  1. Find the Comprehensive Annual Financial Reports for two cities.
  2. Type in the financial statements of the two cities in side-by-side fashion on Tab 3

of your Excel file (Do not copy and paste a picture. You need these numbers for

your computations). If data not shown on the financial statements is necessary

for your ratio computations, create an “Other Information” area to post this data

for the two cities.

  1. Use Tab 2 of your Excel file to show the computation of the ratios by category; see the Appendix below. The information used to compute the ratios should flow

from the data in Tab 3. Make sure it is clear to your CFO that you know how to

compute and interpret these ratios.

  1. Use Tab 1 to create a dashboard showing the results of the ratios, comparing

the two cities. The dashboard should be composed ONLY of clearly-marked

graphs that convey the data in a way that makes it easy to read and understand

quickly.

  1. When Ms. Juliet Sweeting, CFO changes numbers on the financial statements

on Tab 3, the dashboard graphs should automatically change.

Data visualization

Posted on | by

 

 

 

To continue learning about data visualization, read sections 5 and 6 of the attachment.Also, watch this video.

Hans Rosling’s 200 Countries, 200 Years, 4 Minutes – the Joy of Stats (YouTube 4:47) (Links to an external site.)

Complete the following for this assignment. Task 11, 12, and 13 are located in the Seeing and Understanding document.

Select and complete either task 11 or 12.
Complete task 13
Re-play Rosling’s visualization at your own speed.
Explore the data for a single country by selecting it in the rightmost column.
Write a paragraph about the story of the world when the dynamic data includes all countries and another paragraph about how the country you watched fits or deviates from that story.
Give a careful description of the story told by the animation for all 200 countries and how the story of just a single country fits into the larger world picture.
Include a screenshot of the final year in that single-country story.

 

Data Visualization

Posted on | by

This week you watched Big Data Visualization (YouTube Video) and Information is Beautiful where you learned about how good designs are the best way to navigate information overabundance.

Discussion:
David McCandless turns complex data sets (like worldwide military spending, media buzz, Facebook status updates) into beautiful, simple diagrams that tease out unseen patterns and connections. Choose ONE of the graphics to discuss from Information is Beautiful and then answer the questions below. Be sure to indicate in your response, which of the graphics you have chosen to analyze.
Questions:
Which of the graphics did you choose?
What ideas or pieces of information does the author present? List as many as you can.
Identify the main conclusion told in the graphic. This should not just be the title, but what conclusion you can make from the information provided.
Describe how the author represents data in the graphic. Example, using color to represent two things.
What other ways does the author tell the audience about the key message(s)?
What do you like/dislike about the graphic?

Data Visualization

Posted on | by

This week you watched Big Data Visualization (YouTube Video) and Information is Beautiful where you learned about how good designs are the best way to navigate information overabundance.

Discussion:
David McCandless turns complex data sets (like worldwide military spending, media buzz, Facebook status updates) into beautiful, simple diagrams that tease out unseen patterns and connections. Choose ONE of the graphics to discuss from Information is Beautiful and then answer the questions below. Be sure to indicate in your response, which of the graphics you have chosen to analyze.
Questions:
Which of the graphics did you choose?
What ideas or pieces of information does the author present? List as many as you can.
Identify the main conclusion told in the graphic. This should not just be the title, but what conclusion you can make from the information provided.
Describe how the author represents data in the graphic. Example, using color to represent two things.
What other ways does the author tell the audience about the key message(s)?
What do you like/dislike about the graphic?

Data visualization

Posted on | by

When thinking about data visualization, it is important to understand regular expressions in data analytics. Therefore, note the importance of data visualizations and choose two types of expressions (* – wildcards for example) and discuss the difference between the two types of expressions.