Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Maveryx Success Stories

Learn how Alteryx customers transform their organizations using data and analytics.
STORIES WANTED

Showcase your achievements in the Maveryx Community by submitting a Success Story now!

SUBMISSION INSTRUCTIONS

Natural Language Generation Made Easy with Alteryx

AlteryxAdvocacy
Alteryx
Alteryx
 
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.  
 
pic1.png

 

 
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.

    Capturar.PNG

     

  2. Data cleansing and merge to ExcelCap2.png

     

  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.

 

 

Comments
PI
5 - Atom

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

AlteryxAdvocacy
Alteryx
Alteryx

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

TarunDeep
8 - Asteroid

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