Exclusives

MicroStrategy: Why Workstation is Such a Powerful Data Tool

During the webinar “Workstation: Your Administrator’s Powerhouse” on July 12, MicroStrategy experts explained how companies can accelerate their productivity across multiple workflows.

The MicroStrategy Workstation tool allows users to administer and control environments and projects, offering tools to aid in data discovery and visualization. Workstation centralizes and simplifies how users build and deploy analytics, according to the company.

From application design, schema development, data wrangling, environment management and monitoring, content distribution, and automated workflows, Workstation “puts it all at your fingertips, in one place,” according to the company.

During the webinar, the third in MicroStrategy’s Best of World 2023 Webinar Series, the firm’s experts explained how Workstation users can enhance the impact of their organization’s dashboards 100x with transactions, driving direct action from insight; transform underutilized assets and connect them into applications via contextual linking; and leverage the increasingly popular Python programing language, integrated as part of MicroStrategy’s automation layer.

“What is interactive analytics? Interactive analytics allows users to explore and manipulate data using interactive visualization,” said Erika Moreno, product manager at MicroStrategy, who leads the company’s team in charge of augmented analytics and artificial intelligence (AI).

She explained that the advantages it provides include “greater flexibility” and the ability to get “faster insights to your data and make better informed decisions.”

She went on to provide examples of what can be done with these capabilities, saying the company’s Transaction Services “will allow you to augment your data and it’s very easy to configure…. The only thing that I had to do is have a modern grid already prepared for me. I had the driver … and so on.”

She added: “I had three different things to consider: I can do an update, an insert for a delete, and then I will have to just select which data source I need and start selecting the table and the columns that I need. As soon as I select the table, it will prompt me to select the columns that I want and then map those columns into attributes and metrics that I already have on my grid.”

Depending on where you are, if it’s an update or an insert for a delete, are the options that I will get…. There are a lot of things that you can play with for these options.”

And once you have the configured transaction, she said, you may “want to take it up a notch and you can even have ‘what if?’ scenarios.”

Concluding her presentation of the webinar, she provided “key tips” for those using transactions:

  1. Use a modern grid.
  2. Check the source of the fields for dropdowns.
  3. Ensure that the fields required for the update statement are properly marked.
  4. Take advantage of the live data or datasets without caching to instantly refresh your data.

To view the entire webinar, click here.