Shane is really challenging us to build dashboard effectively by using unfamiliar and huge dataset. I learnt my lesson from practical way rather than read tips from others, it would be worthwhile to note my own experience here.


Tip 1: Sleep Well and Sleep Enough


One of the keys to success during Dashboard Week is to sleep well and get enough rest. It’s important to take care of your physical and mental health, especially when working on such a challenging project. If you’re getting used to working at night, it’s important not to leave much workload at night if you have a deadline the next morning.


Tip 2: Don’t Panic When Dealing with Unfamiliar Datasets


When dealing with unfamiliar datasets, it’s important not to panic. Spend time understanding the metadata and the structure of the dataset. This will help you identify the key variables and the relationships between them. Spending time to understand the dataset is crucial to ensure that you can deliver a high-quality output.


Tip 3: Use Alteryx to Handle Huge Datasets


Alteryx is a powerful tool that can help you handle huge datasets. For example, the main dataset for Dashboard Week Day 3 was 2.6GB with more than 100 million rows. Excel can’t even open such files. However, by using Alteryx, you can filter out certain information and work with a smaller dataset. For example, if you’re working on the Trump election in 2016, you can simply filter out the election year 2016 and work with a 110MB dataset instead of a 2.6GB file.

By following these tips, you can ensure that you work sequentially and deliver a high-quality output during Dashboard Week. Remember to take care of your physical and mental health, spend time understanding the dataset, and use the right tools to handle huge datasets.

I hope this helps! Let me know if you have any other questions.

Pujiang Zhang
Author: Pujiang Zhang

A recent graduate with a Master of Information Technology from the Queensland University of Technology with a literature background in digital media. My academic journey has fueled my passion for making informed decisions through data analysis, and I'm fascinated by the intersection of Artificial Intelligence and its societal impacts. Beyond the world of data, I find joy in activities like jogging and swimming. I also have a strong interstate in philosophy and history, dedicating my spare time to exploring the depths of these subjects.