Kollaborative Klassroom

Praxis Business School, Kolkata, India

Dear Students

Please note the message from Sarit Sir

"

I had asked them to do the following

 

  1. Identify quality issues in the data. E.g
  2. Does every data has Salutation field filled in?
  3. Does every data has Industry field filled in?
  4. Does the Account Site mentioned has the same value as the Business Country?
  5. Are all email fields formatted properly?
  6. Is there a consistency in the way business country field is represented e.g. is US countries being represented as US or USA or America or U.S.A or are there all possible variants?

No one did any such analysis

  1. They should have also done a scoring for each field to indicate the level of data quality. This was also not done.
  2. Finally, based on the data standards document shared, they should have done the data cleansing and standardization. Some of the guys claimed they did this, but they did not indicate in their sheet where exactly they made the change and what was the rationale for the change. Without that it is very difficult to understand the change."

Views: 90

Replies to This Discussion

APST New Assignment by Sarit Bose

Data provided – Data from Salesforce: Demographic data of the customers, agents and partners

Standards: A document was provided which outlines what data standards the organization has to follow

 

Problem statement – The client has to send marketing communication to all it’s customers, agents and partners. However it feels that the data is not in the right shape, hence it cannot rely on it and has to find out the problem and decide on a mechanism to fix it

 

What needs to be done:

  1. Conduct data profiling:
  2. Refer to the data standards – find out from the data which fields does not comply to the data standards
  3. Be innovative; find out if anything else needs to be checked which is not mentioned in the data standards
  4.          E.g.s
  5.        Does every data has Salutation field filled in?

                                                            iii.      Does every data has Industry field filled in?

  1.        Does the Account Site mentioned has the same value as the Business Country?
  2.        Are all email fields formatted properly?
  3.        Is there a consistency in the way business country field is represented e.g. is US countries being represented as US or USA or America or U.S.A or are there all possible variants?
  4. Tool to be used – It can Excel, MS Access or Talend. The stress should not be on any tool, students are free to use what they are comfortable
  5. Create quantitative measures
  6. E.g. How many email ids has issues? – what are the different issues and what are their counts?
  7. Provide recommendations on how the issue should be resolved and what is the business implication of the issue? E.g. if the email is black, customer cannot be communicated and there is no way to find the email id, other than calling up the customer to find the email id and then update the record

 

How should the assignment be prepared and presented:

  1. Prepare a MS Powerpoint or Word or Excel file
  2. Present the profiling results (with quantifications)
  3. For each field profiled – prepare the business impact and recommendation
  4. How I will score the assignment
  5. Based on quality of profiling (weightage – 70%)
  6.          how many critical (in line to the problem statement mentioned) fields were profiled
  7.        how the profiling results is segregated; which helps in understanding the problem in the data and the size/quantum of problem (this is where they can use their descriptive analytics skills)
  8. Quality of business impact and recommendations (weightage – 30%)

Students need to send the assignments to pgpoffice@praxis.ac.in by 0930 hrs of May 31, 2018

RSS

Notice Board

Holiday List & Term Details

Kolkata BA Jan 2018

Bangalore BA Jan 2017

Praxis Placement Program

______________________

Academic Year 2017-18

Kolkata:

Holiday List | Term Details

Bangalore:

Holiday List | Term Details

© 2018   Created by Praxis Adminstrator.   Powered by

Badges  |  Report an Issue  |  Terms of Service