•
•
코드 쉐어
•
준비할 사항
◦
advanced excel
Features such as data filters, functions, formulas, Charts and plots, Pivot table, vlookup and VBA macros should be covered in one week to do data analysis.
◦
sql
Topics like Joins, Unions, Order by and Group by should be covered. Hence, intermediate level expertise in SQL is necessary.
◦
BI tool
Week 3 and 4 can be spent in learning BI Tools for data visualization.
Power BI, Tableau and Qlik sense are three most popular tools for this in the industry. However, you can just learn one or two tools and that should be enough to make you a good data analyst. I personally recommend Tableau since I find it more easier and convenient comparatively.
◦
Numpy, Pandas, Matplotlib
Numpy and pandas are essential for analyzing data whereas matplotlib and seaborn lets you visualize your data. You can learn either Matplotlib or Seaborn as both of them serve the same purpose.
◦
Projects, Portfolio, and Resume
You can find enough and more datasets in Kaggle for doing projects.