This is a log of what I explore and learn.
The query keeps cropping up very often while I work with customers. There are many ways to handle it. I will list down all approaches available as of now along with the pros and cons.
Power Query is undergoing rapid enhancements based upon feedback received from users. On 29th May another new update was announced.
If you are using Power Query, please update it to get new features. Download it from here. The version number of this update is 2.12.3660.142
This is a common activity. Go to a browser page, find some tabular data or report and copy-paste it into Excel. Now you waste a lot of time cleaning up the unwanted things which also got pasted.
If you have Excel 2010 or above (Professional Plus or Office 365 edition),
you have a miraculously simple method available now : Power Query…
This is a continuation of a series on how to convert badly formatted data into an easy to analyze – tabular format. In this article, we are talking about data which has gaps and how to fill gaps efficiently. This is a new approach available using Power Query – it is fast and effective. Have a look and save hours of your precious time.
Immediate action required. Control Panel – Windows Update – Check for Updates. Adobe also released important patches.
Also update Power Query – the Excel add-in which helps you get and clean data. Many new features and enhancements are added…
In an 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.
Read the the article Consolidating crosstab data before reading this article.
In this article we understand how we can use Multi-column, Row Heading Cross Tab data consolidation using Power Query.
In this article, we continue to explore the powerful text search capabilities of Word for WhatsApp Chat Analysis . In the last article we saw WHERE to search. This time we will see HOW to search.
Well, while we are on the topic of WhatsApp Group Chat Analytics , 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.