Posts

Featured Post

Types of Data Visualizations ǀ Data Analytics

 There are many types of data visualizations. The best chart depends on the number of variables, the amount of data, and whether the data shows change over time or compares values at one point in time. Line Chart Use a line chart to show continuous data, many data points, or a trend over time. Examples include quarterly sales over five years, weekly customer counts, or a stock price during one day. Best practices: Label both axes. Put time on the x-axis and values on the y-axis. Use a solid line to show continuity. Limit the chart to four or fewer lines; add a legend if needed. Remove or reduce gridlines to avoid distraction. Adjust the y-axis carefully so the chart emphasizes change without exaggerating it. Column Chart Use a column chart to compare values across categories using vertical bars. Examples include the populations of BRICS countries, sales for major car companies, or average test scores for several classes.[ canva ][ learn.microsoft ] Best practices: Label the axes....

Excel Formulas and Functions ǀ Data Analytics

Image
Excel formulas and functions help you calculate and analyze data. A formula is a calculation you create yourself, while a function is a ready-made calculation built into Excel. Formulas Every Excel formula begins with an equal sign ( = ). This tells Excel that the cell contains a calculation, not ordinary text or a number. For example: =1+2 Excel will display 3 , not the text =1+2 . Formulas can use numbers, such as 5 , or cell references, such as: =L1/L7 This divides the value in cell L1 by the value in cell L7 . Cell references There are two main types of cell references: Type      Example    What happens when copied Relative reference                L1/L7                Changes based on the formula’s new location Absolute reference $L$1/$L$7           Always refers to the same cells Relative references are the default. For example, if you...

ETL and ELT Processes ǀ Data Analytics

Image
 ETL and ELT Processes ETL and ELT are two ways to move data through a pipeline. Both start by extracting data, but they differ in when the data is transformed. ETL: Extract, Transform, Load In ETL, data is first collected from different sources, then cleaned and converted into a consistent format, and finally loaded into a database or data warehouse. Extract — Data is gathered from sources such as spreadsheets, PDFs, emails, databases, XML files, or flat files. Transform — The data is standardized and cleaned before storage. This may include converting units, joining data from multiple sources, sorting, calculating new values, removing blank or incorrect records, and validating formats such as dates, times, and locations. Load — The cleaned, transformed data is loaded into the target database, where database rules check that required fields are present and values are consistent. ETL is useful when data must be carefully prepared before it can be analyzed. ELT: Extract, Load, Trans...

Dealing with Customers ǀ Front Office Services

Image
  Guest Cycle There are four stages of the guest cycle. The guest cycle refers to the flow of operations that occur in a hotel from when a guest chooses a hotel, to checking out. The four stages are: Pre-arrival Stage The pre-arrival stage is a crucial stage of the guest cycle for establishments since this is where the guest decides what hotel to choose. The factors that are commonly considered by guests when choosing a tourism establishment are: Previous experiences with the establishment The establishment’s advertisements Recommendations from travel agents, friends, or business associates The establishment’s location The establishment’s name or the name of the hotel chain operation Another consideration considered by a guest is the ease of making hotel reservations. Thus, if a FO staff or the hotel’s system is incompetent when receiving reservation requests, guests might be turned off to stay at your establishment. How a front office reservation agent also describes the hotel’s s...

Large Language Model (LLMs)

Image
What is LLM? A n LLM is a type of GenAI designed to produce human-like text . The LLM's primary function is to generate contextually appropriate continuations of a given input prompt by predicting the most probable sequence of words.  A simple way to understand this is through an example. Given the prompt: “The capital of the Philippines is ______” The LLM predicts and fills in the most probably next word. This predictive mechanism enables LLMs to perform a wide range of natural language processing tasks such as summarization, translation, question answering, content generation, and dialogue simulation with a high degree of fluency and relevance. Examples of LLMs include ChatGPT, Google Gemini, DeepSeek, Microsoft Copilot, and other advanced AI chatbots.  Common LLMs in the Market ChatGPT (https://chatgpt.com/) -  Launched in November 2022, ChatGPT is a conversational AI developed by OpenAI. It quickly became one of the most widely used LLMs globally, marking a major br...

Understanding AI

What is AI? AI stands for Artificial Intelligence.  This refers to the ability of machines to mimic human intelligence, enabling them to perform tasks such as learning, problem-solving, and decision-making. It is also the process of replicating human knowledge that involves: Building models (computer programs) trained on massive amounts of data; To perform tasks such as classification, prediction, and generation with outstanding accuracy. Simply put, it means getting computers and machines to do things that normally require human intelligence. How AI Shows Up in Daily Life? Have you ever: Used face recognition to unlock your phone? Seen spam emails automatically sorted into your spam folder? Asked Siri or Google a question? Gotten suggestions from Netflix or Spotify? That’s AI in action!   I’m not even referring to ChatGPT. Even before its rise, AI was already all around us—often operating behind the scenes , whether we noticed it or not. How Does AI Work? Take Inputs Lea...

Performing Clerical Procedures ǀ Front Office Services

Image
  In accordance with organizational procedures, front office personnel handle document processing as part of their regular responsibilities, such as: Guest records Incoming and outgoing correspondence Business accounting Memos Sources of Room Reservation Modes and types of reservations Telephone Walk-in Online Manual reservation Computer Reservation System A. Filing and Arranging Front Office Documents Filing - is the process of storing and arranging documents according to a particular classification. Categories of Filing Alphabetically Numerically Geographically By subject Chronologically B. Front Office Forms 1. Pre-arrival forms - must be prepared before the guest arrival. Guest reservation record -  Reservation file - a computer-based collection of reservation record Reservation rack slip - filed in a reservation rack 2. Arrival forms  - guest must accomplish upon the registration/ check-in process.  Registration card - printed form Guest Registration r...

History of Hospitality Industry

Image
   Ancient Period:   The Sumerians  – The recorded history of the hospitality industry began with the Sumerians who lived in  Mesopotamia  near the  Persian Gulf . Began the recorded history of the hospitality industry. They were the first to establish  taverns  that provided food, drinks, and shelter to  Sumerian traders and travellers . Early Traders  – In 2000 BC, Middle Eastern traders set up the  caravanserai  to provide food and shelter to traders and travellers. They were the forerunners of the inns. Caravanserai is an example of an early inn. The  Ancient Persians  – constructed  Khans , a combination of stables and sleeping accommodations that served  traveling caravans . Medieval Period Dark Ages   –  Fall of Roman Empire . In Europe,  Charlemagne  established  rest houses for pilgrims  to provide protection and hospitality. Renaissance : 1350 AD to 1600 AD  ...

Contact Form

Name

Email *

Message *