MicroStrategy 2020 Update 1 continues to expand on our open strategy by integrating deeper into the Microsoft technology ecosystem. It continues to deliver strong enterprise capabilities that raise the bar for security, performance, and scale. And it adds new modern experiences that deliver predictive caching and actionable mobility to end-users.
In part one of our three-part MicroStrategy 2020 Update 1 blog post series, I focused on the new actionable mobile capabilities in Update 1. In this post, I want to give you some more detail on how we’re further embracing Microsoft as part of our unique open strategy.
Dossier Import Integration in Excel
We all know that the most popular analytics tool in the world is still Microsoft Excel. That’s why MicroStrategy's our open architecture encourages users to keep using the tools they know and love. And with MicroStrategy 2020 Update 1, MicroStrategy for Office now offers even richer functionality along those lines.
We've now made it possible to import data from a MicroStrategy dossier into Excel. This is great because, prior to this feature, users could import the objects defined in a data set (often defined by IT and experts). But dossiers are built by business users, and those business users usually add new attribute and metric definitions specific to their business scenarios. The ability to import from Dossier allows Excel users to leverage these additional definitions created by Dossier/business users. In a nutshell, this means that both IT-created data definitions and user-created definitions can now be easily imported into Excel while preserving data security, consistency, and the ability to refresh. Here’s a demo:
Certification of the Power BI Connector
The second thing you’ll see in Update 1 is that we’ve certified the Power BI connector, so that it is now available directly from within Power BI. You can just go into Power BI Desktop, add the connectors, and you're good to go.
This supports SAML/SSO and Badge authentication. You’ve also got the ability to import multi-form attributes, as well as connect to prompted reports with default prompt options. Here’s a quick demo of what to expect when you go into the Power BI interface:
Backup and Restore on Azure
Finally, on the MicroStrategy for Azure front, we've added backup and restore capabilities. For anyone trying to use cloud to deliver and deploy analytics, portability makes it easy to move between platforms and create new environments. This allows you to seamlessly upgrade, clone, or backup environments between AWS, Azure, and on-premise.
With this and other features, we continue to embrace Microsoft and other solutions, so that our customers get the enterprise capabilities they want and need, without having to choose just one solution.
With this MicroStrategy 2020 update, we continue to optimize our platform for the enterprise and to help our customers make faster, smarter decisions based on data they can trust—whether they're at their physical workplace or working remote. Enterprise-wide integration, security, and scalability has never been as important as it is today. My next post will talk about new enterprise features in Update 1. Stay tuned and take care.
If you’d like to see more details on Update 1, visit our “What’s New” webpage or watch our Update 1 webcast where you can see more new features for MicroStrategy for Office. You can also read more about the broader MicroStrategy 2020 release highlights. And don’t forget to take a look at and take advantage of some of the resources we’re offering our customers as we all adapt to a new business normal. Check out our Virtual Symposium Series and our free support offer for those customers wanting to upgrade to MicroStrategy 2020.