#!/usr/bin/env python # coding: utf-8 # ## Data Visualization # ### Tableau # Tableau is a data visualization tool that offers a free platfrom called Tableau Public. Tableau Public can load common spreadsheet formats like Excel and CSV and offers an easy to use interface to create a variety of charts and data visualizations called "Vizzes" that can be shared easily on the Tableau Public website. Tableau makes code available to embed your "Vizzes" into other sites, which will be used in the next notebook "Viewing Charlotte" to present the results of this project. # # Once a spreadsheet is imported into Tableau, the program autodetects data fields listing them on the left side of the screen in the "Tables" menu. Data fields can be dragged and dropped into either the Column or Row "shelves" in a Tableau "Worksheet" to generate a visualization. Fields can also be used to create labels, color charts, and create filters for the data in a visualization. Tableau offers suggestions for combining the fields to create various types of charts (bar graphs, scatter plots, pie charts, etc.) using the "Show Me" menu on the right side of the screen. # # ![Tableau1](Images/Tableau4.jpg) # # Using Tableau, I created visualizations to examine a number of different factors like the racial makeup of particular streets, the number of business per street, and the ownership of businesses by race. Tableau is accessible and easy to use and offers several short tutorial videos for new users. # # ![Tableau1](Images/Tableau1.jpg) # # Using filtering with Tableau allows charts to be edited to reflect only the desired values, in this case null results were excluded for addresses that did not give a direction to their street address. # # ![Tableau2](Images/Tableau2.jpg) # # Multiple Tableau Worksheets can be combined into a single view on a Dashboard, where the charts can be used as filters to interact with other charts' content. # # ![Tableau5](Images/tableau5.jpg) # # Multiple Tableau Worksheets can also be combined into a single presentation with captions called a Story, a PowerPoint like format. # # ![Tableau3](Images/Tableau3.jpg) # # Tableau also offers features that allow you to link multiple datasets to create graphs that cross multiple spreadsheets, although this feature was not used for this project. The next notebook will present the findings of the data analyzed for this project. # Next: [Revisualizing Charlotte](RevisualizingCharlotte.ipynb)