Forum Discussion

arun2001mjl's avatar
arun2001mjl
Helper II
4 years ago

Text Analytics using Machine Learning Python Script in PowerBI

Hello All,

 

I have a 2 sets of Raw Data as Training Data and Test Data.

 

In PowerBI... I have uploaded a Raw Data with the File Name "Training Data" with the following Columns:

Ticket Number, Status, Short Description, Category, Open Date, Resolved Date.

 

Category was created manually based on Short Description Column.

Ticket NumberStatusShort DescriptionCategory(Manually Updated)Open DateResolved Date
Ticket 1OpenUser Account LockedAccount Unlock12-Apr-2212-May-22
Ticket 2ResolvedUser Need Password ResetPassword Reset12-Apr-2212-May-22
Ticket 3ResolvedServer AAA Down several timesServer Restart12-Apr-2212-May-22
Ticket 4ResolvedPlease Unlock user accountAccount Unlock12-Apr-2212-May-22
Ticket 5ResolvedReset VPN pinReset Pin12-Apr-2212-May-22

 

Every month, to avoid doing this Manually.. I need to Train the old data and bring this Category in new set of data which will be uploaded in PowerBI.

 

Can we Train the old model and update the Category in new data in Powerbi using Machine learning/Python Scrips. 

 

If anybody has Sample PBI file, pls share it or please advise on above.

 

Regards

Arun

3 Replies