US Patent 11356345 Networking data analysis in a visual spreadsheet

In an embodiment, a method comprises, by a networking data analysis system: receiving, from a client device, computer files, each computer file comprising log data; transforming each of the computer files, the transforming comprising: converting the log data associated with the computer files into a structured tabular representation of the log data; parsing the structured tabular representation of the log data to extract data elements associated with the log data and to identify data types associated with the data elements; creating a columnar representation of the log data based on the identified data types; storing the columnar representation of the log data in a columnar database; executing computer-implemented functions on the columnar representation of the log data to identify key networking security metrics; sending, to the client device, instructions for displaying the identified key networking security metrics associated with the log data of the one or more computer files.