Chase Sapphire Preferred Points Battle: Two epic trips, one card


On the heels of The Points Guy’s first-ever “Points Battle,” we’re back with another edition — and this time we’re venturing both north and south of the equator.

Brian Kelly, founder of The Points Guy, challenged two TPG teammates to duke it out and see how they could each maximize travel benefits from their Chase Sapphire Preferred® Card (see rates and fees) to plan the ultimate, Instagram-worthy, awe-inspiring trip.

This challenge was made sweeter with Points Boost, a handy perk that makes your Chase Ultimate Rewards points worth more and stretch further when you book select hotels and flights through the Chase Travel℠ portal.

Add in longtime favorite benefits like earning bonus points on dining and travel, the ability to transfer points to airline and hotel partners, and a $50 annual hotel credit for booking through Chase Travel, and we had an epic competition on our hands.

The Points Guy’s senior hotel reporter, Tanner Saunders, accepted the challenge alongside Lyndsey Matthews, senior travel editor at TPG.

Here’s how it all went down.

Points Battle: Chase Sapphire Preferred edition

Like most competitions, this Points Battle had some rules, including picking themes for the trip by spinning a wheel of travel parameters, finding the perfect Instagram photos and putting together a truly memorable journey while also leveraging points and card benefits efficiently.

Lyndsey takes a spin

While working at TPG’s New York office, I received a cryptic text message from Brian telling me to go to his office — a strange request considering I knew he was off jet-setting. Walking toward his office, I noticed my favorite colleague, Tanner Saunders, heading in the same direction. He’d gotten the text, too.

Inside the office, we found a magic wheel of trip themes and instructions to spin it three times each to determine where we would travel and what we would experience along the way. I landed on visiting somewhere with a rainforest climate, seeing a wonder of the world and eating a food I had never tried before. While Tanner took his turn, I started planning.

Reward your inbox with the TPG Daily newsletter

Join over 700,000 readers for breaking news, in-depth guides and exclusive deals from TPG’s experts

Tanner learns his fate

Tanner here! I was excited for the chance to spin the wheel thrice over to plan my adventure. As it turned out, I would be heading to a desert climate and staying in a bucket-list hotel, a perfect fit for this hotel reporter. It also gave me a chance to put my Chase Sapphire Preferred card’s $50 hotel credit to work.

With adventure calling, Brian informed us we would each have up to 150,000 Chase Ultimate Rewards points to turn our trips into reality, and that the winner would take home another 150,000 points to use for a trip that did not require trouncing a co-worker.

With the rules in place, our points balances loaded and some friendly competition in the air, we set out on our adventures.

Points are a battlefield: Planning 2 epic trips

Before any trip, Points Battle or not, there’s a lot of planning to be done. Our two TPGers got to work seeing how far their points could take them and hammering out every detail along the way.

The battle was just beginning.

Lyndsey: Wilderness and wine in New Zealand

Armed with 150,000 Ultimate Rewards points, I had a decision to make: Find business-class flights somewhere close to home or stretch my points as far as possible to get to the other side of the world.

While I could easily find a dish I haven’t tried before in any country, the other parameters of my trip — a rainforest climate and a wonder of the world — lent themselves to locales a bit farther from my home base in the United States.

Several of the new Seven Wonders of the World are in rainforest climates, but I had already been to Machu Picchu in Peru and the statue of Christ the Redeemer in Brazil. I wanted to see something new, which led me to Milford Sound on New Zealand’s South Island. Considered by some to be the eighth wonder of the world, this epic fjord sits within the Te Wahipounamu UNESCO World Heritage Site, which just so happens to be a temperate rainforest.

Fiji Airways A350
BEN SMITHSON/THE POINTS GUY

Finding flights to New Zealand without burning through my entire budget took some work. But thankfully, after comparing a few routes and airlines, I secured a round-trip Fiji Airways ticket from Los Angeles International Airport (LAX) to Auckland Airport (AKL) with a layover at Nadi International Airport (NAN) in Fiji for 63,083 points via Chase Travel.

