Natural Language Generation Made Easy with Alteryx

[AlteryxAdvocacy]

Author:

Sufeng Li

Role:

Robotics Product Owner

Company:

A Dutch Insurance Company

Overview of Use Case

With over 5 million private and business clients, this insurance company is one of the largest financial service providers in the Netherlands. It offers a complete range of products including insurance, pensions, savings, mortgages, investments and loans. Learn in this use case how their finance department used Alteryx to execute their Natural language generation (NLG) project to transform financial figures into analytical reports.

Describe the business challenge or problem you needed to solve

 “Every month our finance colleagues need to write an executive summary of the monthly operating results. They need to download dozens of Excel files from our ERP system, look into the correct cell for the figures, then analyze the figures and share some highlights with the management”, Sufeng Li, Robotics Product Owner.

Sufeng and his colleagues were spending 4 working days every month to prepare the executives summary. After analyzing the figures, they created visuals on PowerPoint that had 50 slides. Sufeng has been using Alteryx for the past 2 years and the finance department has 22 Alteryx users. Their goal was to make their computers read, decipher, and understand the financial figures in the Excel spreadsheets to make sense of the human languages in a manner that is valuable.  

Describe your working solution

1. We used iteration macros to read all the input files with different schemes. One input is the report template and the other input is data. We named the macro Ara, a type of parrot.
   
   
2. Data cleansing and merge to Excel
3. Searching for the target data using the labels defined in the input template

4. Generated the analysis to Excel. The output are sentences

5. Visualize the data in Power BI

Describe the benefits you have achieved

1. For the PoC project, one-week workload is saved by this tool. This time-saving happens during the month closing time-critical period.
   
   
2. Potential saving can be foreseen by applying this tool on other similar reports.

[PI]

Sound like a great use case. Is it possible to receive a higher quality version of your model?

[AlteryxAdvocacy]

@PI Thanks for reaching out! Looping in @sufeng  as he is the owner of this marvelous use case! 

[TarunDeep]

This is a fantastic use case. Please share a high level workflow/ working model if possible!! @sufeng @AlteryxAdvocacy 

[Ayushii1306]

can anyone share this workflow urgently?