Download PDF
Digital Transformation and Automation of Internal Auditing at Merlin Properties with Alteryx
Technology Category
- Analytics & Modeling - Big Data Analytics
- Analytics & Modeling - Data-as-a-Service
Applicable Industries
- Buildings
- Retail
Applicable Functions
- Logistics & Transportation
- Quality Assurance
Use Cases
- Inventory Management
- Retail Store Automation
Services
- Testing & Certification
- Training
The Challenge
Merlin Properties, a leading Spanish Real Estate Investment Trust, faced a significant challenge due to the number of assets and the complexity of the data to be processed. The company needed a way to analyze and audit its financial and non-financial information efficiently. The starting point was a dynamic and complex business, with many different technologies coexisting and a large amount of data from multiple sources. The aim was to aggregate external supplier data sources and bring them right up-to-date, in order to have information from all suppliers in real-time. This posed a problem for Merlin Properties on three levels: extracting and processing data, visualizing that data in a more structured and organized way, and carrying out detailed data analysis to help with decision making.
About The Customer
Merlin Properties is the leading SOCIMI (Spanish Real Estate Investment Trust) and is among the 10 largest Real Estate Asset Investment Groups (REITs) in Europe. The Company’s main activity is the acquisition and management of quality Commercial Real Estate Assets, focusing on offices, retail, logistics and data centers. After 8 years in the Market, Merlin Properties’ portfolio has approximately €11,390 million in Real Estate Assets, spread over 150 office buildings, 14 malls, 55 logistics warehouses, 3 hotels and 4 data centers under construction.
The Solution
Merlin Properties embarked on a project for the Digital Transformation and Automation of the Internal Audit Department, with the help of Alteryx and PwC Spain. The project aimed to have greater control over the data to identify internal errors and issues, reduce costs by accessing all data at a cheaper cost, and prevent fraud. Alteryx provided a tool that could be used by the business side of the Company, a platform that any business user could take advantage of. The goal was to democratize data analysis and management. Merlin Properties set out other objectives including the digitization and automation of key processes within their Internal Audit, the definition of dynamic scorecards on key processes and creating scorecards to track the status of Internal Audit work. All this had to be done semi-automatically, a process that would run without the need for external intervention.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
Case Study
Improving Production Line Efficiency with Ethernet Micro RTU Controller
Moxa was asked to provide a connectivity solution for one of the world's leading cosmetics companies. This multinational corporation, with retail presence in 130 countries, 23 global braches, and over 66,000 employees, sought to improve the efficiency of their production process by migrating from manual monitoring to an automatic productivity monitoring system. The production line was being monitored by ABB Real-TPI, a factory information system that offers data collection and analysis to improve plant efficiency. Due to software limitations, the customer needed an OPC server and a corresponding I/O solution to collect data from additional sensor devices for the Real-TPI system. The goal is to enable the factory information system to more thoroughly collect data from every corner of the production line. This will improve its ability to measure Overall Equipment Effectiveness (OEE) and translate into increased production efficiencies. System Requirements • Instant status updates while still consuming minimal bandwidth to relieve strain on limited factory networks • Interoperable with ABB Real-TPI • Small form factor appropriate for deployment where space is scarce • Remote software management and configuration to simplify operations
Case Study
Powering Smart Home Automation solutions with IoT for Energy conservation
Many industry leaders that offer Smart Energy Management products & solutions face challenges including:How to build a scalable platform that can automatically scale-up to on-board ‘n’ number of Smart home devicesData security, solution availability, and reliability are the other critical factors to deal withHow to create a robust common IoT platform that handles any kind of smart devicesHow to enable data management capabilities that would help in intelligent decision-making