Sitemap
Press enter or click to view image in full size
image extracted from g2.com articles

DATA ANALYSIS PROCESS/PHASE

3 min readSep 27, 2022

--

Sorry for the long wait , since I promised to do a follow-up of my last article with one on Data Analysis Process. Lets not waste anymore time and get right into it.

First off, we need to understand that to everything we do there are process to follow, to get to the end-goal. So more like Process(steps) are universal and applicable to everything we engage in. Back to the Data world, to every data analysis to be performed there are process to follow in order to arrive at good-data driven decisions. You might be wondering where the good comes from , well we have occurrence of bad data decisions which is as a result of bad(dirty) data, don’t get confused all this would be broken down in the Data cleaning section soon.

Lets get back on track, Data Analysis as we defined in the previous article, has an end goal of making data driven decisions or findings. To be more practical about this , I’d like to use the cooking instance to explain better. First off we define what we intend to cook, next we ask the question “what do we need to get this sumptuous meal?” (ingredients gathering), then we process the ingredients gathered by washing and all, onto the next we follow what ever food preparation techniques required to get this meal on our plate and finally we serve this food to our audience , giving them a taste of what we’ve prepared. All this sounds thrilling right, yeah I know the feeling too.

Get Olumide Akinboyewa’s stories in your inbox

Join Medium for free to get updates from this writer.

Now that we have a simple analogy made up already , guess we all understand better now. This process are the steps needed to follow when performing data analysis, which are the standard to ensure what ever decisions gotten from that data are worth it. Different scholars, courses and research might give different different words to each process but they all mean the same thing. The Google Data Analysis Course via Coursera states 6 phase in data analysis which would be displayed below, while other specifically courses just state 5 leaving out the ACT phase , but they all are saying the same time.

Press enter or click to view image in full size
Google Data Analytics Professional Certificate phases of data analysis

Some other text would state this process/phase as

  • Question
  • Wrangle
  • Explore
  • Draw Conclusions
  • Communications

For better understanding , I prefer to use the Google course analogy of the phase to explain. Below I would explain briefly each terms and tools used.

  • Ask:- In this phase we are to define what exactly the problem is and what is expected. Defining helps to have a focus. This can be done via physical meetings/brief or virtual(zoom and other platforms).
  • Prepare:- This is where we go about getting the ingredients needed to make our desired going by our cooking example. In the data sphere , this is where data collection and storing comes in for the upcoming analysis. Data collection is done via surveys , Documents/Record, questionnaires and co. Storage is done via Spreadsheets and Database.
  • Process:- here comes data cleaning and transformation , data is screened and fine-tuned to get the details right, in this phase for good output. Tools used here are Spreadsheets, Microsoft Power BI ,Query language like SQL, Programming languages like R and Python.
  • Analyze:- the analysis part that involves transforming and organizing information to draw insights from. Tools used in the process phases are used in this stage too as they have the ability to perform analytical exercises.
  • Share:- once insights has been drawn from the data , we need to find a way to communicate/share our findings to stakeholders(audience). This is done in a contextual manners( depending on our audience). This is the data storytelling section , tools like Microsoft power BI, Tableau , Excel and other programming languages can be used.
  • Act:- the final stage where the business takes the insights you the data analyst have drawn from the data and implement it. Cool right.

These phases are standard approach to data analytical process , to ensure good input and good output.

--

--

Olumide Akinboyewa
Olumide Akinboyewa

Written by Olumide Akinboyewa

Data Lover. Learn and write about data. Everything about data amazes me. Data-driven decisions are very important.