These sites are essential for Data Analysts 1. Mockaroo (mockaroo.com) → generates realistic test data in seconds. I used to spend hours creating fake datasets to practice with. This thing spits out thousands of rows based on whatever parameters you need. 2. SQL Fiddle (sqlfiddle.com) → test your queries before running them on actual data. Saved me from crashing our database more times than I care to admit. 3. Regex101 (regex101.com) → makes regular expressions actually make sense. That alone is worth it. I used to copy paste regex patterns and pray they worked. 4. Our World in Data (ourworldindata.org) → clean, reliable datasets on basically everything. When your boss asks for "industry benchmarks" at 4pm, this is where you go. 5. Datawrapper (datawrapper.de) → creates charts that don't look like they're from 2003. Your stakeholders will think you hired a designer. 6. Mode Analytics (mode.com) → runs SQL, Python, and R in the same place. No more switching between five different tools to finish one analysis. These tools don't make you a better analyst, they just stop you from wasting time on things that shouldn't take time in the first place. CC: Goodness Nwadibie. I hope it helps beginners in DA.

Excel Cheatsheet