Swapping values with SWITCH

Senior management is looking to identify upsell opportunities. Upsell means getting non-paying accounts to convert to paying accounts. In this dataset, the Subscription Type has four tiers. From worst to best, they are Basic, Premium, Business, and Enterprise.

We can use a SWITCH() statement to easily transform these strings into numerical values, that can help us provide insights to the senior management team.

If you lost progress, close any open files and load 1_5_slicers.xlsx from the Workbooks folder.