tutorial on Data Maps?

[AndyDevine1]

Hi there
I've been googling to try and read up on Data Maps and am not getting anywhere fast :-/

Can you help?

What versions of excel do they work with?
Can i show a map of uk with hotspots or pie charts etc on it? Can I plot eg sales territories?
Are they dynamic?
If I have a map in my work book will the file size be huge?
As bing = Microsoft and maps are based on bing is it not worth looking into Google maps or any other alternatives?
But generally, where's a good place to read up on them? Or any good not too long tutorials on them so I can read up and hopefully start using?

Many thanks

 

[cyrilbrd]

Hi, what version of Excel are you using?
Are you referring to PowerView?
Read this: link
Excel uses Bing for the map creation, this said it is not an issue as the maps are as accurate as found of google.
Example of how the raw data would look:

Excel 2013
	A	B	C	D	E	F	G	H
1	Loc	#	Diesel	Gasoline	Jet A1	Latitude	longitude	total
2	L1	Operation	2,680	5,660		8.75456	114.5456	8340
3	L2	Genset	6,036			9.19147	114.741	6036
4	L3	Support	524	3,170		9.697037	115.2698	3694
5	L4	Delivery			840	10.59158	115.6036	840
6	L5	Operation	2,560	5,915		11.06811	116.4163	8475
AndyDevine1

Whenever the raw data is changed you would need to refresh the Power View sheet.
The created dashboard can be a mix of charts maps and data.
All is dynamic, easily filtered and linked.