say we have 100 students details but we only want to know 10 – we slice it down to find this info
3 of 25
what does dicing mean
selecting a subset of columns
4 of 25
example of dicing
Sampling - used ot just find a students home address for example
5 of 25
what is rolling up
collapsing data into aggregated values
6 of 25
an example of rolling up
tesco want to find out where their sales have come from - 1.6 billion of it has come from uk but the rest of it has come from international – but they want to find out where – so they can find out how much has come from surrey by using rolling up
7 of 25
drilling down is..
expanded aggregated values
8 of 25
excel based analysis - pivot table
• Automatically sort and count data and then display the summarised data in another table • A pivot table is like a cross-tabulation but it’s interactive!
9 of 25
what if analysis - sensitivity analysis
this : is the study of the impact on other variables when one variable is changed
10 of 25
an example of what if analysis - sensitivity analysis
. if you have products at different prices and you want to sell 200 products – you will be able to twll how much money you are going to make – it will complete in one row instead of individually – it will be able to tell you that if you sell 100 prod
11 of 25
what is what if analysis - Goal-seeking analysis
find the inputs necessary to achieve a goal such as desired level of output. Wednesday
12 of 25
what is information visualisation?
The use of [interactive] visual representations of [large quantities of data] to improve cognition
13 of 25
what are the 6 types of visulisation?
textual data, parts and whole, changes over time, compare values, relationships, geographical data
14 of 25
textual cloud example
word cloud
15 of 25
parts and whole example
pie chart, tree map
16 of 25
changes over time data example
line graph, stack graph
17 of 25
compare values graph example
bar chart bubble chart
18 of 25
relationship graph example
scatterplot, network graph
19 of 25
georgraphical data is obviuosly......
maps
20 of 25
advantages of using word cloud
Easy to understand • They make an impact and can be shared easily • Word clouds can identify trends and patterns that would otherwise be unclear or difficult to see in a tabular format.
21 of 25
disadvantages of using word cloud
• Emphasise frequency of words, not necessarily their importance • Not effective for exploring complex topics • If different variations of a word is used
22 of 25
why would you use a treemap
to visualise the stock market
23 of 25
why would use an easy map
to visualize the sales by states
24 of 25
an easy map is good to use if...
you want to fibd out what countys or countrys are performing the best and worst – helpful if you want to communicate about location. the red aren’t doing well, the green are
Comments
No comments have yet been made