Our goal is to study the sales and units of the store, so we can’t use these records (Row ID 143 to 149) for categorical data analysis. There are some missing values in the Sales and Units (Example Row ID 143 to 149). I have provided the sample design for categorical data, in the attached file. And then write a summary of your findings, understandings, insights and suggestions. You can provide simple graphs and tables for each category level which you are going to provide to the client. The requirement is understanding the sales and Units in different time periods. Once you are clear with the requirement and data, it is the time to prepare a sample design of your output which you want to deliver to your client. You can made any changes to the above table which have prepared based on your final understanding of the data. Once you are done with the initial understanding of the data, you can check with your client whether your understanding is correct.
Priority of the order based on the delivery time
#Categorical data analysis excel code#
Order Id, generally automated code by a computer for one order by customer Row IDĬategory of the category product belongs to Generally you can prepare a table with the given variables and write what we understand from the given data and variables. Now your goal is to understand the data so that you can start analyzing the data. Let’s move to the next step, where you can understand the data or information provided by the client. So, now you understand what is my requirement is (how is my sales in different Region levels and Category levels). Total 8962 records with the following information Row ID This is the same which we have discussed in trend analysis. You can see the Input Data in Data tab of the attached workbook, here are the record counts and variables in the data. And I am providing the following categorical data and asked you to tell me, how is my sales in different Regions, Sates, Categories and Sub categories?
Generally your clients will provide the categorical data and give the requirement based on their business needs to solve certain business problems. Now we will see these steps one by one: Understanding requirement:
Categorical Analysis: Data Analysis Approach:Īs discussed in the Trend Analysis, we have to follow certain steps while analyzing any data. And we will apply categorical analysis using Excel and VBA to study the data and draw the insights from the data. We will take an example categorical data of retail domain.
#Categorical data analysis excel download#
You can download the Example File and practically learn categorical comparative data analysis.ĭownload Now: ANALYSISTABS- Categorical Analysis -Sales-Data Categorical Data Analysis: Practical Example: In telecom domain we can track how the different plans are doing in the market. We can study the Banking data to see how the customers are using our products from different regions or schemes. If we consider retail data, we may study POS (Point of Sales) Data, how is the sales in various regions of the country, or how many units are selling from each store or from each department of the supermarket. For example, we can study effect of particular drug in various countries in health care projects. Categorical or Comparative Data Analysis is helpful to study the categorical data to understand and compare the metrics between different categories.
0 kommentar(er)
