Skip to Content

Introduction


With this quick blog I am explaining how to implement a supplier rating application using the Text Analysis capabilities of SAP HANA. I am using Sentiment analysis feature to rate a particular product and suppliers based on the customer feedback on various web sites .

Assumptions

We have the customer feedback collected from suppliers and arranged in the following format. (data is copied from multiple online suppliers. Product names and supplier names are masked )

data strucure.JPG

Modelling your source Table

     Now we need to load the data into SAP HANA. For that, We are creating a table of the same structure .

Query.JPG

After once the data is loaded into the source table, we are creating a full text index on the table for the FeedbackText column using the standard configuration “EXTRACTION_CORE_VOICEOFCUSTOMER“.

Voice of the customer content includes a set of entity types and rules that address requirements for extracting customer sentiments and requests. You can use this content to retrieve specific information about your customers’ needs and perceptions when processing and analyzing text. The configuration involves complex linguistic analysis and pattern matching that includes processing parts of speech, syntactic patterns, negation, and so on, to identify the patterns to be extracted.

Once the index is created , one new columnar table will be created in the same schema where the source table is created. This table will be having the tokens as well as the corresponding sentiments values .

Tree.JPG

Now generating some visualizations on the generated sentiment data.

Analysis.JPG

SAP Lumira For Reporting


Now we have the sentiment data available in our table. That means, we have the product details, Supplier details, and the type of feedback given by the customers . Now we will generate dashboard(Real time dashboards on LUMIRA if we integrate it with live feedback data on multiple web sites) .

Pie Chart.JPG

And I love this part 🙂

I love this part.JPG

(This blog is created for DataGeek ).

Sreehari

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply