Skip to main content

DATA ANALYTICS LIFE CYCLE: WHAT IS IT? HOW TO APPROACH?

WHAT IS IT?

Data analytics is the process of examining and manipulating data in order to gain insights and draw conclusions. It involves collecting, cleaning, and organizing data, as well as performing statistical and machine learning techniques to analyze the data. The data analytics life cycle is a structured approach that guides organizations through the various stages of the data analytics process.

APPROACH?

1 OBJECTIVE :

First and foremost, Understand the Objective, and the purpose. Why are you doing this? What outcome do you want from it?
If these questions are not clear, the rest is in vain. It is the same way that we do in SDLC (Software Development Life Cycle) model, If the requirement is not clear, then you might develop or test the software wrongly.

2 UNDERSTANDING THE DATA :

Once you have understood the “Objective”, understanding the data is crucial. Suppose your data contains rows and columns in excel or on a server, check what each row comprises with respect to the columns. If you have a bulk dataset, take a sample, and then do some wear and tear to understand what it embraces. And most importantly, check if the data fulfills the objective or not. Sometimes the data provided to you might have some crucial information missing in the data.

3 DATA CLEANING AND DATA TRANSFORMATION :

These two go hand in hand. Data cleaning includes removing and replacing junk data and filling in some gaps if present. Whereas data transformation consists of transforming the data as per your requirement to achieve the objective. Like if you create some metrics like Weekend vs Weekday sales, Seasonality like Spring, Summer, etc. for Sales data, and many more. Sometimes after you transform and clean the data you might have to transform it more or vice versa. If you have a Large Dataset, try cleaning the data before you start the transformation, it will reduce your efforts.

4 DATA ENHANCEMENT :

Data enhancement is adding value to the data given to you by looking for other external sources or non-traditional data. Today many new forms of data channels are available which can be leveraged for meeting the business objective.

5 DATA ANALYTICS :

When you have all the data in the desired format, you will perform Analytics which will give you insights into the business and help in decision-making. For this, you can use Linear Regression, Clustering, and Decision Tree techniques to come to a conclusion and many more as per requirement. This can be done with help of R language (open source).

6 DATA VISUALISATION :

What good it would do if you were not able to present it well. So, do take time to Visualise your data, for this you can use Microsoft PowerBI. The way you present the outcome of Analytics does matter. The more it appeals, and is user-friendly, the more user will indulge in it.

Data Analytics is Storytelling, it tells you what is happening and what you should do to reach your objective.
So start building your story…

 


 

Comments

Popular posts from this blog

How to choose right visual for Data Visualization in Power BI ?

Data visualization is a crucial aspect of any business or organization, as it helps to present complex data in a more understandable and visually appealing way. It enables decision-makers to quickly understand trends and patterns in the data, which can help to inform their decisions and strategy. One of the key tools for data visualization is Power BI, a powerful software platform that allows users to create interactive dashboards and reports. When using Power BI, it is important to choose the right visual for your data, as this will help to effectively communicate the insights you have gleaned from the data. So, how do you choose the right visual for your data visualization in Power BI? Here are a few key tips: 1.      Know your data : Before you start creating your data visualization, it is essential to understand the data you are working with. This includes understanding the structure of the data, the types of data you have, and any relationships or patterns in th...

SUMX Function in DAX - PowerBI - With Example

DAX (Data Analysis Expression) is a powerful language used to define calculations in Power BI, Excel, and other Microsoft tools. One of the useful functions in DAX is the SUMX function, which allows you to perform a sum across a table, using a formula that you specify. To understand how the SUMX function works, let's consider a simple example. Suppose you have a table of sales data, with the following columns: Date Customer Product Quantity Price 1/1/2022 John A 2 $10 1/1/2022 Mary B 3 $20 ...

What is Power BI & its components ?

Power BI is a business intelligence service that allows users to visualize and analyze data from various sources, such as databases, Excel spreadsheets, and web services. It provides a range of features and tools for creating interactive dashboards, reports, and charts, and allows users to share their insights with others in their organization. Power BI is available as a cloud-based service or as a desktop application, and can be used to connect to a wide variety of data sources, including on-premises databases, cloud-based data storage systems, and web-based data services. It also includes features for collaboration, such as the ability to publish dashboards and reports to the web and share them with others in an organization. Overall, Power BI is designed to help users make more informed decisions by providing a powerful and user-friendly platform for data visualization and analysis. The main components of Power BI are: 1.      Power BI Desktop : This is a Windows ...