Hotel Online
News for the Hospitality Executive


                                                       
                                                        At HITEC Visit Aptech in Booth # 901




Aptech VUE: The Big Data Challenge – Multiple Properties with Multiple Flags
Meet Big Challenges; Reap Big Rewards with Business Intelligence
 

Hotel Companies with Large Diverse Portfolios Make Better Decisions When Business Intelligence
Overcomes Multi-System Data Gathering and Translation Challenges


By Cam Troutman, Vice President of Aptech Computer Systems

June 4, 2013 – There are more hotel brands using more property management systems (PMS) today than ever before. Each franchise has its own system requirements, and many are proprietary. When operators shop for a business intelligence (BI) system, the first thing they want to know is: Will it access and centralize data from various PMS applications at their properties? This is the right question. Data gathering and consolidation are challenging, but there are big rewards from basing business decisions on big data.

The central source of performance data at most hotels is the PMS. There are about eight major PMS solutions used today. Each has its own program language, data format, posting codes, field descriptions, and other unique characteristics. When Aptech puts its Execuvue® Business Intelligence system to work for a hotel company, the primary job is to extract, transform, and load data from multiple property systems into Execuvue’s centralized database for analysis. Click here for more on Aptech’s products and services.

Cam Troutman, Vice President
of Aptech Computer Systems


Job 1: Extracting data from dissimilar property systems
Operators tell us the property and company data they want to measure, and we automate the extraction processes. Aptech works with all leading PMS vendors and franchisors to extract daily property data. Aptech is the only provider of a fully integrated enterprise accounting, business intelligence, and planning hotel software suite to the hospitality industry.
 
Data extraction offers several challenges. If the PMS does not have a standard data export utility, we must create a custom export process, or ‘scrape’ the data from reports. Another issue is assessing the level of available data from each property. Some PMS solutions do not capture market segmentation; other systems cannot access general ledger (G/L) information, or they report certain data monthly. These ‘data gaps’ limit BI analysis. Lastly, it is essential that we can repeat the extraction process.
 
Job 2: Data transformation
Once Aptech extracts the data from each of the company’s property systems, the second step is transforming and transferring it to the Execuvue database for analysis and use. The primary challenge in data transformation is geographical. In the past, PMS solutions were on property. Today, they may be hosted at a company’s corporate headquarters, at a third-party hosting facility, or at the management company’s offices. To complicate matters further, each PMS has a different data format. It might be XML, delimited files, Excel, or even PDF. This is the starting point for the data transfer; the end point is loading the data into a unified multi-property corporate BI database.
 
Job 3: Data loading
Execuvue standardizes and loads multiple property data formats into the hotel company’s BI database. However, a new challenge is identifying and aligning each property’s daily metrics with last year, budget, forecast, and its Smith Travel data. We map the unique codes each hotel or chain uses and combine them in appropriate groupings for enterprise rollups and comparisons for rooms sold, room revenue, and many other performance measures. Experience with chains and large hotel companies is valuable in this process because each company has its own operating definitions. For example, “occupancy %” sounds like an easy calculation, but brands use different equations based on how they count out-of-order, house use, comp, and other room factors. We work with the hotel company to standardize these measures and implement its definition of occupancy percent.
 
Extracting and loading historical PMS and G/L data is also a challenge. PMS and G/L data have different codes. We verify if historical data is available on a property’s legacy revenue reporting system. Execuvue automatically imports Smith Travel Research (STR) data for many operators. Although Execuvue automatically imports PMS data daily, STR delivers its data on Wednesdays. Creating market and property comparison reports is essential for sound management, so Execuvue provides daily property numbers beside the STR data for a block of time that is always within a week of the reporting date.
 
The Big Data Reward
The rewards are huge when executives have a compressive big-data performance picture of each of their properties, markets, and brands available for management decisions. From that moment forward, the company bases its business decisions on accurate, actionable data. Aptech’s solutions enable quick, accurate decision-making and the ability to be proactive operationally and financially.

