Road Map For Being a Data Analyst

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 sources in CSV or other formats. 

Step 2- We open or import data in MS Excel or spreadsheet. Prepare it by sorting and filtering. 

Step 3- Process data in spreadsheets by cleaning it and removing or correctimg all incorrect data making it ready for analyzing. 

Step 4- We analyze data in spreadsheets and take insights out of the data. 

Step 5- We make simple charts, or present the data in visual way to make it simple to understand for stakeholders (owners, managers, executives etc.) 

note : these above steps are for small data analysis, for big data we use other tools which we discussed in starting. 

To learn more about data analysis keep following the blog 

Thankyou

Rohit Thakur


Comments

Post a Comment

Popular posts from this blog

Python for Data Analysis

Image
Welcome back to my new blog , Today we are going to touch the programming language python. Python is a language which we use for programming. And with python the original coding part is starting for data analysis.  We use two libraries of python for analysis, 2 for scraping and 1 for data visualization.  We can it's the whole package for data analysis big or small data doesn't matter here. We use it majorly for big datasets only. Let's see how it works:-  First we scrape the data, which means to take out data from online sources. This part is not used for internal data. But if you don't have data then you can python for data scraping.  The libraries we normally use for scraping are: scrape and beautifulSoup. We can pull data from websites or web apps by using them. Second  we prepare, process and analyse data.  As we discussed before Prepration contain to sort and filter data, Processing is to make data clutter free by cleaning the data along w...
Read more

R for data Analysis

Image
                    Welcome to the blog where I will tell you how everything works in analysis using R, It is just an overview but you will come to know relation between R and data analysis. This blog will also make you fearless to start with R. So let's start, R is a programming language we all know this, but you will be glad to know it is language which is specially made to analyze the data. The thing is from where to start right ? First see benefits of using R: 1. It is easy to learn language even if you have no coding or technical background. 2. It is like super-market where you will find every tool for analysis. 3. It is one stop solution where we analyze data, make visualization and create documentation. 4. It is open source or free to use. 5. Strong community make it easy to find solutions if you stuck somewhere. Ok, Ok starting how to start and how everything works, first you will go online online to R studio cloud or y...
Read more