Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Text Analysis in Excel: Real-World Use Cases

DZone's Guide to

Text Analysis in Excel: Real-World Use Cases

Read on in order to learn more about the Excel add-in and how you can use it to maximize productivity in different tasks.

· AI Zone ·
Free Resource

Insight for I&O leaders on deploying AIOps platforms to enhance performance monitoring today. Read the Guide.

Recently, we successfully completed beta phase of ParallelDots Excel add-in, a solution for using ParallelDots NLP APIs to do text analysis on unstructured data without writing a single line of code. The Excel add-in is very easy to use and provides a convenient yet effective solution for your text analysis needs. In an earlier post, we provided you with detailed information of how the excel add-in works. In this post, we will discuss some real-world use cases where you can use the Excel add-in to raise your analytics game without spending a fortune on building a data science team.

Text Analysis of Product Reviews From E-Commerce Sites, Facebook Pages, and Other Review Sites

You can analyze a corpus of customer reviews to understand the general impression of your product. The Excel add-in works on ParallelDots AI APIs, which are being used extensively by developers and enterprises to empower their analytics since the last two years.

Excel Text Analysis

Furthermore, you can run keyword analysis on positive and negative sentiment sentences to discover why people like or dislike your product. Such an analysis will enable you to understand the key phrases contributing to the overall sentiment around your product. For example, a phone manufacturer company can analyze reviews from e-commerce sites, social media, and tech review blogs for their models. They can then extract keywords for both positive and negative sentiment sentences to find which features (screen, battery life, camera, storage, etc.) users liked or disliked about a particular phone model.

Additionally, you can go a level deeper by analyzing the intent of the product reviews and categorize them to identify whether the review counts as the feedback, opinion, query, or spam. This will help in filtering essential reviews and replying/acting on them faster.

The analyzed data, i.e. sentiment, keywords, and intent, can be correlated with your internal business metrics such as marketing spends, sales data, etc. to find actionable insights.

Analyse Open-Ended User Feedback From Surveys

Open-ended feedback forms have proven to be more useful than close-ended ones (folks at our market research division, Karna AI, have written an extensive blog on analyzing open-ended user surveys. You can read it here) but analyzing them can be very time-consuming and an expensive task.

Our Excel add-in is a lifesaver when it comes to analyzing open-ended surveys. Once you have exported all the survey responses in XLSX or CSV format and installed the add-in, you can start analyzing the responses straight away without writing a single line of code. The Excel add-in makes it simple for anyone and everyone to perform AI-powered text analysis.

Excel Text Analysis
A sample response of an open-ended survey and analyzing the sentiment of keywords.

The methodology can be same as the one mentioned in the product reviews analysis, and you can incorporate entity extraction function along with keyword analysis to discover broader entities (product name, person name, etc.) talked about in the surveys.

Text Analysis for Financial Content

Financial data such as earnings calls, news articles, transcripts, etc. contain a lot of rich information, which can form the basis for your fundamental investment and financial research. The BFSI sector is heavily equipped with textual data.

Excel Text Analysis
Analysing financial data

Since excel remains an integral part of any financial analyst’s toolkit, ParallelDots Excel add-in can help to correlate many of the structured data points found in financial documents (balance sheets, trading history, P&L statements) with those found in unstructured financial documents.

Analyzing Social Media Content From Your Social Listening Tool

While social listening tools do a good job of tracking every conversation about your brand or product on the internet, building good text analytics capability is only considered as an afterthought in most of these tools. The data from such social listening tools analyzed by a powerful text analytics tool like ParallelDots Excel add-in can provide a good overview of your social presence.

Excel Text Analysis
Analysing reviews and text on social media

Further, listening tools that do provide good text analytics capabilities can be an expensive tool to use when compared to the Excel add-in like ParallelDots.

These listening tools give a very convenient option to export all the conversations in CSV format. You can then analyze these conversations similar to product reviews to get actionable insights such as sentiment attached to the conversation, keywords and key-phrases mentioned, emotions detected in the conversation, entities mentioned, etc.

Empowering Business Analysts to Carry out Text Analysis on Unstructured Datasets

Business analysts capture, analyze, and document business needs and changes. A business analyst is usually equipped with huge textual corpus from different domains such as market research, financial data, historical viewpoints, etc.

Excel Text Analysis

ParallelDots Excel add-in can help analysts up their game since excel is heavily used in analyzing the data points in this sector. Business analysts can process the information faster using multiple functions from the ParallelDots Excel add-in. They can gather relevant insights such as extracting the entities, categorizing products, services, or markets based on sentiment, and classifying text based on the IAB categories etc.

The use cases of ParallelDots Excel add-in are not limited to the ones mentioned above. Essentially, you can use the add-in whenever you require processing a large corpus of unstructured textual data. It is super easy to use, just download the add-in, sign up for your unique API key, and start analyzing your content. Check out the documentation to learn more about the different functions available in the add-in.

If you use an operating system other than Windows, then please try our Google Sheets add-on which works the same way as our Excel add-in.

TrueSight is an AIOps platform, powered by machine learning and analytics, that elevates IT operations to address multi-cloud complexity and the speed of digital transformation.

Topics:
artifical intelligence ,excel add-in ,text analysis ,sentiment analysis ,emotion detection ,ai

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}