Road Map for being a Data Analyst

Welcome to the new blog :-) In this blog I will tell you what's basic difference between formulas(formulae) and functions while using Excel. For an example,  Formulas are like homemade pizza where we can add things with variety and quantity by our own taste. AND  Functions are like pizza from Domino's or Pizza Hut, where we just tell name, size or extra cheese(all the arguments). Not fully customized. It is fine to make single or double topping pizza at home (formulas using operators only). But as we all know most of the time we have lack of experience, lack of ingredients (options) at home to make pizza (formula writing) Which makes the pizza bit different from Domino's and even less tasty(functional). At this point readymade pizza come more handy so we order it(use functions which are inbuilt) Definitions :- Formula :   A set of instructions used to perform a calculation using the data in a spreadsheet. Example of formula :- = (B3+A2)*5 Function :  A preset command...

Hello Guys, It's beginning of data analysis.  Follow the blog to learn more about data analysis and data.  There are plenty of tools which we use for collecting, preparing, processing, analyzing and presenting data. Like : Python, R, MS Excel, Google spreadsheets, MS SQL, SQL, BigQuery, Postgre SQL, PowerBi, Tableau etc. So I am going to categorize these tools according to there uses at different stages of data analysis : 1- For  COLLECTING DATA :- Python, MS excel, Spreadsheets. 2-For PREPARING DATA :- Excel, SQL, Spreadsheets, MS SQL, Postgre SQL 3-For PROCESSING DATA :-   Excel, SQL, Spreadsheets, MS SQL, Postgre SQL 4-For ANALYZING DATA :-  Excel, SQL, Spreadsheets, MS SQL, Postgre SQL, Python, R 5-For PRESENTING DATA :- PowerBi, Tableau. We use these tools in different sets. For example: Step 1- We  use Python to scrape data online or mostly we get data from company and other outer ...