Welcome to the second day of Dashboard Week! Today’s challenge revolves around one of our favorite passions: gaming and all things computery’ishness. Over the last five years, CPUs and GPUs have seen tremendous improvements, leading to better performance and enhanced gaming experiences. In this blog, we will walk you through the process of building a dashboard to visualize the advancements made by various manufacturers in CPU and GPU technologies. By the end of this journey, you will have the tools to make an informed decision on the best CPU and GPU duo for your next media server build.

Step 1: Explore the Data

To kickstart our journey, we first delve into the Chips_dataset to understand its structure, relationships, and potential criteria affecting CPU and GPU performance. By using Alteryx, we gained insights into the data, such as null values, total records, and categories in different fields. Additionally, we fine-tuned the data types to ensure seamless analysis.

Step 2: Research on Performance Criteria

With a better grasp of the dataset, we conducted extensive research to identify the key factors influencing CPU and GPU performance. For CPUs, we discovered that the number of transistors, process size (nm), and clock speed (MHz) played a significant role. In contrast, for GPUs, GFLOPS, particularly the fp64 performance, emerged as the most crucial criterion. Armed with this knowledge, we were ready to build insightful charts.

Step 3: Create Informative Charts

To visualize CPU performance, we utilized line charts, bar charts, and area charts to illustrate improvements over time for different manufacturers. Our area charts focused on the key dimensions affecting CPU performance, namely process size, number of transistors, and clock speed. Similarly, we created a bar chart for GPU performance, showcasing GFLOPS data.

Finding the Best Chip:

To simplify the selection process, we designed a bar chart that highlighted the top-performing chips based on frequency (clock speed) for both CPUs and GPUs. This chart offered an at-a-glance view of the best options in the market.

Step 4: Enhance User Interactivity

Recognizing that users may have unique requirements and system specifications, we incorporated filters into the dashboard. Users could filter by vendor, year, and chip type, making it easier to narrow down choices. Additionally, the area charts acted as interactive filters, allowing users to select the best CPUs based on their preferred criteria.

Step 5: Consider Compatibility

While our dashboard offers invaluable insights into CPU and GPU performance, we understand the importance of compatibility. To address this concern, we embedded a bottleneck calculator webpage (pcbuild) to help users make more informed decisions about their ideal CPU and GPU duo.

Now we possess a powerful dashboard capable of guiding you toward the optimal CPU and GPU combination for your media server build.

Armed with comprehensive performance metrics and compatibility considerations, you can confidently embark on your journey to peak performance in gaming and computing. Happy computing and gaming!


The Data School
Author: The Data School