N24.com.tr’s Post

Melco Resorts & Entertainment Limited partners with John Keells Holdings PLC for the US$1+ billion integrated resort in central Colombo. Rebranded as "City of Dreams Sri Lanka," it promises to redefine luxury hospitality and entertainment in South Asia with 800 hotel rooms, dining options, MICE facilities, and more. Melco secures a 20-year casino license and will operate the gaming area, along with managing the top floors under its Nuwa brand. The estimated initial investment in the casino is approximately US$125 million. Fit-out of the casino is set to commence, with non-gaming facilities expected to open in Q3 2024 and casino operations in mid-2025. Further gaming expansion is possible based on performance and market conditions. Source : Yahoo Finance https://lnkd.in/gKYGDgUz

Singapore begins second phase of casino resort development

Singapore begins second phase of casino resort development

Sri Lanka, an emerging gaming destination, will soon host its first integrated resort, City of Dreams Sri Lanka, set to open in 2025. This venture will be managed by the experienced and renowned multinational gaming operator, Melco Resorts and Entertainment. Currently, Sri Lanka has issued six casino licenses, with Melco set to receive the seventh, making it the second international investor in this sector. In late 2022, a Singapore-based entity, 'Kreate Design Pte Ltd,' signed an agreement to develop a casino within the iconic Lotus Tower. Sri Lankans can gamble subject to an entry levy of US$50, and the government is currently establishing a gaming regulatory body. However, the main market potential lies in the subcontinent region, including India, Nepal, Bangladesh, Pakistan, Bhutan, and the Maldives, which collectively have a population of over 1.7 billion people.

Which brand is this ad for at first glance? Vespa or ITC? Will you pick a specific resort for its scenic surroundings or for its unique ambience, services, and various amenities that makes for a good stay? To me, this ad might be trying to break the clutter from the usual hotel advertising but in doing so the brand seems to be completely lost.  Every ad is not a good story after all.  

Unlock Revenue Potential with OranaStay's Upselling Capabilities! Are you leaving money on the table by not offering your guests personalized experiences and upgrades? Our concierge app helps STR, Independent Hotels and Boutique Hotels maximize revenue through targeted upselling opportunities. With OranaStay, you can offer your guests: - Room upgrades and add-ons - Local experiences and activities - Dining and spa reservations - Transportation and more! Our app allows guests to upsell themselves at every stage of their journey, increasing average order value and driving revenue growth for your hotel. Take control of your revenue stream and give your guests the luxury experience they deserve. Learn more about OranaStay's upselling capabilities and start maximizing your hotel's potential today! #STR #OranaStay #DigitalConciergeApp #upselling #hotelrevenue #airbnb #vrbo #customerexperience #guestautomation #hostaway #guesty #OnwerRez #shorttermrentalpropertymanagers

OYO 2950 Grand Suites Palace Syariah Getting in and around Puncak is a breeze when staying at For lazy days and nights, in-room conveniences like 24-hour room service and daily housekeeping let you make the most of your room. Please be advised that smoking is not allowed in the hotel to allow cleaner air for all guests. Equipped with handy amenities, guestrooms at One doesn't need to look far as the hotel enjoys close proximity to sightseeing options and local attractions. The most popular local attraction is probably Little Venice Kota Bunga only 3.7 km away. Rooms don't get much cheaper than here, being less than 99% of the city's accommodation. Know you'll get excellent dining options here, where past guests have rated onsite or nearby dining above 92% of the city's accommodation. It's hard to beat the room comfort here, which is rated higher than 91% of other accommodations in Puncak. #oyo2950grandsuitespalace #hotelkdm

