Introduction

Microsoft Power BI is a great tool for creating dashboards and documentation. Even better, Power BI Desktop is freely available. Anytime you want to do visualizations or analytics that go beyond the capabilities of OTbase Inventory, Power BI is therefore worthwhile exploring.

In this example we have created a dashboard for vulnerability analysis, based on data provided by OTbase. Believe it or not, but creating such a dashboard from scratch will take you little more than 30 minutes. The best thing is, it's fully interactive and you can really explore your vulnerability landscape.

The same is true for other aspects of your OT infrastructure such as obsolescence management, documentation of outdated software products, and more.

While you can in principle move data from OTbase to Power BI without additional tools (by exporting to Excel tables as an intermediate format, for example), the OTbase Connector for Power BI greatly simplifies the job. It also allows for more complex analytics because the level of detail it provides goes beyond what you can export as Excel tables.

Video

The following video gives you an impression how easy it is to create impressive dashboards in Power BI once that you loaded OT asset data using the OTbase Connector for Power BI.