Cloud Quest #5: Client Rating Analysis
- RSS フィードを購読する
- トピックを新着としてマーク
- トピックを既読としてマーク
- このトピックを現在のユーザーにフロートします
- ブックマーク
- 購読
- ミュート
- 印刷用ページ
- 新着としてマーク
- ブックマーク
- 購読
- ミュート
- RSS フィードを購読する
- ハイライト
- 印刷
- モデレーターに通知する
Hi Maveryx,
We posted the solution JSON file to Cloud Quest #4. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!
Let’s dive into this week's quest!
Download the provided JSON start file and upload it into your Analytics Cloud library. For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.
Scenario:
Understanding client feedback has been critical for companies to improve their products and services. In your role as a data analyst, you are assigned the task of analyzing client feedback to measure their satisfaction and enhance the quality of services at your company.
For this task, you will need to manually connect the two provided datasets:
- Clients_dataset.csv: Contains information about each client, including their Client ID.
- Requests_dataset.csv: Includes each client's Request Number (identical to the Client ID), Status (indicates whether the request has been processed), Status2 (provides a comment), and Professional (the name of the client).
Your tasks are:
- Count the number of clients (Professional) with a Status of Evaluated who left comments of Below Expectations, Exceeded Expectations, or Met Expectations in the Status2 field.
- Identify the three clients (Professional) who provided the highest average ratings. The ratings are on a scale of 1 to 5 where 5 is the highest.
Hint 1: Client and Professional are distinct fields. The Client field displays the Company Name, while the Professional field shows the individual client's name.
Hint 2: Start by filtering the data at the beginning to only include entries where Status = Evaluated.
Hint 3: Remember to combine the dataset using Client ID and RequestNumber as the key fields.
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:
- Getting Started with Designer Cloud
- Building Connections in Designer Cloud
- Building Your Workflow in Designer Cloud
Once you have completed your quest, go back to your Analytics Cloud library. Download your workflow solution file as a JSON file. You can also capture a screenshot of your finalized workflow in Designer Cloud. Include your JSON file and workflow screenshot as attachments to your comment on this post.
Here’s to a successful quest!
- 新着としてマーク
- ブックマーク
- 購読
- ミュート
- RSS フィードを購読する
- ハイライト
- 印刷
- モデレーターに通知する
I muddled my OR logic at first because I thought I was doing something else, so I left it in there - don't let it fool you.
- 新着としてマーク
- ブックマーク
- 購読
- ミュート
- RSS フィードを購読する
- ハイライト
- 印刷
- モデレーターに通知する
I noticed a change that was made to Alteryx Designer Cloud. One of my earlier gripes with the cross tab tool is that we had to select all of the values that we wanted to bring through as fields. Now it seems to default to having them all selected! Which is awesome.
Managing Partner
DCG Analytics
- 新着としてマーク
- ブックマーク
- 購読
- ミュート
- RSS フィードを購読する
- ハイライト
- 印刷
- モデレーターに通知する
My Solution.
- 新着としてマーク
- ブックマーク
- 購読
- ミュート
- RSS フィードを購読する
- ハイライト
- 印刷
- モデレーターに通知する
Good one!
- 新着としてマーク
- ブックマーク
- 購読
- ミュート
- RSS フィードを購読する
- ハイライト
- 印刷
- モデレーターに通知する
Voila
- 新着としてマーク
- ブックマーク
- 購読
- ミュート
- RSS フィードを購読する
- ハイライト
- 印刷
- モデレーターに通知する
A little hard to understand what was needed.
Unique Clients or non-Unique clients make a big difference. But again fun to solve