Share via

Excel for Security Analysts Series

  • Article

Excel for Security Analysts is a series of blog posts for Security, Data and BI analysts. In this series we demonstrate the powerful analytic capabilities of Excel.

Most of the posts are focused on the data acquisition and transformation phase, which are achieved with Power Query technology in Excel, which is now integrated into the Data ribbon in the Get & Transform group in Excel 2016 (Preview).

Here are the episodes:

Excel for Security Analysts - Intro

Episode I - Analyzing Web Traffic Logs (W3C ELFF)

Transform multiline records into a table

Episode II - Analyzing SSH Logs

Coming soon (This page will be updated as we publish new episodes):

Episode III - Analyzing IPTables Firewall Logs

What do yo like to see next?

Please share your ideas and feedbacks in the comments below.

Comments

  • Anonymous
    August 02, 2015
    In today's post, there is a nice Power Query trick to transform multiline record data into a table
  • Anonymous
    August 02, 2015
    In this walkthrough we will show step-by-step how to turn web traffic logs ( W3C Extended Log File Format
  • Anonymous
    August 04, 2015
    Excel for Security Analysts