Aptech’s Execuvue BI, PVNG Accounting System, and Targetvue Enterprise Planning and Budgeting will be at HITEC 2013, June 25 – 27 in the Minneapolis Convention Center. Come by Booth 901 to meet the Aptech team.

Aptech Computer Systems  
Aptech Computer Systems, Inc. is the only provider of a fully integrated enterprise accounting, business intelligence, and planning ecosystem to the hotel industry. Aptech offers 100% more customer-centric options for hosting, pricing, and product solutions than any other hospitality-focused systems providers. All of its solutions are 100% hotel specific and all of its clients are companies that own or manage hotels. Aptech introduced business intelligence into the hotel industry and offers a solid resource of hospitality professionals. Incorporated in 1970, Aptech is an IBM Software Value Plus partner and Premier Solution Provider.
 
Aptech’s state-of-the-art products include Profitvue® enterprise back office accounting, Execuvue® business intelligence, Webvue® internet accounting support, and Targetvue planning and budgeting. Clients comprise over 3,000 properties - including large chains, multiple-property management companies, and single-site hotels. Aptech’s solutions give operators the ability to be proactive operationally and financially.  Execuvue and Profitvue are registered to Aptech Computer Systems, Inc. All other trademarks are owned by their respective holders. For more information, please visit www.aptech-inc.com


 
Contacts:

Aptech Computer Systems

Cam Troutman, Vice President
135 Delta Drive
Pittsburgh, PA 15238
Phone: 800-245-0720 or 412-963-7440
Email:  [email protected]
www.aptech-inc.com


Media Contact:
Julie Keyser-Squires, APR
Softscribe Inc.
180 River Springs Drive NW
Atlanta, GA 30328
Phone: 404-256-5512
Email:  Julie(at)softscribeinc.com
www.softscribeinc.com



  Receive Your Hospitality Industry Headlines via Email for Free! Subscribe Here  

To Learn More About Your News Being Published on Hotel-Online Inquire Here

Also See: Aptech, MSI Implement Interface for Data Communication Between Properties and Execuvue® Business Intelligence; MSI – Execuvue Interface Enables Right-Time Property Performance Analysis for Companies with Multiple Properties, Flags, and Profit Centers / May 2013

Noble House Selects Aptech Financial Solutions for 17 Properties; Noble Installs Profitvue® Enterprise Back Office Accounting; Will Implement Execuvue® Business Intelligence and Targetvue Planning/Forecasting by Mid-Year / April 2013

Aptech BI, Accounting, and Forecasting Systems Selected by 4 Hotel Companies; Multi-Property Companies and Freestanding Hotel Operators Rely on Execuvue® Business Intelligence, Profitvue® Enterprise Accounting, and Targetvue Budgeting and Forecasting to Optimize Profitability, Strengthen Operations / February 2013

Video Report: Business Intelligence Inspires Top Hotel Execs for 2013; Operators Discuss why They Turned to BI for "Fact-Based" Portfolio Management / January 2013

Aptech Financial Solutions Selected by Eight Hotel Companies with 120+ Properties; Execuvue® Business Intelligence, Profitvue® Enterprise Accounting, and Targetvue® Budgeting and Forecasting to Optimize Profitability for Growing Number of Hotel Companies and Operators / October 2012

Benchmark Powers Expansion with Centralized Accounting Platform; Management by the Numbers: Benchmark Integrates New Properties into Company Management Processes Quickly with ‘Private-Cloud’ Back Office System / October 2012

Long-Term Vendor Partnerships Prove To Be A Savvy Business Strategy; Operator-Vendor Relationships Build Trust for Off-Site Hosting that Protects Data, Increases Security / August 2012

Aptech Takes Business Intelligence to Next Level with Versatile Cloud-Based System that Adapts to all Mobile Platforms; Leading Hospitality Companies Implement Mobile Strategy; Install Advanced Execuvue® BI with Aptech Hosting / June 2012

Multiple Properties, Multiple Flags: Texas Western Uses Cloud BI to Automate Data Gathering, Analysis and Reporting for 53 Hotels; Central Data Hub Reduces Accounting Staff, Eliminates Technology Responsibility / June 2012

