Narratives for MicroStrategy (NLG)
Date: Monday January 22, 2018
Natural Language generation (NLG) is one of the widely used
processes by most of the organizations to improve interaction with
customers and empower their employees. As a company, we decided to
explore this widely used process with one of our valued BI tools
MicroStrategy is an Enterprise Business Intelligence tool that helps
various organizations to analyze their data of any scale and create
interactive reports and dashboards and then distribute to their users to
make effective business decisions. It has a suite of tools for
developing, deploying and sharing reports and dashboards. It provides
multiple interfaces like web, desktop, mobile and also integrates with
Microsoft office. It has various other features like intelligent cubes,
optimizations for various databases and a highly secured environment.
While browsing through MicroStrategy forums we came across
“Narratives by Narrative Science” regarding an NLG plugin that is used
with MicroStrategy to allow for better understanding of the data.
Narratives help non-technical users better understand the data. This
feature generates rich text insights from the visualizations. Instead of
requiring users to interpret data on their own, Narratives help point
the users in the proper direction. This amazing feature establishes
better communication with both technical and non-technical users.
Utilizing the free trial version from MicroStrategy we executed the following:
- Download the narratives plugin from the below link https://community.microstrategy.com/s/article/Narratives-generated-by-Narrative-Science
- There are two ways to deploy the plugin in MicroStrategy:
- Navigate to MSTR web admin page, on the left side you have a custom
widget option click that and upload you zip folder and click the deploy
- Navigate to plugins folder (<Tomcat-home>/webapps/Microstrategy/plugins) and upload the extracted narratives folder.
- Send out an email to email@example.com and request an API key to activate the plugin.
API Key Activation
- Microstrategy support team will send the terms and conditions. Once accepted they will send the API key.
- To activate the API key, navigate to
- Open the js file in editable mode and hit Ctrl+F and type
“to-get-a-key-from-narrative-science” and replace it with the API key
- Once replaced, save the file and restart the tomcat server and the intelligence server.
- Now when MicroStrategy Web is opened click “create dossier” and the
narratives option in the list of customizations will be visible.
- The narratives plugin can only be used in MicroStrategy Desktop and Web.
- It is possible to use narratives only in visual insights.
- Not available for all kinds of charts and graphs, so it is limited to few visualizations.
- Data is shared with narrative science and stored in their server for
several days. So it wouldn’t work out if the client is particular that
their data cannot be shared.
- It might not work if the organization has strict firewalls.