Tickets in hand, it was time to head to the airport. I earned 5 points per dollar spent on my Lyft ride by paying with my Chase Sapphire Preferred card.*

After landing in Auckland, I made my way to the Park Hyatt Auckland. I booked one night in a king room at this luxurious Category 8 Hyatt property by transferring 25,000 Chase Ultimate Rewards points to World of Hyatt.

LYNDSEY MATTHEWS/THE POINTS GUY

The Park Hyatt Auckland has 195 guest rooms and suites with floor-to-ceiling windows overlooking Waitemata Harbour and the city skyline. My room featured Maori-inspired decor, like the traditional tukutuku wall panels woven from red, black and white New Zealand wool, hung across from the cushy king-size bed.

LYNDSEY MATTHEWS/THE POINTS GUY

The spacious marble bathroom featured a free-standing tub overlooking the harbor. I think my favorite detail was the walk-in closet that let me unpack without cluttering the space. I was traveling solo, but families can book adjoining rooms, giving themselves even more space to spread out.

Despite the jet lag, there was no time for rest since Brian surprised me with a bonus points challenge at the Park Hyatt to “live like a local.” Since New Zealand is basically Middle-earth, I decided to partake in a hobbit’s favorite activities: eating and drinking. For that, I boarded a 40-minute ferry from Auckland to Waiheke Island for a food-and-wine tour.

I tasted a bright and flavorful chardonnay and a peppery syrah at Mudbrick Vineyard, sampled four local olive oil varieties at Allpress Olive Groves, and slurped fresh Te Matuku oysters harvested just down the road from the Ki Maha restaurant right on Onetangi Beach. I earned 3 points per dollar spent on dining with my Chase Sapphire Preferred card and was also able to check off the “food I’ve never tried” part of my challenge here since I’ve never had oysters from New Zealand.

LYNDSEY MATTHEWS/THE POINTS GUY

Thoroughly relaxed and revived, it was time for some thrills on the South Island. To get to Queenstown — New Zealand’s adventure capital — I booked round-trip flights from Auckland on Air New Zealand using an additional 19,440 points via Chase Travel.

LYNDSEY MATTHEWS/THE POINTS GUY

For my home base in Queenstown, I booked two nights at the Sofitel Queenstown Hotel & Spa. Since this French-inspired luxury hotel with a posh spa in the heart of the city is bookable through Chase Travel with Points Boost, I redeemed 37,838 points instead of paying $454, for a value of 1.2 cents per point.

However, since my challenge was to see a wonder of the world in a rainforest, I wasn’t going to spend much time at the hotel spa. To make the most of my time, I booked a scenic flight tour to Milford Sound, bypassing the four-hour drive by soaring over Fiordland National Park’s glacier-covered peaks before descending among the dramatic green slopes of the fjord.

The expert guides at Rosco’s Milford Kayaks whisked me out onto the water, where we paddled to the 500-foot-tall Stirling Falls and saw a seal pop up in the spray near our kayak. A pod of dolphins also appeared, jumping out of the water to my joyous surprise.

LYNDSEY MATTHEWS/THE POINTS GUY

The adventure didn’t end there. I may have passed on bungee jumping at its birthplace just outside Queenstown, but I was up for the technical challenges of canyoning, which involved rappelling down waterfalls, sliding through narrow canyons and wading through clear alpine streams for an adrenaline rush instead.

LYNDSEY MATTHEWS/THE POINTS GUY

For my final bonus points opportunity, Brian challenged me to “do something that makes you feel completely free.” Challenge accepted: I booked a high-speed all-terrain-vehicle tour, racing through a pine forest and splashing through streams to the top of the hills overlooking Lake Wakatipu, where I slowed down long enough to take in the view and appreciate just how much I had packed in during my time in Aotearoa, or the Land of the Long White Cloud, as the Maori call it.

