Analysis
Closed this issue · 1 comments
Howdy,
Great tool, thanks so much. I'm also interested in how you built the Analysis XLS. Would you be able to share that?
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.