DBA Tools for PowerShell . If you're not coasting to retirement then start scripting now before it's too late, PowerShell automation is a disruptive technology . Oh, and come join the SQLCommunity (#DBATools, #General and #SQLHelp) on Slack.
Microsoft R Client . You need to learn this.
What's R? It's a scripted ETL and analytics language with advanced reporting functionality. Imagine SSIS + SSAS + SSRS all written in PowerShell. That's not it. But it's close.
SQL Server Data Tools ( SSDT-BI isn't normally needed anymore ) and Visual Studio 2015 Community (assuming the extremely restrictive license fits your workplace). Normally you'd then add BIDS Helper but until it officially supports Visual Studio 2015 you might be best going with BimlExpress (free) instead. BIML is a must for modern, clean, understandable, reproducible SSIS packages.
- SQL Server 2016 Developer . Select all the options because you can. But I don't like having it installed directly on a workstation, it's best inside a VM that can be tinkered with and blown away.
- Power BI Desktop . I'm not sold on it yet but Microsoft likes it.
- SQL Server 2016 Master Services Add-in for Excel . Because you have Office 2010 or above, right?
- SQL Server 2000 DTS Designer Components from the SQL Server 2008 SP3 Feature Pack for the DTS Migration Wizard .
- If your workstation doesn't have a large SSD throw it in the bin.
- If your workstation doesn't have 8GB or more of memory throw it in the bin.
- Get a good wireless keyboard and mouse . Okay these probably aren't free but it's likely the ones you have should be thrown in the bin.
- You could probably also use Azure but I'm not that cool.