Tableau Problem #1 – Use the following information to answer…
Tableau Problem #1 – Use the following information to answer questions 31 through 40. You have been asked to help perform some procedures related to a Network Vulnerability Scan engagement. Specifically, your team has been asked to identify, assess, and report on potential security weaknesses within the client’s network infrastructure. Your portion of the engagement is focused on analyzing network login activity logs to identify any unusual activity that may have occurred. The data you receive from the company is broken out as follows: Network Logs worksheet with the following data fields: Network Login ID: number that uniquely identifies each network log in (100234001) Date: date the log in occurred in month/day/year format (10/1/2024) Time: time stamp the log in occurred in hour/minute/second 12-hour format (4:24:39 AM) Employee Number: number that uniquely identifies the employee who logged into the network (EE079238) Office Location: office location name related to the Employee Number (Secondary Campus – Atlanta) Day of the Week: day of the week of the network login (Wednesday) IP Address: number that uniquely identifies the IP Address of the device used to log into the network (34659328) IP Address City: name of the city that the IP Address originates from (Atlanta) IP Address Country: name of the country that the IP Address originates from (United States of America) Specifically, you are to: download and save the following data ‘Client Network Log Data.xlsx’; look through the data in Excel – this will help you become familiar with the data connect Tableau to the data; there are 9 fields with 29,800 rows in the data – before beginning, please double check the ‘Data Source’ tab in Tableau to ensure all data has been loaded In order to perform certain distinct counts you will need to duplicate the ‘Network Login ID’ dimension and the ‘Employee Number’ dimension and convert those duplicates into measures. In addition, if using the ‘Employee Number’ dimension, Tableau may pop-up a warning message stating the recommended maximum number for the shelf is 1,000. If this warning message appears, go ahead and click on ‘Add all members’. This will ensure all available data is analyzed. using Tableau, answer the questions that follow; and delete the data file once finished.