LYNDSEY MATTHEWS/THE POINTS GUY

And since I was able to earn 2 points per dollar spent on all these travel activities with my Chase Sapphire Preferred card, I knew I was heading home with plenty of points to spend on my next trip — win or lose.

Tanner: Morocco on my mind

With a whopping 150,000 Chase Ultimate Rewards points in my pocket and the parameter of visiting a desert climate, my mind immediately went to one place: Morocco.

Famous for its sweeping desert landscapes and jewel-box riads, I set my sights on Marrakech and the nearby Agafay Desert. But how to get there?

Searching Chase Travel, I realized there were a lot of affordable flight options for my journey to North Africa, but the best way to stretch my points involved an unexpected overnight stay in Madrid and then a quick jaunt over to Marrakech.

That’s when it hit me: I could use that overnight as a way to spend the night at The Madrid Edition, a hotel I’d dreamed about visiting for years after seeing photos of its moody lobby bar and dramatic white spiral staircase on social media.

TANNER SAUNDERS/THE POINTS GUY

For 37,618 points, I was able to book a round-trip Iberia ticket between New York and Marrakech with a stop in Madrid each way. Some travelers hate a stopover, but I saw the overnight as a chance to experience two destinations in one trip, and even enjoy a night out on the town in Madrid along the way.

Iberia A321XLR
BEN SMITHSON/THE POINTS GUY

More importantly, I’d check off the bucket-list-hotel portion of the challenge by booking The Madrid Edition through Chase Travel. After earning my Chase Sapphire Preferred card’s $50 annual hotel statement credit on the booking, the hotel came in at 31,585 points, a value of 1.25 cents per point.

TANNER SAUNDERS/THE POINTS GUY

I earned 5 points per dollar spent on a Lyft ride to John F. Kennedy International Airport (JFK) with my Chase Sapphire Preferred card* and caught up on movies on the long flight before checking in to The Madrid Edition. The hotel’s iconic Don Pedro de Ribera-designed baroque door was the perfect place for a Brian-worthy selfie.

TANNER SAUNDERS/THE POINTS GUY

At the hotel, I finally got to enjoy cocktails with the cool crowd and played a game of pool in what I’ll say is now my favorite hotel lobby in the world.

TANNER SAUNDERS/THE POINTS GUY

Outside the comfort of my beautiful, nearly all-white room, I had time to roam the streets of Spain’s capital city with a stop for vermouth and tapas at Taberna La Descubierta, where I earned 3 points per dollar spent on dining with my card. I had time to attend a flamenco show and even took a tour of the Royal Palace of Madrid.

TANNER SAUNDERS/THE POINTS GUY

Feeling refreshed, I hopped on a short flight to Marrakech and turned my attention to those beautiful riads and checked in to the dreamy Hotel Izza for two nights for 41,300 points, saving me $521.

In the heart of the walled Marrakech medina, the oldest part of the city and a UNESCO World Heritage site, Hotel Izza was exactly what I wanted: trendy, design-forward and full of character with tiled courtyards, postcard-worthy photo backdrops and a rooftop restaurant full of greenery. It was the perfect home in Marrakech, and another hotel that ended up being bucket list-worthy to me.

Once settled in, I headed straight to the city’s famous souks to take advantage of shopping, and even had the chance to make my own shoes with a Moroccan leather worker (a tanner, if you will, just like me!). And in the buzzy, packed center of the medina, I watched snake charmers play music for swaying cobras just like you see in the movies.

TANNER SAUNDERS/THE POINTS GUY

Before I left Marrakech, Brian surprised me with a bonus challenge to take advantage of some self-care. For me, that was easy, because nobody should leave Marrakech without spending a few hours getting a scrub in a traditional Moroccan hammam — and I did just that (in the spirit of competition, of course!).

TANNER SAUNDERS/THE POINTS GUY

