Challenge #164: Retail Therapy

[BA02]

 Done! This was a quick one 😄

[Priyanka_Ms]

Solution

[Vidya_Killivalavan]

solution

[pdave87]

Hi @ChristineB and all practitioners, 

My results are not exact. The Avg_rating derived from summarize tool shows rounding on some numbers and decimal figures on others. Unable to figure out how to match the Avg_rating with solution provided. Hence the top 5 are different on some classes compared to the solution.

If possible let me know the reason for variance otherwise the results are slightly different 🙂

Regards,

Pratik

[SimonEvans]

[pdave87]

@SimonEvans Super thanks!!

Filter condition did the trick 🙂 I had taken > 10 instead of >= 10. Maybe I missed to recheck this step in solution yesterday. 

One of the scariest piece of word 'data' and 'data + analysis'. Every step should be understood thoroughly i.e. why >= 10 and not >10. It makes world of difference in the output and analysis.

And in the assessments, how quickly we understand the requirement correctly to derive the expected output. I flunked 1st attempt, fingers crossed for 2nd.

Many thanks for help.

Pratik

[pdave87]

Posting corrected version of my workflow. @SimonEvans thanks for helping.

@ChristineB thanks for the practice exercise. Every challenge has a take away for me. Super thanks to all the experts for spending time and providing these challenges for hands-on practice.

Regards,

Pratik

[mchr]

.

[binay2448]

My Solution attached...

[Vidya_Killivalavan]

solution