if the data is in excel sheet how one can do the analysis (performance) of many of the companies i.e data has 100 customers in which we have to find the status of the customer whether he is a regular customer, quarter customer or yearly. No Graphs are required. any formula
From India, Mumbai
From India, Mumbai
Dear Khushbu,
Instead of MS Excel, if you use MS Access, the data can be analysed easily. Secondly, your company should start using some CRM software like ACT Sage. These softwares have integration with MS Outlook or Outlook Express as well.
Coming to solution to your query, analyse the data in the following manner:
a) No of visits by the customers per month
b) No of purchases made by the customers per month
c) Customers make what type of purchases - MIS based on product
d) MIS based on geographical spread of your customers
e) MIS based on the type of customers - individual, corporate, family etc
To find out a particular customer is a regular customer, quarterly customer or yearly customer, you can issue the cards to the customers. All the purchases made by the customers can be registered under this customer ID No. This will solve your query.
By the way, I am into soft skills, behavioural and management training. Your query pertains to my subject module "Monitoring Employee and Business Performance". This training module is quite important for the senior management personnel.
To make you aware of my training activities, I have attached my Training e-Brochure to this post. You may recommend training of your senior managers on the subject module mentioned above.
Thanks,
Dinesh V Divekar
Management & Behavioural Training Consultant
Limit of your words is limit of your world[I][COLOR=#0000BF][COLOR=#FF0000]
From India, Bangalore
7855Instead of MS Excel, if you use MS Access, the data can be analysed easily. Secondly, your company should start using some CRM software like ACT Sage. These softwares have integration with MS Outlook or Outlook Express as well.
Coming to solution to your query, analyse the data in the following manner:
a) No of visits by the customers per month
b) No of purchases made by the customers per month
c) Customers make what type of purchases - MIS based on product
d) MIS based on geographical spread of your customers
e) MIS based on the type of customers - individual, corporate, family etc
To find out a particular customer is a regular customer, quarterly customer or yearly customer, you can issue the cards to the customers. All the purchases made by the customers can be registered under this customer ID No. This will solve your query.
By the way, I am into soft skills, behavioural and management training. Your query pertains to my subject module "Monitoring Employee and Business Performance". This training module is quite important for the senior management personnel.
To make you aware of my training activities, I have attached my Training e-Brochure to this post. You may recommend training of your senior managers on the subject module mentioned above.
Thanks,
Dinesh V Divekar
Management & Behavioural Training Consultant
Limit of your words is limit of your world[I][COLOR=#0000BF][COLOR=#FF0000]
From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
23_excel funaction and data analysis tool.pdf
Data Analysis.xls