Data Analysis Roadmap-2024
Data analysis is like cleaning up and making sense of a messy room of information. It involves checking for mistakes, organizing things neatly, figuring out patterns, and discovering important details. The goal is to turn that messy information into helpful insights, so we can make better decisions or understand things better. It’s like solving a puzzle to see the big picture.
In technical terms, the primary goal of data analysis is to extract valuable insights from data, enabling informed decision-making and aiding in the understanding of complex phenomena.
In this blog, I will outline a comprehensive roadmap for becoming a Data Analyst. It took me a long time to research for the topics to become a Data Analyst. My thorough research will simplify your study process by breaking it down into manageable sections.
STEPS TO FOLLOW BECOME A DATA ANALYST:
Name of the Topics to Cover:
- MS Excel
- Mathematics and Statistics:
- Visualization Tools (Power BI or Tableau)
- Python:
- Structured Query Language(SQL)
- Resume and Intrview Preparation
- Projects
- MS Excel
▪Basic Excel : Workbook, Cell, Data Entry, Formatting(adjusting font styles, colors, alignment, and number formats), sorting & Filtering, Conditional Formatting(highlight cells that meet certain criteria), Data Protection
▪Advanced Excel: VLOOKUP, INDEX, MATCH, IF, COUNTIF, and SUMIF, Creating charts and implementing slicers, Pivot tables and generating pivot charts for comprehensive data analysis.
Resources: Complete Excel Tutorial in one video: In a short span of time he made things very clear. If you want, you can follow: https://www.youtube.com/watch?v=OX-iyb-21tk Or , you can follow this one also: https://www.youtube.com/channel/UC8uU_wruBMHeeRma49dtZKA
2. Mathematics and Statistics: For becoming a Data Analyst, nothing to worry about Mathematics and Statistics. Few basic concepts as mentioned below are enough for the purpose.
▪ Basic Mathematics: Arithmetic, Weighted average, Cumulative sum, Percentile, Quartile
▪ Basic Statistics: Mean, Median, Mode, Standard deviation, Normal distribution
3. Visualization Tools (Power BI or Tableau): In Industry, different organizations follow differnt tools for Data Visualization. As per my recommendation, Power BI may be prioritized over Tableau as Power BI is widely in demand within the industry.
Recommended Resources:
Power BI: You can follow him for learning Power BI https://www.youtube.com/watch?v=6cV3OwFrOkk
Tableau: If, you are determined to learn Tableau, then you can follow him: https://www.youtube.com/watch?v=6RZEaEH9ZsQ
4. Python: For programming, mainly Python is used as it is an easy language and has loads of libraries. Topics to read: Variables, Data types, Lists, Tuples, Dictionaries, Sets, Conditional expressions, Modules, Functions, Operators, IF-Else statements, Loops, Classes and Objects
▪ Python libraries: Numpy, Pandas, Matplotlib, Seaborn
5. Structured Query Language(SQL)
▪Basic Queries: SELECT, WHERE, DISTINCT, LIKE, BETWEEN, ORDER BY, LIMIT, GROUP BY, HAVING CLAUSE, INSERT, UPDATE, ALTER, IMPORT, Data types
▪ Advanced Queries: Date time function, Window function, Sub query, Case statement, CTE, query optimization
▪ Joins: Inner Join, Outer Join, Left Join, Right Join
Resources to learn SQL : You can follow this website: https://www.w3schools.com/sql/
NOTE: The resources recommended are based on my personal suggestions, and you are encouraged to explore and cover the topics using any accessible resources that suit your needs.
6. Projects:
Excel Project:
i. Freelancing work of Vrinda Store’s Annual sales data. Chandramondal1/Freelancing-work-of-Vrinda-Store-s-Annual-sales-data- (github.com)
Power BI Project:
i. Analyse ecommerce sales data created interactive dashboard using Power BI. Chandramondal1/Analyse-ecommerce-sales-data — -Power-BI: Analyse ecommerce sales data created interactive dashboard using Power BI (github.com)
SQL Project:
i. SQL Project on Music Store Data Analysis. Chandramondal1/Music-Store-Data-Analysis: Music store data analysis using SQL (github.com)
6. Resume & Interview Preparation : Craft a concise one-page professional resume using a suitable template, incorporating your learned skills and completed projects.
▪ Free Resume Template Websites: Canva is one of the best websites to make resume. Some templates are even free over there. Check out the following link. https://www.canva.com/resumes/templates/
Follow my LinkedIn Profile: www.linkedin.com/in/chandra-mondal-49021b282
Follow my Github Profile: Chandramondal1 (Chandra Mondal) (github.com)