Here's my Tuesday Thrower..... Hotel management companies can not succeed outside the united states. It is different format and operating style. It is soled based on experiences and amenities along with all inclusive offerings. Also hotel management companies mostly operate big box brands and aren't use to the boutique style brands and offerings. It is a style soled based on experience and service. Especially in Latin America where Web3, NFT, Crypto, metaverse, and ETC is the talk of the town. There is obviously a reason why the big box brands are left with very less presence in these markets due to the consumer wanting more then just a bed. “Brands don’t know very well the Latin American market,” Galindo said. “The brands are specifically made for Americans. They have to change different things … really make all the hotels for the Latin American market. Not all the brands are so open (to that concept). https://lnkd.in/eWESUGFP

Nice report from Rachael Rothman, CFA, ISHC and team. We have been tracking the blurring of lines between multifamily and hospitality since before covid. There will continue to be new and innovative business models that are created to meet the growing consumer demand for furnished, flexible living. Some of the novel approaches may indeed come from multifamily players, not just the hospitality companies. We remain highly interested in pursuing deals that live somewhere between the multifamily and hospitality industries. #hospitality #multifamily #commercialrealestate #furnishedapartments #flexibleliving #hotels #aparthotel #apartments #hybrid #realestateinvestment #realestatedevelopment

CREATE TABLE hotel_revenue (   hotel_id INT,   month VARCHAR(10),   year INT,   revenue DECIMAL(10, 2) ); -- Insert sample records INSERT INTO hotel_revenue (hotel_id, month, year, revenue) VALUES (101, 'January', 2022, 15000.50), (101, 'February', 2022, 18000.75), (101, 'March', 2022, 20000.00), (101, 'April', 2022, 20000.00), (101, 'May', 2022, 20000.00), (101, 'June', 2022, 20000.00), (101, 'July', 2022, 26000.00), (101, 'August', 2022, 28000.00), (102, 'January', 2022, 12000.25), (102, 'February', 2022, 14000.50), (102, 'March', 2022, 16000.75), (101, 'January', 2023, 17000.25), (101, 'February', 2023, 19000.50), (101, 'March', 2023, 21000.75), (102, 'January', 2023, 13000.50), (102, 'February', 2023, 15000.75), (102, 'March', 2023, 17000.25), (103, 'January', 2022, 11000.25), (103, 'February', 2022, 13000.50), (103, 'March', 2022, 15000.75), (104, 'January', 2022, 14000.50), (108, 'May', 2022, 31000.75), (108, 'April', 2022, 28000.75), (108, 'June', 2022, 16000.75), (108, 'August', 2022, 16000.75), (104, 'March', 2022, 18000.25), (103, 'January', 2023, 12000.50), (103, 'February', 2023, 14000.75), (103, 'March', 2023, 16000.25), (104, 'January', 2023, 15000.75), (107, 'February', 2023, 17000.25), (106, 'March', 2023, 19000.50); Find the top-performing two months  by revenue for each hotel for each year. return hotel_id, year, month, revenue */ select * from hotel_revenue ✅ with cte as ( select hotel_id,month,year,revenue,rank() over(partition by hotel_id,year order by revenue desc) as rnk, dense_rank() over(partition by hotel_id order by revenue desc) as rk,  ROW_NUMBER() OVER (PARTITION BY hotel_id, year ORDER BY revenue DESC) AS month_rank from hotel_revenue) select * from cte where rnk<=2 select * from cte ✅ WITH CTE1 AS ( SELECT  hotel_id, year,  month, revenue, DENSE_RANK() OVER(PARTITION BY hotel_id, year ORDER BY revenue DESC) drn FROM hotel_revenue ) SELECT hotel_id, year,  month, revenue FROM CTE1 WHERE drn <= 2 ✅ WITH RankedMonths AS (   SELECT     hotel_id,     month,     year, ✅     revenue,     ROW_NUMBER() OVER (PARTITION BY hotel_id, year ORDER BY revenue DESC) AS month_rank   FROM     hotel_revenue ) SELECT   hotel_id,   year,   month,   revenue FROM   RankedMonths WHERE   month_rank <= 2 ORDER BY   hotel_id,   year,   month_rank; ✅ follow for more content Vyas Adithya Ankit Bansal Codebasics Dhaval Patel