i've a customer feedback text in sheet1,Column A. i've a keyword list and matching category in Sheet2 column A and B.
Example: Sheet1,Column A - The product is very good, user manual doesnt have proper information. Language from support center is not clear.
In sheet 2, i've info as follows...
i've assigned to create a excel dashboard, couple of interactive charts and business insights. There should be many filters included in the charts and reports
the data volume is so huge,like 200K rows, 121 columns.
please suggest what would be the better approach to develop this dashboard...