Begin with questions, not tools
Analysts turn business questions into trustworthy measures and decisions. Practise defining a metric, identifying required data and checking whether the available information can answer the question.
Build spreadsheet confidence
Learn cleaning, lookups, conditional logic, pivot tables and charts. Use consistent tables and document assumptions. Spreadsheets remain useful for fast analysis and stakeholder collaboration.
Make SQL a core skill
Practise filtering, grouping, joins, subqueries, common table expressions and window functions. Work with realistic schemas and validate totals after every join.
Learn statistics and visual communication
Understand distributions, sampling, variability, confidence and common interpretation mistakes. Choose charts that clarify a comparison or trend, and remove decoration that hides the message.
Add dashboards and Python
Use a business intelligence tool to build interactive reporting with clear definitions. Add Python and pandas when analysis becomes repetitive or data is too complex for a spreadsheet.
Create portfolio case studies
Show the question, cleaning decisions, analysis, visual result, recommendation and limitation. A portfolio should demonstrate judgment, not only screenshots of dashboards.