Marrakech was everything I had hoped it would be — like stepping back in time in the souks and medina, a visual feast of graceful palm trees and the snowcapped Atlas Mountains, and some of the friendliest people I’ve ever encountered in my travels.

Back during the planning process, I had thought to myself, “What if I actually head into the desert instead of just staying in the city?” With about 40,000 points left in my budget, it made sense to book a night at the castle-like Kasbah Agafay Hotel & Spa at the edge of the Agafay Desert, where I could traverse dunes on an all-terrain vehicle, which was an activity I had never done before, meeting that condition of the challenge.

A boutique, locally owned hotel, Kasbah Agafay was like staying at a friend’s house … if that house was a traditional desert riad so picture-perfect, it looked like it was right out of a movie. The resort was charming, with beautiful courtyards, a big swimming pool, and lots of plush, colorful seating areas.

It was also close to the activities around the Agafay Desert, like taking an ATV out across the dunes with the glorious Atlas Mountains looming larger and larger in front of me as I cruised across the sand. Growing up in West Texas, I have always felt connected to the desert, and this adrenaline-filled experience left my blood pumping and my clothes muddy (but only because I thought it would be fun to drive through some big puddles).

On this leg of the trip, Brian hit me with another bonus challenge to learn about the local culture. I visited the Saida Berber House at the foot of the mountains to experience how the Indigenous communities lived and ate through a fun and informative cooking class that left me both full-hearted and full of traditional tagine, which I made myself.

TANNER SAUNDERS/THE POINTS GUY

After a few days of traveling across Spain and Morocco, it was time to return home to New York. Looking back on everything I’d experienced over the last few days, it felt nearly impossible that I had booked this entire trip with points … almost as impossible as packing a Berber-made rug, Moroccan pottery, local olive oil and a new pair of handmade shoes in my suitcase. (Note to self: Check the Chase app for any Chase Offers to finally buy a bigger suitcase at a discount.)

The final tally

So how did Tanner and Lyndsey fare in this epic Points Battle? Let’s look at their final tallies.

Lyndsey’s final tally

LYNDSEY MATTHEWS/THE POINTS GUY

Here’s how I took advantage of my 150,000 Chase points, plus a few other card benefits I used:

  • Round-trip flights from Los Angeles to Auckland on Fiji Airways and from Auckland to Queenstown on Air New Zealand: 82,523 points
  • Park Hyatt Auckland: 25,000 points
  • Sofitel Queenstown Hotel & Spa: 37,838 points
  • Other card benefits: Taking advantage of Chase transfer partners (World of Hyatt), using Chase Points Boost on the Queenstown hotel, earning 3 points per dollar spent on dining and earning 5 points per dollar spent on Lyft rides to the airport

Total: 145,361 points

Tanner’s final tally

TANNER SAUNDERS/THE POINTS GUY

And now for my final points roundup, as well as other card benefits I used:

  • Round-trip flight from New York to Marrakech with Madrid stopover: 37,618 points
  • The Madrid Edition: 31,585 points
  • Hotel Izza: 41,300 points
  • Kasbah Agafay Hotel & Spa: 35,440 points
  • Other card benefits: $50 annual hotel credit, earning 3 points per dollar spent on dining and earning 5 points per dollar spent on Lyft rides

Total: 145,943 points

And the winner is …

Lyndsey and Tanner both maxed out their stash of points and Chase Sapphire Preferred card benefits to go on two seriously epic trips that made Brian jealous as he followed along on Instagram.

Whether it was the blend of relaxing spa moments and desert thrills or immersive cultural moments with locals in Morocco, Brian’s pick for the winner of this TPG Points Battle was Tanner.

He creatively put his $50 annual hotel credit to work for a bucket-list hotel stay during a stopover in Madrid and also immersed himself in local culture with leatherworking and cooking classes, all while earning 3 points per dollar spent on delicious Moroccan meals.

The posts from Lyndsey’s trip certainly had Brian hankering for some New Zealand wines and outdoor adventures, though.

