Here are my thoughts on how any individual can crack it in the Data analysis field within a period of 6-9 months. MONTH1. Microsoft Excel As a beginner you should begin by straightening out the basics by immersing yourself into learning how to use Excel correctly to format, sort data and making charts. Here's how you gonna learn 1. Creating and Formatting worksheets 2. Basic Functions:Avarage,Min/Max,Count 3.Advanced Functions:Vlookup,SumIf,CountIf,SumProduct,Concatenate 4. Pivot Tables and Conditional Formating 5. Building Gantt Chart/Financial statement. You could also use websites like[](https://excel-practice-online.com/) to practice your Excel skills. Analytical skills to learn alongside these are: Logical reasoning Data Interpretation MONTH 2 Storytelling with Data For Visualization you can use any of PowerBI Tableau Qlik Sense These are used to analyze and understand Data in a visually appealing and interactive way Start creating interactive dashboard. For more of PowerBI check out the Official PowerBI community and an Ebook by Alberto Ferrari and Marco Russo. Skills to learn alongside these are Communication Skills where you build a story around your analysis and share it with your stakeholders. MONTH3N SQL Learn Domain specific language -SQL (for Database Querying) Used to manage and manipulate Data stored in relational database Here will also be an introduction to learning programming skills MONTH4 Learn Exploratory Data analysis -Univariate/Bivariate analysis Learn how to structure your thinking in relation to Data MONTH5 Learn Basic Statistics 1.Regression analysis .Linear regression .Logistic regression 2. Descriptive statistics 3.Probability and Hypothesis testing Alongside these practice skills such as case studies and guessstimation MONTH6 Programming Skills-Python Use a general purpose programming language like Python/R These language have a wide range of applications including Web development, data analysis and scientific computing which makes them versatile to learn. You would also need to learn how to use Text editors and Notebooks like VScode and JupyterLab. Familiarity with Python Libraries such as pandas and Numpy is also neccesary NEXT 3 MONTHS Use the next three months to build as many projects as possible . Networking and attending local Data Community meetups .Preparing for interviews through mock interviews or attending related job interviews .Speaking about your work in various platforms including writing blogs on sites like Dev.to, medium, Hashnode e.t.c. . Be available to learn by offering yourself for internship or mentorship to Seniors in the industry . Finally apply to as many jobs as you can. SUCCESS!! - -

george_morgan_

THE ULTIMATE GUIDE TO DATA ANALYTICS; TECHNIQUES AND TOOLS

Join Our Newsletter. No Spam, Only the good stuff.