Sandals Resorts International Optimizes Profitably with Big Data; World Famous Luxury Resort Chain Puts KPIs for 22 Entities Under a Microscope Daily / May 2012

Highpointe Installs NextGen Business Intelligence; iPad-Ready BI Automates Data Gathering, Analysis, and Report Distribution; Remotely Hosted 'Big Data' BI Platform Safeguards Company Data, Frees Highpointe from System Responsibility / May 2012

Five Hotel Companies Streamline Management Processes with Aptech’s Business Intelligence and Enterprise Accounting; Multi-Property Clients Prefer Aptech for Ease of Use, Performance Metrics, and Automated Data Downloads / February 2012

Horizon Hospitality's Success Formula: Strong Markets, Strong Managers, Strong Tools; Corporate Execs Work Hard to Free Up Property Managers to Focus on Revenue / January 2012

Four Hotel Companies Select Aptech Business Intelligence, Accounting and Budgeting Solutions; Hotels across Country Implement Aptech Systems to Grow Portfolios, Assess Acquisition Profitability, and Simplify Back Office Operations / November 2011

SKY Hospitality Demonstrates That Success Comes in All Sizes; Aptech Profitvue Creates Back Office Efficiencies That Boost Investor-Friendly ROI / October 2011

Three Hotel Companies Select Aptech's Profitvue ASP Back Office Accounting; Hilton Garden Inn, Two Independent Resorts use Internet-Based Profitvue Back Office System to Manage Property Financial Success / August 2011

Aptech Launches Suite of New Financial Solutions at HITEC; Enhancements include Ease of Use; Streamlined and Automation Capabilities; Improved Ad-hoc and Analysis including Text Interpretation / June 2011

Concord Hospitality Upgrades to Latest BI Technology with Execuvue; iPhone- and iPad-Compatible Execuvue Provides Actionable Insights Everywhere / June 2011

Heritage Hotels & Resorts Runs Seven Southwestern Hotels from the Cloud; Properties in Arizona and New Mexico Deliver Same-Day Performance Management Reports / May 2011

Aptech Announces Profitvue V 14.5 Upgrade for Single and Multi-Property Accounting; Comprehensive Upgrade Includes Enhanced Multi-Company Processing; 1-Button PDF, Excel Report Conversion; Automated ACH Processing / May 2011

Prospera Hospitality Leverages Centralized Financial Accounting to Achieve Investors’ Business Goals; Web-based System Enables Daily Performance Visibility across 18-Property Portfolio / April 2011

Aptech Congratulates Clients Named to Hotel Business’ List of "Top 100 Management Companies"; Eleven Top-Ranked Hotel Companies Rely on Aptech Business Intelligence and Accounting to Earn Leadership Kudos / April 2011

Ascenture Hotel Group’s Evolution Marked by Dynamic Growth; Meticulous ‘Managing by the Numbers’ Spurs Profitability, Investor Satisfaction / March 2011

SKY Hospitality and Widewaters Hotels LLC Select Aptech’s Hospitality Performance Management Solutions; Ease of Use, Flexibility, Customer Support Make Profitvue and Execuvue Top Choice / February 2011

Horizon Hospitality Implements Aptech’s Profitvue Enterprise Accounting; Management Firm Selects Aptech for its Extensive Hospitality Industry Experience / January 2011

Guest Sentiment Information Strengthens Business Intelligence, Answers Performance Questions; Web Reviews, Written Survey Card Comments Translated to Metrics for Analysis / October 2010

Aptech Celebrates 40 Years of Leadership with Addition of Text Analytics to Capture Customer Sentiment Information – Releases Highlight Video; Aptech Focuses on Relationships, Technology Innovation; Creates Solutions when Clients Need Them / October 2010

Aptech Selects Clarabridge to Add Guest Sentiment and Text Analytics to Execuvue® for Property Performance Measurement; Execuvue Business Intelligence Correlates Guest Sentiment Data with Property Performance for Global View of Hotel Operations / September 2010

