class11: Report the Data Flashcards

1
Q

a way of presenting results of the analysis in an accessible way using charts/graphs
: supports the dominant learning style of the population

A

Data Visualization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

what are power BI & Tableau used like?

A

large datasets
blend/merge dataseets
charts
dashbords

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

5 big questions to decide what chart to use

A
  1. what business questions are you trying to ansewer
  2. who is the target audience for the visualization
  3. which type of data is being visualized? - categorical / numerical
  4. what type of analysis have you performed? - exploratory/confirmatory
  5. what is the best way to show what you want to show?
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

5 charts for categorical data

A

pie chart
symbol map
tree map
heat map
bar chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

+ - of tree map

A

+
: patterns, outliers, many categories
_
: not exact proportion/number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

+ - of symbol map

A

+
: proportions across geographical areas
-
: not exact proportion/number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

+ - of heat map

A

+
: shows the density of certain data
: visualize data across multiple categories, patterns, correlation
-
: not exact proportion / number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

five main purposes for visualization

A
  1. comparison
  2. correlation
  3. distribution
  4. trend evaluation
  5. part to whole
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

charts used for ‘part-to-whole

A
  1. pie / donout
  2. waffle
  3. tree maps
  4. heat maps
  5. sunburst
  6. stacked bar chart

area / pie / stacked bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

charts used to show relationships

A

bubble chart
scatter chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

charts used to show distributions

A

histogram chart
line chart
scatter chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

charts used to indicate trends

A

line chart
column chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

charts used to compare items

A

bar chart
column chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

charts used to compare over time

A

line chart
column chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

bar chart vs histogram (3 difference)

A

barchart
: represents categories
: gap btw 측정치
: y - axis - variety of statistics

histogram
: represents bins/intervals(number ranges)
: no gaps
: y-axis - frequency / count of observations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

what can box & whisker plot can do?

A

data distribution
identify outliers
descriptive statistics

17
Q

a dashbord that provides user specified filters to drill down, up, and through the data

A

interactive dashbord

18
Q

how charts lie (5)

A
  1. poor design(using wron visualization method)
  2. use of incorrect/inappropriate amount of data
  3. suggestion of misleading patterns
  4. support for pre-existing desired outcomes, opinions, or assumptions
  5. unclear communication of uncertainty
19
Q

4 things that executive summary can include

A
  1. statement of the problem, question, opportunity that initiated the business analytics project
  2. concise description of why the project is relevant to the audience
  3. summary of the results
  4. brief recommendations
20
Q

4 elements of a full report

A
  1. executive summary as the introduction
  2. description of the methods used
  3. expanded summary of the result
  4. expanded recommendations
21
Q

3 data visualization tools

A
  1. tableau
  2. microsoft power bi
  3. ms excel =
22
Q

what data visualization tool is faster for large data sets?

A

Tableau

23
Q

what data visualization tool is the most cost efficinet?

A

Microsoft Power BI

24
Q

Simple to use, effective and secure. It’s very popular and used to pre-process and visualize data effectively. Data sharing is also possible.

A

Tableau

25
Q

Data Visualization platform focused on creating data-driven solutions for business problems. It is used to pre-process, analyze and share meaningful insights with ease.

A

Microsoft Power BI

26
Q

this is the most common tool used by analysts to quickly handle data, sort, visualize and perform preprocessing on data

A

MS Excel:

27
Q

a data visualization tool that add a chart to numerical analysis

A

excel

28
Q

a cloud platform that use AI to update real-time business insight and activate business intelligence

A

quick view

29
Q

raw data, made up of data points

A

data series

30
Q

what chart can be used for outlier detection?

A

box and whisker plot

31
Q

what is the best chart to find a possible relationship btw two variables

A

scatter plot

32
Q

a type of confirmatory visualization that shows a trend line with a scatterplot
what is this and what is it for?

A

regression
to find the relationship between two variables