Note: These projects may not be ready to be used in your production environment as some of them are in Beta/Experimental stages and their support/development may be deprecated in future.
Thanks: I thought of writing this blog post after a discussion I had with Parth Acharya about Google and it’s projects for Data Professionals. He pointed me to some of the most interesting samples that used Google Fusion Tables and here’s his one of the blog post on related topic: Google Fusion Table & Data Visualization
I like to keep an eye on Technology Trends. One of the ways I do that is by subscribing to leading magazines for articles – I may not always read the entire article but I definitely read the headlines to see what Industry is talking about. during last 12 months or so I have seen a lot of buzz around Big Data and I thought to myself – It would be nice to see a Trend line for Big Data. Taking it a step further, I am also interested in seeing if there is a correlation between growing trend in “Hadoop” and “Big Data”. Also, I wanted to see how it compares with the Terms like Business Intelligence and Data Science. With this, I turned to Google Trends to quickly create a Trend report to see the results.
Here’s the report:
Here are some observations:
1) There’s a correlation between Trend of Big Data and Hadoop. In fact, it looks like growing interest in Hadoop fueled interest in “Big Data”.
2) Trend line of Big Data and Hadoop overtook that of Business Intelligence in Oct 2012 and sep 2012 respectively.
3) Decline in Trend line of Business Intelligence.
4) There seems to be a steady increase in Trend line for Business Analytics and Data Science.
Some time back, I wanted to search one of my own social network post. It was a resource I had shared and somehow I was not able to “google” it (again). I eventually found it – but it took me 15 odd minutes to scroll down to my twitter feed. It was NOT fun! And I thought to myself – there’s got to be a better way! And I thought – It’ll be great if I solve it for not just Twitter but all my social network activities that includes LinkedIn, Facebook Pages, Google+. So here’s couple of things thats working for me, I hope it helps someone out there too:
Now, before we begin when I say “Searchable” – I mean searchable by YOU (or a human being) and not necessarily search engines. But it turns out, both my ideas increase your chances of getting your social media activities Indexed! With that, Here are the ideas:
1) Syndicate your Social Network Activities (Posts/Images/Updates) to Tumblr/Blogger
I use IFTTT to syndicate my Twitter, Facebook and LinkedIn activities to Blogger
2) Create a post about your social network activities on your blog:
Though Idea #2’s main goal is to keep my blog readers updated about my social network activities – But it also acts as a good way to make my social media posts “searchable”.
And remember I said earlier that the chances of your social network posts getting indexed by search engines increases? That’s because WordPress, Tumblr & Blogger’s posts are accessible by Google (unless you choose to block it). So that’s about it for this post. If you like the idea(s), please let me know! And if you have other ideas – also let me know, I am always looking for ways to make my social media activities easily searchable to me as well as for anyone else.
Let’s connect and converse on any of these people networks!
This seems like a great way to visualize where your fans are from. In my case, most of them are from India and so one actionable insight would be to schedule posts based on Time Zone in India. And I can imagine that such reports could be very helpful to brands who have sizable fan following on Facebook.
Here’s the screenshot:
Thanks to the following blog-posts for inspiration:
Recommendation systems is application of Data Mining Technologies. I have researched about how to implement a recommendation system and as a part of my research, I studied recommendation systems that are already out there on the Internet and here are five examples of Recommendation systems on the web:
Customers Who Bought This Item Also Bought:
Frequently Bought Together: (Example of Market Basket Analysis a.k.a Association Rules):
Jobs you may like + Groups you may like + Companies you may follow:
Did you knew about Netflix Prize for improving their recommendation engine? If not you should read that!
Here’s their Movies you’ll love recommendation system:
People you may want to follow:
I do not have a screenshot but just wanted to point out the Google “personalize” (a.k.a recommends based on past behavior) search results based on your search history. And you can switch that off, if you want: Turn off search history personalization
In this blog-post, we saw examples of recommendation systems. The key take away is that there is more than one approach to building a recommendation system. The approaches can be based on 1. Past Behavior 2. Past Behavior of “friends” 3. Recommendation based on the Item that is being searched And you can definitely, Mix and Match!
And I hope this post helped you understand an application of data mining that’s all around us! And question: Where else do you see recommendation systems in action? Leave a comment!
“Without Stackoverflow, 50% of the developers cannot continue to be developers and without Google, 80% of the developers cannot even claim to be developers!”
Status update: “I just worked on a SQL Server 2012 Master Data Services Tutorial where I learned how to 1) create a new Model 2) Use MDS Excel Add – In to load entities to the model 3) use Master data manager web app 4) add a new member via MDM web app 5) And create a subscription view to retrieve entity members. if you want to do learn that: search for “SQL Server 2012 Developer Training kit“. Awesome resource!”
I analyzed my Past Year’s Web Traffic Data: Here’s the Insight: Traffic on Weekdays > Traffic in Weekends. In most cases, Traffic on Weekends drops by 40%!
In other Words: Not as many people read BLOGS on weekend as much as they do on Weekdays.
What Can you do with this insight?
> First, Verify that it’s true for your domain/field-of-expertise. I blog about Technology and so this insight is applicable to blogs like mine.
> If you plan to blog say Twice in a week. Schedule those Posts on Weekdays (instead of weekends)
What Data did I analyzed:
– WordPress.com site stats
– Google Webmaster Tools search queries report. This gives you the number of searches that include your “blog post” as one of the result. Here’s what it looks like:
Seems people are not searching for Technical content during Weekends. And less folks searching for “content” on Search Engines means Less Traffic (& less EyeBalls).
For my Blog, The Traffic Drops by 40% on Weekends. And that just means that lesser number of people are “listening” on weekends. Since I do not have a “schedule” for this blog yet – I would try to post things on weekdays instead of weekends. That’s what I would do – What would you do with this insight? Do you see the same Traffic pattern for your Blog?
I figured a way to add External Links to my Facebook Page – In this blog-post I’ll share how I did that. It’s not a native feature and I have resorted to a third-party app to get this functionality. Here’s the Blog-Post:
This is how my Facebook page Tabs looks after I completed the process.
You can see it is linked to my Blog, Twitter and Google+ from my Facebook page tab.
Before we start. you should have the proper admin permissions to install app to a Facebook page as we are going to use a third-party app for this blog-post. Here are the steps involved:
2) select the Facebook Page and click on add page tab
3) Authorize Tab application (review the permission requests before agreeing)
4) Can you see the Tab Settings Page?
*NGO XYZ is just a page that I created to show this. Ignore the phrase when you see that.
5) I want to redirect it to say twitter.com/paras_doshi.
So following are the settings that I chose:
Tab Name: Twitter
Page Source: redirect
And I entered the URL that It will get redirected to:
6) I am going to leave other choice as default for now. You could explore it for advanced options like “this tab will only be visible to your fans and invisible to your non-fans” among other things.
click on Save Settings.
7) Can you see the new tab?
8) Test it!
9) Come back on your page. Now – Don’t you want to change the Image? Yes? Go to Edit settings for this Tab:
10) click on “change” for custom tab image. And Now, upload the custom image.
When done – come back to your page. Can you see it? yes? Great!
11) To add more Tabs. click on this tab as “page administrator”
when prompted about “Do you want to be redirected?”. click on cancel
click on settings from the admin tab options.
and another tab:
Limit seems to 10 tabs.
And once you click on “HTML Page Tab #n”, then you’ll have to repeat the steps about configuring the settings for this tab.
That’s about it!
If you want your Facebook page to point to your (or your organizations) presence on other social media networks – then now you know how you can add external links and point your Facebook page fans to Google+, Twitter, Website, Blog among other things.
Are there any other cool facebook page techniques that you now of, I’ll be glad to learn about it – Please do post it in the comment section (along with your facebook page url! )