Aptech’s Profitvue Back Office Accounting Selected by Four Hotel Companies; Profitvue Picked for Its Comprehensive Hotel Accounting Functionality, Professional Support and Training / July 2010

Hershey Entertainment & Resorts Puts Data Gathering and Consolidation Online for 200+ Profit Centers; Hospitality Leader Tracks the “Real Numbers” Daily With BI System for Solid Management Decisions / June 2010

Aptech Celebrates 40th Anniversary – Propelling Hospitality from Mainframes to Cloud Computing; “We Have Your Back and Do What It Takes to Make You Successful:” Jay Troutman, president of Aptech Computer Systems / June 2010

Aptech Launches EV Lite, a New Cost Effective, Web-Based Operational Reporting Solution for Multi-Property Operators; EV Lite Automates Data Gathering, Delivers Performance Reporting, Identifies Exceptions to Increase Profitability / May 2010

Aptech Releases Comprehensive Accounting Enhancements in New Profitvue Version; User-Driven Upgrades Strengthen Hospitality Industry’s Leading Enterprise Accounting System / May 2010

La Quinta Inns & Suites Leverages Business Intelligence to Analyze Operations, Increase Profitability; Corporate Executives Have Daily Performance Reports at 8 a.m. for 400 Properties / March 2010

How to Use Data to Increase Your Profitably in A Changing Business Environment; Leading Hotel Management Firm Uses BI Tools for Smart Revenue Management Decisions / February 2010

Hotel Operators Tap New Profitability Strategies that Work in the Current Economy; Companies Save Money, Improve Performance with Reduced Staff; Leverage Business Intelligence and Accounting Tools / October 2009

Aptech Profitvue Back Office Selected by Three Hotel Companies; Profitvue will deliver back office accounting for operators of single and multi-property hotel groups / September 2009

Business Intelligence: Essential for Today's Hospitality Environment; Top companies rely on BI systems to spot unnecessary costs, solve problems quickly / June 2009

Aptech Computer Systems Launches Enhanced Innvue for Data Consolidation across Diverse Multi-Property Systems, Next-generation solution provides centralized web-based data capture, eliminates manual spreadsheet processes / June 2009

Cam Troutman Named Vice President and Officer of Aptech Computer Systems; Extends to the next generation Aptech's commitment to service and long-term partnership with hospitality industry clients / June 2009

Focus on Labor: Hoteliers Use Business Intelligence to Spot Unnecessary Expenses; Operators integrate data from time/attendance systems, PMSes to control their largest variable expense / May 2009

Hermani LLC Implements Aptech's Profitvue Back Office Accounting System for Multiple Properties; Effortless installation, ease of use enables more efficient accounting processes / April 2009

How Good Are You at Managing Profitability? In 2009, Operators Look to Flow-Through Reporting for Profitability Analysis; Aptech spotlights key measurement tool to build stronger managers, benefit owners and investors / March 2009

Benchmark Hospitality Selects Aptech's Execuvue Business Intelligence; Benchmark taps Execuvue to centralize data gathering, analysis for 30 independent hotels for greater operating efficiency and increased ownership profitability / January 2009

Chains Use Power Reporting and Dashboards for Better Decisions from ‘Big Data’; The ‘why’ behind the numbers – Execs use new ‘guided ad-hoc reporting’ to manage by exception / December 2008

NextGen Business Intelligence 'Humanizes' Technology, Information Delivery; Execuvue's New Cognos BI 8.3 Business Intelligence Capabilities Enables Customized Information Delivery for Faster Decisions and Greater Profitability / June 2008

Inland American Lodging Corporation Selects Execuvue Business Intelligence Software for Extensive Hotel Portfolio; Hotel owner will use Aptech's Execuvue to consolidate, analyze operating data from multiple management companies for better business decisions / June 2008

Noble Investment Group Uses Same-Day Business Intelligence to Verify Management Strategies, Convert Data into Profitable Decisions / June 2008

