Data Centre Racks in #Visio in #PowerBI

I have often diagrammed rack and cabinet layouts and elevations using Visio linked to a database or Excel tables. There is a Rack Diagram template in Visio which is great for manually creating cabinet elevations manually, but there is nothing currently out of the box to automate this process, so it can be a laborious task unless you have some custom code. It is quite simple to draw a computer room layout of the racks and cabinets and to link each one to a row of data. In this article, I have a table of rack equipment in Excel, and used PowerQuery in PowerBI to summarize these rows for each data center, rack and U height position, since there are sometimes more than one item of equipment per U height. In this example, I have color coded the criticality of each equipment such that the most important display as red, and the least important as green. This means that a PowerBI user can quickly see where the critical racks, U heights and equipment are. Of course, I could have used any metric, such as power consumption, heat output or humidity, for the colour-coding. It all depends on the data available, and the audience for the report.

This slideshow requires JavaScript.

I used the Visio custom visual for the data centre floor plans because it is so simple to map PowerBi data rows to the Visio shape text or selected Shape Data values. However, I experimented representing the rack elevations in two different ways, so that I could test the difference.

For one test, I used the standard Microsoft matrix custom visual to arrange the U heights vertically with the highest equipment criticality of the equipment at each U color-coded.

For the second test, I used the preview Visio custom visual of a blank rack elevation with just coded rectangles for each U height. I could then link the rack equipment summary data for each U height to each rectangle automatically, and color code the highest criticality again. I think the visual is more pleasing than the matrix, and of course I can zoom in on the graphic.

Well this was my experiment in creating a visual interactive report for data centres. The data can be maintained in Excel or another data source, and the rack elevations do not need to be maintained manually. Of course, the rack elevations are not using the near photo-realistic shapes that some third-party vendors offer, but it does focus the attention on the data, which is, after all, the whole reason for the report in he first place!

You can play with the experiment at Link to PowerBI example



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


O365 and SharePoint

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query

Azure Solutions for Office 365, and more...

Rob Fahrni



Life with Visio and other Microsoft Toys!

Nilsandrey's Weblog

Just another weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Smart graphics for visual people

%d bloggers like this: