If you’re not using this data-searching trick in Excel, you’re wasting lots of time, VLOOKUP

image

BusinessInsider.com is a financial news web site.  But in the financial world, they use a lot of Microsoft Excel.  So every once in a while they post one of their favorite features of Excel.  Here is a good video on how to use VLOOKUP.

Video: http://www.businessinsider.com/how-to-data-vlookup-excel-microsoft-2015-1

Enjoy, Patrick

Power Map and XBOX–Video Game Analytics within the game…

I remember some past discussions about finding kill boxes in Halo where in test people tended to get crushed in a certain area of the game so they would adjust the map so it wouldn’t be that hard.  Now using power maps, you can put in your own custom background and map the geo-code data right on top.  I love that.

Enjoy, Patrick

Can you imagine using HD Space Video for Business Intelligence and Analytics? I can. @skybox #analytics #bigdata

HD Space Video

I can imagine using the HD Video from Space to review traffic patterns at shopping malls or sporting events.  Being able to determine mining output or even farm fields and the success or failure of their crops.

Using identification technologies, creating models on top of these live images to assess the increase or decrease in movement/production.

Amazing, the next big thing in BIG DATA is coming soon.

Check out Skybox: http://www.skybox.com/

Enjoy the video, Patrick

Geospatial Analytics–This is a must watch

I stumbled upon this the other day and thought this is worth sharing.  This is exactly why I started my company because we wanted to do innovative insights like these.  Check out the videos.

Source: http://www.dailymail.co.uk/news/article-2161488/Secret-corpse-flights-pizza-boy-delivery-routes-daily-commute-Stunning-aerial-images-reveal-seen-America.html

Way of the dead: These lines show the unpublicised transportation of dead bodies, some clearly being repatriated to their home states from the U.S.'s retirement mecca state of Florida

Snack time: GPS trails reveal the routes taken by cycling pizza delivery riders on one Friday night in Manhattan. Each rider's shift lasts eight to nine hours, in which time they can deliver between 30 and 40 pizzas all over the city

 

 

 

Enjoy, Patrick

 

 

 

 

 

.