FOODSERVICE
DATA ANALYTICS

THE NEED FOR DATA
WAREHOUSING TECHNOLOGY

DATAARC

DATAARC SNAPSHOT

 

RESPONSIBILITIES

Operational analysis

Financial planning, budgeting, and forecasting

Improve foodservice data management

 

 

PAIN POINTS SOLVED

Time-consuming and disjointed reporting

Lack of data visibility

Enhance supply chain best practices

 

 

DATAARC HELPS YOU

Integrate resources for advanced data warehousing

Make data-driven decisions with intelligent reports

 

Let’s face it - numbers can be complicated. For hospitals and health systems consisting of multiple departments and resources, operational analysis can be overwhelming when you are viewing an abundance of spreadsheet reports. Due to interoperability, foodservice data analytics has advanced because data can be easily migrated from transactional databases and stored in a centralized repository.

But having all hospital data stored in a giant database isn’t enough; compiling the information through integrated data warehousing resources so that it can be easily interpreted is vital! After all, executives rely on foodservice data analytics in healthcare for financial planning, budgeting, forecasting, and determining if key performance indicators (KPIs), such as patient satisfaction standards, are being met.

An infographic displaying DataArc data warehousing architecture. Set of extraction packages > File exports of transformed, desensitized data (no PHI) > Reporting Tool > Import to Data Warehouse

BRIDGING YOUR RESOURCES

Considering foodservice, nutrition, and retail services impact the overall success of a hospital and health system, there is a need to bridge the data from these areas with a healthcare data warehouse. For that reason, Computrition developed DataArc - data warehousing technology for optimized foodservice data analytics.

With an agile three-step process, data analysis is taken to a whole new level! Using Extract, Transform, and Load (ETL) technology, DataArc extracts foodservice data from Hospitality Suite systems (FOM, NCM, and SP! POS), and allows you to transform them into visually understandable formats and recurrently load them on a dedicated data warehouse.

BRIDGING YOUR RESOURCES

Considering foodservice, nutrition, and retail services impact the overall success of a hospital and health system, there is a need to bridge the data from these areas with a healthcare data warehouse. For that reason, Computrition developed DataArc - data warehousing technology for optimized foodservice data analytics.

With an agile three-step process, data analysis is taken to a whole new level! Using Extract, Transform, and Load (ETL) technology, DataArc extracts foodservice data from Hospitality Suite systems (FOM, NCM, and SP! POS), and allows you to transform them into visually understandable formats and recurrently load them on a dedicated data warehouse.

ADVANCED REPORTING

Seamless integration with existing Hospitality Suite systems ensures consistency of shared data for ongoing standardization throughout the supply chain.

DataArc enables both single-hospitals and large health systems to use their healthcare data warehouse to generate intelligent dynamic reports and create visualizations. Since foodservice data is desensitized, reports do not contain any protected health information (PHI).

These reports equip foodservice leaders to conduct thorough data analytics of historical trends pertaining to:

A professional man looks at a computer screen, which shows multicolored bar charts for foodservice data analytics.
A blue icon of a checkmark within a circle.

MEAL SERVICE
HISTORY

A blue icon of a checkmark within a circle.

TRAY DELIVERY
ANALYSIS

A blue icon of a checkmark within a circle.

COST OF
OVERPRODUCTION

A blue icon of a checkmark within a circle.

INVENTORY
MOVEMENT

A blue icon of a checkmark within a circle.

CASH REGISTER
ACTIVITY

A mobile phone displays a visualization of foodservice data analytics from DataArc.

MAKING DATA DRIVEN DECISIONS

Having this data visually depicted in the form of graphs and charts makes it easy for executives to identify any problem areas like food-related errors, flaws in the patient experience, food waste issues, and lost sales.

The insights gained from foodservice data analytics help recognize negative operational patterns. This capability drives corrective action, leading to enhanced future best practices like:

The insights produced by hospital big data analytics helps recognize negative operational patterns. This capability drives corrective action, leading to enhanced future best practices like:

An infographic outlining DataArc best practices: Increasing use of foodservice automation > Updating food safety measures > Controlling food costs > Streamlining retail throughput

With enhanced depictions of measurable outcomes, DataArc will be resourceful in catapulting healthcare organizations towards continual progress!

With enhanced depictions of measurable outcomes, DataArc will be resourceful in catapulting healthcare organizations towards continual progress!

system essentials

A blue icon of a person's silhouette within a circle. Smaller circles are attached with lines.

Migrate data from
all integrated
datasets to EDW

A blue icon of a browser window showing two gears.

Configure multiple
ETL types to extract
specific data regularly

A blue icon of a browser window showing two gears.

Configure multiple ETL types to extract specific data regularly

A blue icon of a spreadsheet with a downward arrow in the bottom-right corner.

Setup automatic imports
of extracted data into EDW
in delimited text format

A blue icon of a spreadsheet with a downward arrow in the bottom-right corner.

Setup automatic imports of extracted data into EDW in delimited text format

A blue icon of a sealed envelope.

Receive email
receipts of activity
summary reports

A blue icon of a sheet of paper with lines of text and a checkmark.

Estimates of data
export size provided

A blue icon of a finger checking boxes.

Option to run
one-time exports
for historical data

Data Reference Guide
provides flexibility to
write reports based on
the format of the data

optimized outcome

A blue icon of a gear surrounded by two arrows turning in a circular motion.

Ongoing data exports
produce intelligent
dynamic reports

A blue icon of a calendar in front of a spreadsheet.

Interpretive reports enable
easy and thorough reviews
of historical trends

A blue icon of a calendar in front of a spreadsheet.

Interpretive reports enable easy and thorough reviews of historical trends

A blue icon of a paper with a checkmark emerging from an open envelope.

Recognize problem areas and
negative operational patterns
through report visualization

A blue icon of a paper with a checkmark emerging from an open envelope.

Recognize problem areas and negative operational patterns through report visualization

A blue icon of a magnifying glass hovering over a rising arrow.

Improved data visibility drives
corrective action and enhanced
future best practices

A blue icon of a magnifying glass hovering over a rising arrow.

Improved data visibility drives corrective action and enhanced future best practices

A blue icon of a person working on a computer underneath a speech bubble with a checkmark.

Promotes better utilization of
enterprise foodservice systems
to ensure clean data

A blue icon of a person working on a computer underneath a speech bubble with a checkmark.

Promotes better utilization of enterprise foodservice systems to ensure clean data

see it in action

Take a look at additional resources to find out how data warehousing technology can help you perform
effective foodservice data analytics and optimize your department with our pillars of automation!