search

dvassallo / s3-benchmark

Measure Amazon S3's performance from any location.
MIT License
822 stars 133 forks source link

Analysis #4

Closed HoustonDad closed 5 years ago

HoustonDad commented 5 years ago

Howdy,

Great tool, thanks so much. I'm also interested in how you built the Analysis XLS. Would you be able to share that?

dvassallo commented 5 years ago

It's not that complex actually. There are 3 Excel features being used: pivot tables, pivot charts, and slicers. The benchmarking tool already generates results in CSV, so the Raw Data sheet is just that. Then all the other sheets have a pivot table starting at column H based on the raw data. Pivot tables allow you to run something conceptually similar to an SQL query against the data. I used them to group the results by thread count, instance type, or object size (depending on the sheet). Then the main chart is done via a pivot chart. It's basically just a regular Excel chart but linked to the results of a pivot table instead of regular cells & columns. Finally, the selectors to the right of the chart are called slicers. These are an extension of pivot tables, and allow you to have slightly fancier filters. When you use them, you're basically adjusting the pivot table query.

That's pretty much it. I hope that helps. Happy to answer more questions if there's any.