Practice Exercise

New Course: Time Series Forecasting

Check out our four new lessons in the Data Science Learning Path that will help you stay entertained and learn some new skills while you're stuck at home!

Data Science Learning Path
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

Learning Path 1: Exercise 4: Tax & Audit

Alteryx
Alteryx

Congratulations on completing Exercise 4! 

 

When you are ready to submit your solution, click "Reply" to this post and upload your workflow.

 

You may also download and review the attached solution.

Highlighted
5 - Atom

Hello, I believe there is currently an issue with the question as it relates to the datasets. 

 

The question states to Associate the appropriate "Shipping Method" with each order based on its "Order_Priority," but we do not have shipping methods listed, but rather payment methods in the given dataset. This would be fine, but the question asks the user to look for items shipped via Freight. The final state shown, has the "REVIEW" items marked as those that had a transfer method of direct deposit, and a vendor of N/A. 

 

If the question could be updated to match the given datasets, or the datasets change to those provided in the solution to match the question, it would be much appreciated. Thank you very much!

Highlighted
5 - Atom
 
Highlighted
5 - Atom
 
Highlighted
6 - Meteoroid

Greetings,


I believe there may currently be an issue with this practice exercise. I downloaded the exercise via the learning path.  The exercise asks to identify all orders which contained "Technology" items that were sent via "Freight."  However, the "Line Item Categories" dataset does not include a "Technology" classification. I could not find a "Technology" classification in any of the raw data provided as part of this exercise.

 

When I open the solution, the analagous dataset is called "Product Categories," which does contain a "Technology" classification.

 

Can you please clear this up? My incomplete solution is attached for reference.

 

Thanks,

 

Marc

Highlighted
7 - Meteor

Was able to do most of the challenge except for the last part. Like the others below have mentioned there is no mention of technology or freight. 

But we can still do the bulk of the exercise involving transpose, cross tab, join and text to column. The last filter part should be relatively easy. 

Highlighted
6 - Meteoroid

Learning Path 1: Exercise 4

 

Highlighted
6 - Meteoroid

I agree with the previous comments that the exercise is talking about data that is not included in the raw input data provided. Can this be updated so the exercise can be completed? I have attached my un-finished exercise for reference. Thanks!

Highlighted
6 - Meteoroid
 
Highlighted
5 - Atom