Let bi tell you: Where's Santa Claus?

Just saw an article about Christmas bi analysis, think very interesting, special to translate the next and everyone to share (unfortunately, the article published a little time).

With the coming days of Christmas, the POWER BI team answers one of the most important questions: where is Santa Claus?

Social network data is the most appropriate answer to this question, and we searched Twitter for the following keywords "Santa sighting", "Saw Santa", #santasighting and #sawsanta, Then we took the data to excel and created the power pivot model, and we used power view to navigate through the tweets and where they came from.

The following is a built-in model:

In addition, the team used online access data on the NORAD Santa tracker website to count global data before Christmas Eve. Start by using power query's online search, Count global site access, then import into Excel to create a data model, and display recent access through power view.

Here are the results from the analysis:

The most concerned about our Santa Claus country in the last seven days from highest to lowest in order: The United States, the United Kingdom and Canada, but surprisingly, little Japan's attention to it is actually ranked four, on Christmas Eve closer, people all over the world will be more and more attention to this site, at Christmas, There will be 150w to 250W visitors from all over the world.

The attention of Santa Claus is all over the world. So far, the most popular message on tweets is "Saw Santa", followed by "Santa sighting," and through the heat map below, it's not hard to see that the most popular concerns are North America and Europe, and that information comes from the Arctic region. Haha, the polar bear is expecting Santa Claus, too. Expect Santa Claus to bring them gloves, haha.

Finally, we look at the sound of the victor, 12% of people do not seem to like Santa Claus, so, not all people like Santa Claus, Holiday, Santa Claus to these 12% gifts will be doors it?

In fact, this blog only a few of the Excel report for a simple analysis, there are many reports in the middle, let's enjoy it together.

This is an analysis of the content posted on Twitter, first of all to classify the content, specifically how to classify and how to judge the content of the release, it is unclear. By the proportion of the analysis, see out, 12-24 days the release of information is the most, in the release of the content of "SPODERMENPLS" accounted for larger. In the heat map, people in North America have a sizable share of the content, look at China, seemingly no, no wonder, a Facebook and Twitter are difficult, not to mention the message? If QQ to publish the data, you can refer to the reference.

The following chart is an analysis of the people who play Twitter.

Twitter summary overview Analysis, see the map of the radar, a bit strange ah, foreign people, like to play Twitter at noon, haha. The lower right corner of the figure, you can see out of 2 years ago, foreign people play iOS is quite popular, if it is now, Android and iOS is what kind of a proportion? Unfortunately, there's no new data, huh?

I wish you a happy holiday in advance!!

Translated original address: http://blogs.msdn.com/b/powerbi/archive/2013/12/20/happy-holidays-from-power-bi-part-1-where-s-santa-now.aspx

Let bi tell you: Where's Santa Claus?