Hard skills for Data Analyst

1. Solid problem-solving and critical-thinking skills

2. Good knowledge of statistics

3. Strong knowledge of databases

4. Proficient with SQL (PostgreSQL, MySQL).

- Data Warehouse Designing Principles (cubes, dimensions, etc)

- JOIN operators (INNER JOIN, OUTER JOIN, LEFT JOIN, CROSS JOIN, etc)

- SET THEORY (UNION, INTERSECT, MINUS)

- DATA TYPES and CASTING operators

- SQL performance optimization (temp tables, indexes, sub-queries, etc)

- Logical and conditional operators (AND, OR, CASE, DECODE)

5. Good knowledge of Python and Python libraries (matplotlib, seaborn, numpy)

6. Data visualization skills (Tableau/Power BI/Looker)

7. Presentation skills.