Congratulations to both contestants, and stay tuned to see how Tanner uses the points he won!

*Valid through Sept. 30, 2027; does not apply to Wait & Save, bike or scooter rides; activation required.





Source link

Leave a Reply

Subscribe to Our Newsletter

Get our latest articles delivered straight to your inbox. No spam, we promise.

Recent Reviews


QlikView Mapping – Table of content

What is QlikView Mapping?

QlikView Mapping is incidentally creating a table (mapping table) utilizing information or field values from prior tables from various models and sources. The mapping tables are put away in QlikView’s memory just till the content is implemented and from that point forward, it is naturally removed. Mapping makes a table with arranged information fields and values whose script can be availed in various manners via statements or as functions (Rename Field, MapSubstring(), ApplyMap(), Map… Using and so forth) You can supplant field names or esteems during content execution utilizing mapping.

A Mapping table is made to plan the column values among two tables. It is also known as a Lookup table, that is simply used to search for a value from some other table. There are numerous functions accessible in this Mapping strategy to deal with the database table mapping. Mapping tables or Mapping load fills in as a choice to Join statements in the data set. The lookup value and the mapping value are the two columns in the mapping table. Mapping Tables are transitory tables as they are naturally taken out from the information model before the end of the implementation of the content. 

Start learning QlikView Online Course from hkrtrainings to make a bright career in the world of Qlikview!

QlikView Mapping Load Statement

The Mapping Load statement is utilized to stack fields and values into a newly made mapping table in QlikView. 

Syntax

Mapping(loadstatement | selectstatement)

The term Mapping is utilized as a prefix to LOAD or SELECT proclamations directing the framework to save the stacked fields in the mapping table. A mapping table includes two columns of which, the first includes values for examination (as a kind of reference point) and second includes the outcome or wanted values dependent on the correlation. For example, when country codes are used as the reference section and second resultant column is  nation names. The nation codes will be supplanted by the comparing nation names upon content implementation.

Example for mapping load in QlikView,

// Load mapping table of country codes:

MapCountry:

mapping LOAD * 

Inline [

CountryCode, Country

Sw, Sweden

Ind, India

Chn, China

Ity, Italy,

Cnd, Canada

Dk, Denmark

No, Norway

];

Along these lines, this will stack a mapping table called MapCountry which has two columns, Country and CountryCode. The elements of the given mapping tables can be utilized in turn by planning statements and other operations like ApplyMap. 

Qlikview Training Certification

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning

QlikView ApplyMap Function

The QlikView ApplyMap() function brings content from a current mapping table. It also maps the outcome of an expression to a current field from the mapping table. 

Syntax

ApplyMap(‘map_name’, expression [ , default_mapping ] )

Here, map_name is the name given to the pre-existing mapping table. The expression is the field whose outcome must be mapped to a mapping table field. default_mapping is the value, whenever referenced will be returned if there is no match of the field esteems from the current mapping table. The worth is returned all things considered in the output table, if not referenced.

Get ahead in your career with our QlikView Tutorial!

Example of Qlikview ApplyMap Function

Allow us to improve comprehension of this by the assistance of an example. Consider the one with a similar nation code example as we utilized in the mapping load area.

// Load list of store managers, mapping country code to country

StoreManagers:

LOAD *, 

ApplyMap(‘MapCountry’, CountryCode,’Others’) As Country

Inline [

CountryCode, StoreManager

Sw, John Dalton

Cnd, Mary Robins

Ity, Andrea Russo 

Arg, Harry Gibson 

Dk, William Gilbert

Ind, Indrani Sen

No, Daniel Larsen

Rom, Emilia Mark];

// We don’t need the CountryCode anymore

Drop Field ‘CountryCode’;

The resultant table will look as given below.

From this table, the name of the nation relating to the nation code composed next to the store supervisor name is mapped into the last table utilizing an applymap function. Likewise, those nations (like Arg and Rom) for which there were no reference country names in the table “MapCountry” are composed as “Others”. 

