Skip to content

TechRepublic

  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Cloud
  • 5G
  • Big Data
  • TechRepublic Premium
  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Cloud
  • 5G
  • Big Data
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
CXO

The 10 best ways to visually represent IT data

By Rick Vanover April 21, 2011, 11:55 PM PDT

Image
1
of 10

10_best_ways_to_visually_represent_specific_kinds_of_data-FigA0.jpg
10_best_ways_to_visually_represent_specific_kinds_of_data-FigA0.jpg
The 10 best ways to visually represent IT data

ntIn all areas of IT, there are a number of situations where certain ways of presenting data, configuration details, or a sequence of events work best. We often tend to rely on one tool for everything because we’re familiar with it, but that isn’t always the best approach. Here is my top 10 list of the most effective ways to visually represent IT data.

n

ntNote: This gallery is also available as an entry in our 10 Things blog and as a PDF download.

n

nt1: Network connectivity — Microsoft Visio

n

ntI’ll admit that one of my nicknames over the years has been “Kid Visio.” Visio is a capable tool for documenting network connectivity. It’s not the right tool for documenting the configuration, but it does a good job of outlining the logical layout. From a top-down perspective, I feel Visio does this best. This figure shows a sample network diagram that clearly shows the logical layout of the network.

The 10 best ways to visually represent IT data

nt2: Application layout and architecture — Microsoft Visio

n

ntLet’s face it: Applications can get complex today. Virtual machines, replicated databases, firewall configurations, virtual IP addresses, mobile applications, and more make documenting an application flow no easy task. Again, I’ve found Visio to be the tool that reigns supreme. In this example, many complicated aspects of the infrastructure are represented visually in one flow. While it doesn’t address the details of aspects such as the database replication, it is a good springboard to those other areas of key content.

The 10 best ways to visually represent IT data

nt3: Free disk space — Pie charts

n

ntI’m not a fan of pie charts, but they do the trick for representing free space on a disk. This can be Windows drives as well as critical volumes, such as a VMware VMFS datastore or a drive on a SAN. The pie chart is a veteran at representing free space, and this example shows its effectiveness for this application. But take a pie chart with a grain of salt. We need to visualize how much drive space is used as well as how much free space is available.

The 10 best ways to visually represent IT data

nt4: Year-over-year performance tracking — Excel 3D bar charts

n

ntFor tracking performance year over year for a moving target, I find that the 3D bar charts within Excel do a good job of showing the progress. It doesn’t have to be year over year, either; it can represent quarterly assessments or even a comparison of something, such as different offices. In my work experience, I created a simple 3D bar chart within Excel that looked something like this one to track progress moving to virtual machines from physical servers.

The 10 best ways to visually represent IT data

nt5: Consumption compared to other like entities — Excel Bubble charts 

n

ntQuickly visualizing the consumption in proportion to other like consumers is easy with the bubble chart. One common example is representing the number of servers (or PCs) in a given location, whichthis bubble chart does well. But it’s important to note that there is a significant limitation with the bubble chart: It assumes that all items are equal consumers. A good example would be 100 file servers compared to 100 Oracle database servers. In most situations, the file servers require much less maintenance and resources than the database servers. Nonetheless, the bubble chart is effective in displaying numbers by category.

The 10 best ways to visually represent IT data

nt6: Performance reporting — Line graphs

n

ntThe line graph is a good way to represent direct consumption. A number of tools utilize the line graph for this function, including the VMware vSphere Client, shown here.  But the line graph also has a limitation: If the tool displaying the consumption does any normalization of data, there may be missing highs or lows. To be fair, when there is so much data to manage, normalization of performance data is a common occurrence.

The 10 best ways to visually represent IT data

nt7: Step-by-step procedures — Camtasia Studio

n

ntWhen it comes to showing something onscreen, the de facto standard for recording the activity for replay is Camtasia Studio. Camtasia has all the features you would want, including voice overlay and easy uploads to popular sites such as YouTube.

The 10 best ways to visually represent IT data

nt8: Topics in outline form — Microsoft PowerPoint

n

ntThere are a number of strategies for creating and delivering PowerPoint presentations (and presentations in general). But PowerPoint is especially useful for creating an outline that can be conversationally discussed. I’ve learned a few tricks over the years: Never have a presentation go longer than 59 minutes and 59 seconds; don’t cover more than three main topics per slide; and make the outline focus primarily on the problem, which you can then backfill with the solution.

The 10 best ways to visually represent IT data

nt9: Customized maps — Microsoft Visio

n

ntVisio has map stencil objects (Figure I) you can use to document all kinds of things, such as assigning territories within a business and mapping out network and datacenter connectivity. You can download the map stencils from Microsoft (click the Find Shapes Online option). A U.S. stencil and a world stencil are available for modern Visio versions.

The 10 best ways to visually represent IT data

nt10: Specific data sets — Webdesigner Depot

n

ntThis awesome resource has a number of links to tools that provide specific visualizations of things such as Internet trending topics and the Internet as a whole, as well as images of an event or even the history of science. This figure shows a good way to visualize current events on the Internet using Web Trend Map 4. The popularInfographic series is also a great resource that will inspire new ways to present data in an interpretable manner.

  • CXO
  • Account Information

    Share with Your Friends

    The 10 best ways to visually represent IT data

    Your email has been sent

Share: The 10 best ways to visually represent IT data
Image of Rick Vanover
By Rick Vanover
Rick Vanover is an IT Infrastructure Manager for Alliance Data in Columbus, Ohio. Rick's IT certifications include VMware VCP, Microsoft Windows Server 2008 MCITP, Windows Server 2003 MCSA and others. \ \ Previous experiences included working for De
  • Account Information

    Contact Rick Vanover

    Your message has been sent

  • |
  • See all of Rick's content

TechRepublic Premium

  • TechRepublic Premium

    Checklist: Network and systems security

    Cybersecurity demands and the stakes of failing to properly secure systems and networks are high. While every organization’s specific security needs form a unique and complex blend of interconnected requirements, numerous security fundamentals almost always apply to each of these groups. It stands to reason that cybersecurity pros who effectively identify network and systems risks ...

    Published:  June 1, 2023, 4:00 PM EDT Modified:  June 2, 2023, 7:48 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    How to host multiple websites on Linux with Apache

    In this guide from TechRepublic Premium we’re going to explore the various things you can do with a Linux server. We won’t leave out any steps, so you won’t have to refer to another tutorial to complete the process. The only step we will leave out is the installation of Linux, as we’ll assume you ...

    Downloads
    Published:  May 31, 2023, 4:00 PM EDT Modified:  June 1, 2023, 7:45 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    How to deploy an application with Kubernetes

    If you want to deploy applications into a Kubernetes cluster, be warned — it’s not the easiest task. There are a lot of moving pieces that go into these scalable containers. Don’t you wish you had a complete roadmap, from start to finish, to walk you through the process of deploying the Kubernetes cluster, deploying ...

    Downloads
    Published:  May 31, 2023, 4:00 PM EDT Modified:  June 1, 2023, 7:51 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Cross-training tool kit

    The more flexibility you can create in your technology workforce, the better you’ll be equipped to manage tomorrow, whatever the future brings. Too often, we focus on helping our teams become technical specialists who know volumes about a single technology, but quickly lose sight of how that technology connects with others. This makes their skills ...

    Downloads
    Published:  May 30, 2023, 4:00 PM EDT Modified:  May 31, 2023, 4:50 PM EDT Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice