SQL, Excel & Tableau-like tools are good enough to start. Then add something like R eventually. And then there are tools that are specific to the industry – example: Google Analytics for the tech industry.
Other than that, you should know what do with these tools. You need to know following concepts and continuously build upon that as the industry use-cases and needs evolve:
- Spreadsheet modeling
- Forecasting
- Customer Segmentation
- Root cause Analysis
- Data Visualization and Dash-boarding
- Customer Lifetime value
- A/B testing
- Web Analytics