How to create a visual dashboard

In this video, we're going to have a bit of fun! 
 We'll create a visual security story. 
 
 
 
 
 
 
 
 
 
 Here's the scenario: 
 The operations manager, one of the stakeholders we previously discussed, has  been informed that the Chief Information Security Officer, also known as the CISO, 
 wants to know how many employees are often clicking on phishing emails. 
 The goal is to identify which five departments click on those emails most often. 
 An investigation reveals that the five departments that most frequently  click on phishing emails are: human resources, customer service,  global security, media relations, and professional development. 
 
 
 
 
 
 
 
 
 
 Based on this information, the security team can create a visual  representation of the data to share with the operations manager and the CISO. 
 Those stakeholders and  the security team can then work together to determine how to address the issue. 
 
 
 
 
 
 
 
 
 
 There are many different platforms available that can be used to create and  share visual stories of data. 
 Apache OpenOffice is a free, open-source office suite that allows users  to create spreadsheets and other visual representations. 
 
 
 
 
 
 
 
 
 
 Another no cost option is Google Sheets. 
 Today, we'll enter our data into Google Sheets. 
 Then, we'll create a bar chart visualization to develop the data story. 
 
 
 
 
 
 
 
 
 
 If you don't have a Google account, you'll need to create one. 
 Let's start by demonstrating how to create an account. 
 
 
 
 
 
 
 
 
 
 First, go to Google.com 
 
 
 
 
 
 
 
 
 
 And click on: Sign in 
 
 
 
 
 
 
 
 
 
 Click: Create account 
 
 
 
 
 
 
 
 
 
 And select: For my personal use 
 
 
 
 
 
 
 
 
 
 Then, complete each step to create your personal account. 
 Now that you've created your Google account, it's time for us to begin  creating our Google Sheets bar chart visualization. 
 
 
 
 
 
 
 
 
 
 Click: the dots menu in the top right corner 
 
 
 
 
 
 
 
 
 
 Click: the Sheets icon 
 
 
 
 
 
 
 
 
 
 Click: Blank to start a new spreadsheet 
 
 
 
 
 
 
 
 
 
 Select: Cell A1, Type: Department 
 
 
 
 
 
 
 
 
 
 Select: Cell B1, Type: # of clicked phishing emails 
 
 
 
 
 
 
 
 
 
 Select: Cell A2, Type: Human Resources 
 
 
 
 
 
 
 
 
 
 Select: Cell B2, Type: 30 
 
 
 
 
 
 
 
 
 
 Select: Cell A3, Type: Customer Service 
 
 
 
 
 
 
 
 
 
 Select: Cell B3, Type: 18 
 
 
 
 
 
 
 
 
 
 Select: Cell A4, Type: Global Security 
 
 
 
 
 
 
 
 
 
 Select: Cell B4, Type: 10 
 
 
 
 
 
 
 
 
 
 Select: Cell A5, Type: Media Relations 
 
 
 
 
 
 
 
 
 
 Select: Cell B5, Type: 40 
 
 
 
 
 
 
 
 
 
 Select: Cell A6, Type: Professional Development 
 
 
 
 
 
 
 
 
 
 Select: Cell B6, Type: 27 
 
 
 
 
 
 
 
 
 
 Then, select: the rows and columns containing headers, department names, 
 and data. 
 
 
 
 
 
 
 
 
 
 Click: Insert at the top of the sheet 
 
 
 
 
 
 
 
 
 
 Select: Chart 
 
 
 
 
 
 
 
 
 
 In the Chart editor menu, click: Chart type drop-down menu, 
 
 
 
 
 
 
 
 
 
 scroll down to the bar chart options. 
 
 
 
 
 
 
 
 
 
 Then, select: the first bar chart 
 
 
 
 
 
 
 
 
 
 In the Chart editor menu, click: Customize 
 
 
 
 
 
 
 
 
 
 Then, click on the: Chart & axis titles section. 
 
 
 
 
 
 
 
 
 
 Now, update the title to read something like: Clicked phishing emails  by department, or another title related to the data. 
 
 
 
 
 
 
 
 
 
 Then, Click on the: x icon at the top of the chart editor to close the editor menu. 
 
 
 
 
 
 
 
 
 
 Great job creating your first visual security story! 
 Creating visual stories of data allow security team members to convey  essential information to stakeholders, 
 so issues can be communicated in a meaningful and understandable way. 
 
 
 
 
 
 
 
 These data stories can also help promote a better understanding of issues that  exist within an organization and allow decision makers to determine how to address security issues that put the organization at risk. 
 
 
 heres the example output 
 https://docs.google.com/spreadsheets/d/1j6XwBP1eaklcvu_gHVE8-zo1_vx4B1i182IRyEPzEek/edit?usp=sharing