Aptech's Execuvue Business Intelligence Implemented by LQ Management L.L.C. for Its More than 600 La Quinta Hotels; Execuvue delivers same-day corporate reporting to guide management decision making / April 2008

Aptech Installs Profitvue Enterprise Back Office at Heritage Hotels and Resorts and IHP Hospitality Group; Profitvue consolidates multi-property reporting and standardizes financials on centralized ASP platform for both operators / March 2008

In The Beginning was the 3-Ring Binder: Hospitality Business Intelligence Shapes Operations for 10 Years; Spreadsheets to dashboards; evolution of BI from technology experiment to the must-have profitability tool / February 2008

Coral Hospitality Selects Profitvue® from Aptech to Standardize Financial Reporting Across Portfolio; Ability to support extensive chart of accounts supports company's unique growth requirements/ January 2008

Konover Leverages Financial Automation to Add 15 Properties in 12 Months; Company expands portfolio by 15 properties without amassing excessive personnel costs / January 2008

Noble Investment Group Implements Aptech's Targetvue Budgeting and Forecasting System, Execuvue Business Intelligence; Noble automates business analysis, budget planning to support growth of rapidly expanding portfolio / December 2007

Oliver Companies Credits Rapid Growth to Well-Trained Employees, Effective Performance Management Tools; Owner operator with short hospitality history develops, acquires seven hotels in three years / October 2007

Strand Development Nearly Doubles Portfolio - Automates Ownership Services with Tech Partner; Strand adds 12 properties, but only one additional accounting staffer / October 2007

Business Intelligence: How Dashboards Drive Profitability; Is your business running hot or cold? Check the dashboard / June 2007

Aptech Computer Systems Launches Innvue; Increases Multi-Property Data Gathering Capabilities; Innvue provides web-based data capture, eliminates manual spreadsheets / June 2007

Multi-Flag Operator Leverages Shared Intelligence for Centralized Financial Reporting, ROI for Owners Boykin Management Company uses enterprise-wide Web platform to fine-tune property performance for ownership success / June 2007

Multi-Flag Operators Support Growth with Centralized Systems, Partner with Tech Provider; PCH Hotels & Resorts and Charter One Hotels & Resorts maintain steady growth with scalable corporate systems / May 2007

Aptech's ASP-Based Accounting Software in High Demand by Chains, Properties; Saves properties money, eliminates system responsibility / March 2007

Extended Stay Hotels Installs Aptech's Execuvue Business Intelligence for 681 Properties; Aptech BI system helps lower operating costs, boosts value / Februrary 2007

Sage Hospitality Resources Satisfies Owners, Associates and Guests for Portfolio Growth; 48-Property Sage Combines Financial Metrics with Guest Information for Real-Time Budgets, Forecasting to Boost Property Performance / January 2007

Aptech Blasts Past 2,500-Property Milestone; Hospitality business intelligence becomes a mainstream “must-have” business solution / January 2007

Konover Hotel Corporation, Boykin Management Select Aptech Financial Systems; Konover's 20 properties and 10 Boykin hotels to standardize on Aptech financial platform / November 2006

Merritt Hospitality Installs Aptech's Market-Leading Business Intelligence Solutions; Merritt uses BI solutions to gather, analyze daily data from 31 properties; eyes growth and $500 million in acquisitions annually / August 2006

Aptech’s Data Manager Automates Multi-Property Information Gathering; Replaces Manual Spreadsheets, Centralizes Financial Data for Faster Decisions / June 2006

At Pinnacle Hotel Management, GM Entrepreneurs and Centralized Accounting Support Growth; When the corporate office handles / May 2006

Benchmark Selects Aptech’s Customized Software Solutions for 33 Properties / March 2006

It is 10am: Do You Know How Much Money Your Owners Made Last Night? Strand Development Company Does; Multi-flag operator provides customized owner financials, forecasting techniques with dashboard business intelligence hotel software / February 2006

Former Wyndham-Controlled Hotels Install Profitvue? Back Office to Improve Accounting / January 2006

