A new milestone for this blog — 500+ posts! To commemorate this, I decided to change the domain name from ParasDoshi.com to InsightExtractor.com — my goal was two-fold:1) provide an easy to remember name 2) representative of the work that we all do: we help extract insights from data.
Remember to subscribe to this Blog via Email or RSS.
As you may know, I have a Facebook page for this blog – only because NOT all my friends (on Facebook) want to follow my technology-related activities. But some of them are interested, and so I thought of setting up a Facebook page for the blog which helps those interested in following my twitter (micro-blogging) and blog feed via Facebook.
Now, Facebook provides a nice tool called “Facebook Insights” to view performance of the page, optimize content, among other things. A sample report looks like this:
I liked the way they have designed this “line chart” and I thought about what I can learn about “Art of report designing” from this nicely designed report.
The report makes it easy for us to “compare” these inter-dependent metrics.
4. The size of the circle depends on the “number of posts”. Very intuitive!
They could have easily opted for “other” formats but they opted for this and to me, it is very intuitive to interpret the report.
5. Horizontal Axis Format for Dates:
keeping the Interval to “7” looks better! It looks clean!
So, Those were my 5 favorite things about that report
Now, One can export the data too in csv and .xls format! That means, that you can create custom report on top on this data to answer any business question that you may have.
So for instance, I asked myself – Is there a relation between “number of posts i shared” with “People talking about it”. Although this question got answered via the sample report I shared earlier – But I wanted to extend it. Here’s why: The “number of posts” metric was reflected by the “size of the circle” and “people talking about it” metric was reflected in line chart format. Wouldn’t it be wonderful if both values were reflected on a line chart in a coherent fashion? I thought so, and so I downloaded the data on my computer and opened it in excel. And I was quickly created this line chart in excel:
Bingo! I learned that more I post on my Facebook page => more likes,shares I am going to generate. Now this is NOT a universal statement, it varies from page to page but at least, my data encourages me to post more on my Facebook page.
So that’s about it. In this blog post, I listed things I liked about Facebook insights and what I learned about “Art of report designing”. Then I extended the data made available to create a custom report on excel. After all, “Information is king“.