Business Intelligence & Analytics, qlikview-mapping-description-0, Business Intelligence & Analytics, qlikview-mapping-description-1

Subscribe to our YouTube channel to get new updates..!

Benefit of utilizing Mapping table and ApplyMap Function: 

  • Aids in dodging joins in QlikView. 
  • Aids in diminishing tables from the data model to simplify it, productive and justifiable. 
  • Mapping Table is only there during load. 
  • Missing rows can be dealt with by its third parameter  consequently aids in taking care of the null qualities and utilized in information integrity in ApplyMap Function.
  • It disregards the duplicate rows in the table. 
  • We can utilize composite keys as a critical column in the table. 
  • We can make different maps from a similar table. 
  • It saves processor time and memory. 
  • It cleans the information by eliminating the information disparities.

QlikView Architecture

QlikView is developed with a totally different way to deal with information disclosure than other conventional platforms. It doesn’t initially assemble an inquiry and afterward bring the outcome dependent on the query. It structures relationships between various data objects when it is stacked and prompts the client to investigate the information in any capacity. The information drill down ways can occur toward any path as long as the information is accessible and related. A client can assume a part in making the connection between information components utilizing information modeling approach accessible in QlikView.

Qlikview Mapping Architecture

QlikView’s architecture comprises a front end to picturize the prepared information and a back end to give the security and distribution component for QlikView client records. The image given above portrays the inside working of QlikView. 

Front End

Front end in QlikView can be defined as a browser oriented access point for reviewing the QlikView archives. It includes the QlikView Server, that is fundamentally utilized by the Business clients to get to already made Business Intelligence reports via a web or intranet URL. Business clients investigate and interface with information utilizing this front end and determine decisions about the information. They team up with different clients on a given arrangement of reports by sharing bits of knowledge and investigating information together, continuously or offline. These client archives are in the configuration .qvw, which can be put away in the windows OS as an independent record. The QlikView server in it deals with the customer server correspondence between the client and QlikView backend framework.

Back End 

The QlikView backend comprises QlikView publisher and QlikView desktop. The QlikView desktop can be considered as a wizard-driven Windows environ, that has the highlights to stack and change information from its source. Its simplified element is utilized to make the GUI format of the reports which gets noticeable in the frontend. The record types that are made by the QlikView desktop are put away with an extension of .qvw. These are the documents which are given to the QlikView server in the front end, that serves the clients with other records. .qvw documents can be adjusted to store the information only records, called as .qvd records. They are records that include just the information and not the GUI parts. The QlikView publisher is utilized as a circulation service to convey the .qvw reports among different QlikView servers and clients. It manages the approval and access advantages. It does the immediate stacking of information from the data sources by utilizing the association strings characterized in the .qvw records.

Highlights of QlikView planning 

Some significant highlights of QlikView planning are: 

  • It is like the query function where a field esteem is utilized as a source of reference to another field existing in the mapping table and returns a coordinating outcome. 
  • A mapping table is always made by Mapping Load or Mapping Select prior to applying a Map work. 
  • A mapping table stays briefly in the memory of QlikView till the next time content implementation is finished. It is exited once a content is executed. 
  • The transitory mapping table doesn’t influence the fundamental information tables put away in-memory of QlikView. 
  • Any mapping table can be reviewed and reutilised in a content however many occasions as a client needs. 
  • The principal field is known as a key and the subsequent field or column is alluded to as mapped value ALWAYS. 
  • All the planning necessities can be done in a solitary script.

Qlikview Training Certification

Weekday / Weekend Batches

Conclusion

The blog dealt with QlikView mapping with QlikView ApplyMap() and mapping load. We get to know more about mapping, how to make mapping tables utilizing the Mapping Select statements or Mapping Load lastly and how to utilize mapping via the ApplyMap() work.

Other Related Articles:



Source link