A solution to last week’s challenge can be found here.
To solve this week’s challenge, use Designer Desktop or Designer Cloud Trifacta Classic.
According to the Harvard School of Public Health, tea and coffee are the two most consumed beverages on the planet after water. They are brimming with antioxidants and other biologically active substances that may benefit your health.
For this week's challenge, we will use a dataset containing information about the sales of coffee and tea in the USA for a 6-month period.
Based on the sales of each product, determine the following:
- Which state is the biggest consumer of regular coffee?
- Which state is the biggest consumer of decaf coffee?
- What type of coffee drink is the most popular?
- Which state is the biggest consumer of regular tea?
- Which state is the biggest consumer of decaf tea?
- What type of tea drink is the most popular?
