Data analyst roadmap

 Data analyst roadmap

Topics to study

1. Microso0ft Excel/ Google sheets 

2. Tools – Power BI or Tableau 

3. Languages- Python or R

 4. SQL – RDBMS

 5. Projects –Portfolio, job portals. 

Study syllabus

i. Excel- excel-practice-online.com 

    YouTube and other of your choice.

        Learn- filtering data Identify and remove duplicates 

        Use formula and functions

        Vlookup = When you need to find information in a large spreadsheet, or you are always looking             for the same kind of information, use the VLOOKUP function. 

        Pivot table and transpose.

 ii. Power BI- Datacamp free courses     

            Microsoft data analyst associate certification

 iii. Tableau- Tableau desktop specialist beginner

             Tableau certified data analyst

 iv. Python- Fundamentals

             Data structures 

             OOPs 

             Pandas, matplotlib , seaborn , numpy 

             Book= Automate the boring stuff with python AL sweigart 

             Learnpython.org For error- googlesearch the error 

            go to stackoverflow 

v. SQL- fundamentals 

             Basic to intermediate level 

             query writing 

             Aggregate funtions 

             Group by and having clause 

             Window function 

             CTE Table 

             Stored procedure 

             Inbuilt function like date and substring

Portfolio projects-    Web scrapping 

                                 Exploratory Data Analysis project 

                                 EDA Visualization using Power BI

Case studies – sales report

SQL courses= https://learnsql.com/?ref=thoufiqmohammed

Portfolio Project ideas

            https://careerfoundry.com/en/blog/data-analytics/data-analytics-portfolio-project-ideas/ 

Data analytics projects-https://www.coursera.org/articles/data-analytics-projects-for-beginners

Google data analytics professional certification = coursera

  https://www.coursera.org/professional-certificates/google-dataanalytics?                    utm_source=google&utm_medium=institutions&utm_campaign=coursera-in-dr-q22022- sem-bkws-      phr-txt-course-1-analyticscourses&gclid=CjwKCAjwt7SWBhAnEiwAx8ZLaiJPJDORlg61cYsZhyAHUmqHwmg34FKVcOd9V6bqW6c8 8So5bq8t9hoCwYQQAvD_BwE&gclsrc=aw.ds 

Weekly Update profile on

1. Github 

2. LinkedIn 

3. Naukari.com 

4. Monster 

5. Portfolio web Build a portfolio 

A portfolio showcases your talents and skills. Typically, a portfolio includes items such as certificates, transcripts, samples of past work, and letters of recommendation.