BUS 421 Ch. 11 Data Visualization

STATISTICAL PROGRAMMING TOOLS - T or F: YOU CAN CREATE PLOTS IN THE PROGRAMMING TOOL R - it's possible to generate charts, plots, and maps without purchase using open-source programming tools such as _________. - T or F: The process of creating visuals in R is not as user-friendly and the output is not as beautiful as tools like Tableau and Power BI. - T or F: it is often convenient to use R to generate charts, plots and maps while using R to analyze the data in advanced ways (i.e., advanced data analysis techniques like regression or clustering) not available in tools like Tableau. - A popular package in R for data visualization is ____. - T or F: R doesn't allow control over individual components from the data points, trend lines and the axes of the graph, thus not allowing for much customization.

- True - R - True - True - ggplot - FALSE!!! It does allow!

What are the 3 categories of tools?

1 Commercial data visualization tools 2 Commercial geographic information system tools 3 Statistical Programming tools (like R)

There are 2 Tableau platforms:

1 Tableau Desktop 2 Tableau Online

****Steps to prepare for data visualization:*****

1. know ur audience 2. assess the data (consider the cardinality of the data ur trying to visualize) 3. Decide bw visualization options/tools (one of the biggest challenges marketing analytics face is choosing a visualization tool!) - word cloud - infographics - charts & tables

Such visualizations include: _____ = graph that displays information as vertical bars - _____ = graph that displays information as a series of data points connected by straight lines _____ = graph that displays information as a circle divided into slices to illustrate proportion _____ = graph that displays information as horizontal bars _____ = graph that displays information as a line chart for which distinct areas between the lines and the axes are emphasized with colors, textures and/or hatchings ______ = graph that displays information as dots representing the correlation between two variables _______ = graph that displays information related to spatial variables in the data and in the real world ______ = graph that displays information as a line chart or area chart with many axes representing more than two variables in the data

Column chart - Line chart Pie Chart Bar chart Area Chart Scatter plot Geographical information map Radar Chart (aka Spider chart)

______ tools = are online or desktop software packages that offer a wide range of options for data visualization for a price. They offer many types of visualization.

Commercial data visualization tools

COMMERCIAL GEOGRAPHIC INFORMATION SYSTEM TOOLS ____ = is one of the biggest firms offering GIS applications for purchase. ____ = provides detailed information for a specific town, block and even street.

ESRI ArcGIS

_____ = is one of the most frequently used data tools to create, analyze and present company data visually

Excel

_____ = graph displaying information to illustrate a project schedule as a timeline _____ = Displays information as a scatter plot with an additional dimension of quantitative data represented by changing dot size _____ = graph that displays information as a map in which variables are represented using colors (with red typically used to depict the highest intensity of the variable). _____ = graph that displays information as a diagram of hierarchical data in the form of nested rectangles whose size reflects a variable's quantitative value ______ = graph that displays information as a rectangle depicting quartiles with lines extending vertically to indicate variability outside the upper and lower quartiles

Gantt chart Bubble chart Heat map Tree map Box-and-whisker plot: (5 of all these don't have the word "chart")

_____ = means a data variable has mostly unique values _____ = means a data variable has mostly repeat values A gender column is an example of which? Bank account numbers would be an example of which?

High cardinality Low cardinality Low cardinality High cardinality

____ = tell a story by combining pictures, words, charts, stats and percentages in one effective graphic. ____ = is a simple way to visualize keywords. 3 major parts of Infographics

Infographics Word cloud - design -content -knowledge

Tableau Power BI Excel ______ = For big companies with large servers and countless amounts of data... can combine data from disparate databases, files and web services with visual tools that helps illustrate and fix quality data and formatting issues. _____ = Its visualization features are not as advanced. ____ = The charts, plots and maps produced tend to be less aesthetically attractive

Power BI EXCEL EXCEL

T or F: With Tableau, once finished creating visualizations, users can publish visualizations using Tableau Online or Tableau Server.

T

_____ = is one of the most popular data visualization apps available for purchase.

Tableau

______ = Has visuals head and shoulders above competition.

Tableau

______ = produces aesthetically pleasing charts as well as interactive products.

Tableau

What are the types of "Commercial Data Visualization Tools" ?

Tableau Power BI Excel

Tableau vs Power BI - Stronger at data visualization - Stronger at data manipulation - Easily develops predictive modelling and optimization - Data is selected first then switch between visualizations later - Visuals are selected first then data is added - Its lower cost makes it better for small businesses - Leans toward large business - Any number of datapoints. - Places a 3,500 datapoint limit.

Tableau Power BI Power BI Tableau Power BI Power BI Tableau Tableau Power BI

Tableau Desktop or Tableau Online? Offers pre-packaged visuals to help with user-created designs and allows resulting visuals to be transferred into dashboards, which can display several visuals on a page. Data is stored on the cloud and can be accessed from a browser, tablet or mobile device.

Tableau Desktop Tableau Online

_____ = is a software application for desktop computers that allows users to create insightful data visualization Which is the most powerful of the Tableau platforms for visualizing data?

Tableau Desktop Tableau Desktop

_____ = is a software service that is served online rather than downloaded onto a computer.

Tableau online

Which color schemes are color blind friendly? 8% of men & .05% of women are affected by color blindness, most commonly with a ___- ___ color deficiency

blue and orange schemes red-green

4 Attributes of Data Visualization:

communicate stories comprehend info quickly Identify relationships and patterns Pinpoint emerging trends

In addition to offering the basic charts, plots and maps offered by Tableau and Power BI, Excel also offers power _____ and power ______ , two visualization tools that enable users to explore data. _____ = enables interactive, graphical exploration of data trends. _____ = offers geographic mapping. ____ = presents data through 3-D GIS (geographic Information System). _____ = presents data through charts, graphs, maps, and other visuals like GIS.

power view power map power view power map power map Power view

T or F: Like Tableau, Power BI produces charts and reports, then allows the user to publish them on the web and across mobile devices What is Power BI's most universal and beneficial attribute?

true dashboards! (allows users to create dashboards that can be edited & automatically updated.)

Is it possible to create geographic information maps in all three? y or n It's possible to create basic & complex bar charts within *statistical programming tools*, but the options will be more advanced and look more professional within which tool?

yes, , but the depth of analysis and visualization will be much higher in the second group. Commercial data visualization tools.