Sentry Hospitality Installs Aptech ASP Centralized Accounting / October 2005

36-Property Hersha Hospitality Trust Selects Market Leader Aptech / June 2005

Aptech Announces Targetvue; Automates Enterprise Planning and Budgeting; Targetvue is Newest Application for Driving Growth Goals, Profitability for Owners and Operators / June 2005

Ashford Hospitality Trust Selects Aptech for 54-Property REIT / June 2005

Winner’s Circle: Interstate Hotels & Resorts Teams with Trusted Suppliers to Deliver Security, Profitability to Owners / December 2004

ARAMARK Harrison Lodging Grows Conference Center Niche Through Marketing, Services and Strong Financial Reporting / October 2004

Midscale Operators Navigate with Centralized Business Intelligence, Enterprise Accounting; Use 2/3 Less Accounting Staff / June 2004

Aptech Computer Systems Completes Rollout of its Profitvue® ASP Enterprise Back Office Accounting System for Amerimar Enterprises, Inc. / June 2004

Real Estate Developer Belz Enterprises Boosts Corporate Value with Hotel Group Business Intelligence Gains - Prestigious Peabody Hotel Group Operates Paperless; Internet Back-Office and Business Intelligence Reduce AP Staff 33%, Cuts Month-End Close 20% / June 2004

Leading Extended Stay Management Company Creatively Uses Business Intelligence to Direct 85% Growth / January 2004

#1 Owner Group Priority: Performance Management for Investors / The Melrose Hotel Company Studies New Process toHospitality That Includes Goal Setting, Goal Tracking, and Data Analysis / December 2003

Big Box Hotels, Boutiques Share Design Styles; Standardize Data, Financials To Support Long-Term Growth of Real Estate Parent / October 2003

Economy Brightens: H.I. Development Corp. Picks Enterprise-wide Business Intelligence, Back Office Technology to Drive Growth / September 2003

CHIP, Other Ownership Groups Eye New Scorecarding Tool To Communicate Common Vision of Enterprise Priorities, Control Costs, Raise Profit Margins in Tough Economy / June 2003

Dolce International Clicks Through Smith Travel Data To Chart Growth Plans, Increases Market Share 4 Percentage Points / June 2003

The Melrose Hotel Company Installs Business Intelligence Software to Stay Above RevPAR Curve / May 2003

Pineapple Management Benefits: Technology Vendor Invests in Back-Office System Advances for Operators; ‘New Economy’ Demands Greater Efficiency in Hospitality Operations / Mar 2003

Minnesota Hotel Operator Builds Success With Locations Near Chain Restaurants, Web-Based Centralized Accounting / Feb 2003

Business Intelligence Software Identifies, Controls Costs; Focuses on Improving Profitability for Hoteliers in 2003 and 2004 / Dec 2002

Mid-Sized Management Firm Bursts into Creative Boutique Market with Added Services, Web-Based Centralized Accounting / Sept 2002

Marriott, Hilton Management and Real Estate Firm Dominates New Construction Niche With Business Intelligence Software, Relationship Financing / Aug 2002

Starwood, Host Marriott Shine at New York Hospitality Investment Conference; Edge Ahead with Business Intelligence Tools, Rely on Aptech Applications / June 2002

Hotel Undergraduates Shift With the Industry Towards Business Intelligence / March 2002

Interstate Hotels Partners with Aptech to Install ASP Model; ASP Back Office Provides Value to Hotel Owners With Ability to Reduce Capital Outlay, Eliminate Maintenance Costs, Bring Faster Processing Speeds / June 2001 

Jill Wilder Named Vice President and Officer of Aptech Computer Systems Inc. / May 2002

Survival Tactics; New Technology Directions Surface in Business Intelligence Survey / November 2001 

Aptech Opens Business Intelligence Door for Small to Mid-sized Management Firms / October 2001


To search Hotel Online data base of News and Trends Go to Hotel.OnlineSearch

Home | Welcome | Hospitality News | Industry Resources

Please contact Hotel.Online with your comments and suggestions.