If you use LinkedIn and post lot of stuff, you will like this post. It shows how to analyze the effectiveness of your posts. This feature is around since June, 2013. But there is one feature within it which is so hidden that it is not noticed by most people.
Read on to find out…
earlier article, we discussed how to analyze FaceBook posts using Excel. Now let us see how Twitter data can be analyzed. This article explains how to analyze your own twitter handle data. Usage Scenarios: Product specific handles, Corporate handles, brand launches, events, live seminars, customer feedback and so on.
Analytics, Marketing, Pivot Tables, Power BI, Power Query, Power View, Social Analytics, Twitter. Tagged
Analytics, Excel, Marketing, Power BI, Power Query, Power View, Social Analytics, Twitter
This is a post for developers or those who know PowerShell Scripting. To understand the context, please read these two posts… This article and the code is contributed by Raj Chaudhuri – my friend and Microsoft platform expert.
WhatsApp Chat Analysis using Microsoft Word
WhatsApp Chat Analysis using Microsoft Word – Part 2
Well, while we are on the topic of data cleaning and analytics, here is another interesting article. In fact, this article also falls under the category of “What did I Learn Today?”.
Like many of you, I am also a part of many WhatsApp groups. I wanted to check how the chat transcript can be analyzed. Here is the process I followed using Power Query and Excel.
Analytics, BI, Excel, Power Query, Power View, Social Analytics. Tagged
BI, Big Data, Excel, Power BI, Power Query, Power View, Social Analytics
In few minutes you can analyze any public FB page data.
Here we see how to analyze the likes and comments – instantly.
You need Excel 2010 or Excel 2013 (Professional Plus edition) or Office which is installed from Office 365.
Close Excel if it is open
Download a new, extremely powerful tool Power Query for Excel
Install the tool
You should now see a tab called Power Query
Open Power Query tab and open the From Other Sources dropdown
me and Statuses (you can choose other types as well)
Remember that you can type any username or object id which has information accessible to you
Sign in to your Facebook account
Save the credentials
Now it will open a query result window and extract status update information from FB
At this stage it shows few results. Later it will fetch all possible results.
Keep the columns Message, Updated Time, Likes and Comments.
Remove other columns by right clicking on each column and deleting it
Now we want the count of likes and comments
As of now, both show Table.
Notice the small icon next to the Likes and Comments column headings
Click on that icon and do the following for Likes and Comments
Choose Aggregate and Count of ID
Now the Column shows count
The date time column contains locale information. We want a simple Date Time column.
Right click on the Updated Time column and choose Date Time
On the right side pane, expand the Steps area
Notice that all the steps you performed are remembered.
Click the Done button
Wait for data to be fetched
Now you can use this data in a Pivot Table or PowerView to analyze the FB data easily
This is a PowerView chart of one FB site
Here is another one as a PivotChart based upon another public site
Enjoy… Now you can do sophisticated FB analysis without knowing any programming, FQL or Graph API syntax. Explore Power Query.
It has a very
powerful syntax. Yes it is complex but it is extremely powerful. We will cover more of Power Query, Power View and Power Map in future posts.