Visualization and Data Mashups

InetSoft's Product Manager Katie Philips participated in Information Management’s DM Radio Webcast, “The Last Mile: Data Visualization in a Mashed-Up.” The following is a transcript of that Webcast.

Eric Kavanagh (EK): Welcome to DM Radio. My name is Eric Kavanagh, and I will be your humble if excitable host for the show that is designed to peel away the marketing veneer so we can get down to brass tacks and hopefully figure out what is going on here in the field of information management. And obviously there is plenty going on. It is the Information Age.

And the topic for today is really interesting stuff. We’re talking about mashups. We’re going to find out what a mashup is all about.

But we’re going to find out from several experts what is going on in the field of data visualization and how mashups can really help you get a strategic view of enterprise data. So several great guests on today’s show, goodness gracious. We have several great guests. We have a couple expert guest hosts who are going to help us out today: William Laurent of William Laurent Advisors and Malcolm Chisholm of Ask Get, are in our New York studio, and then we’re going to hear from Katie Philips of InetSoft. So we’re going to hear the consultant perspective and the vendor perspective, and of course, we’ll have our exciting roundtable discussion.

Now without further ado, I’d like to bring in our expert guest host number one Katie Philips. Welcome to DM Radio. So let’s talk about what a mashup is. You’ve written about some of this stuff. I’ve written about some of this stuff. A lot of people think mashups, and they think Google maps the way it overlays business names on a map, and that is a mashup, but it is just one kind, right?

Katie Philips: Yes, right. A data mashup is the process of integrating, transforming, and combining data from multiple sources to create a unified view for analysis and decision-making. Unlike traditional ETL (Extract, Transform, Load) processes, which rely on predefined schemas and structured data warehouses, BI data mashups allow for more flexible and on-the-fly data integration. They enable organizations to combine structured and unstructured data from various systems, including databases, cloud services, IoT devices, and external APIs, to derive new insights.

Data mashups are essential for modern analytics because they empower organizations to work with diverse data sources without being constrained by rigid data models. They help users dynamically merge data sets, apply transformations, and visualize the results in real time. This is particularly beneficial for industries that require quick adaptability, such as healthcare, finance, and manufacturing. Data mashups support self-service BI, where business users and analysts can blend data without heavy reliance on IT, making data analysis more agile and responsive to business needs.

demo icon
View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software.

A manufacturer of medical imaging equipment, such as MRI and CT scan machines, deals with vast amounts of data from production, supply chain, quality control, and customer service. A BI data mashup allows them to integrate data from multiple sources, including manufacturing processes, IoT sensor readings from machines, equipment usage logs, service records, and customer feedback. By unifying this information, the manufacturer gains a comprehensive view of their operations, enabling them to optimize performance and improve product reliability.

The data mashup for a medical imaging manufacturer typically includes information from: Manufacturing Systems: Data from production lines, assembly robots, and quality checks. IoT and Sensor Data: Real-time readings from imaging machines monitoring temperature, vibrations, and performance metrics. Supply Chain Management: Data from suppliers, inventory levels, and logistics to ensure timely delivery of components. Customer Support & Service Logs: Maintenance requests, technician notes, and repair history for installed equipment. Regulatory Compliance Reports: Information needed for FDA or CE compliance, ensuring adherence to medical industry regulations.

One of the most significant benefits of a data mashup for this manufacturer is predictive maintenance. By integrating IoT sensor data with historical service logs, they can predict potential failures before they occur, reducing machine downtime and enhancing customer satisfaction. If a CT scanner in a hospital begins to show early warning signs of a component failure, the manufacturer can proactively schedule maintenance, preventing costly disruptions.

A BI data mashup helps manufacturers optimize their production lines by identifying inefficiencies. By combining data from manufacturing execution systems (MES) with supply chain information, they can forecast demand, reduce waste, and prevent bottlenecks. If a particular component is consistently causing defects in MRI machines, the manufacturer can quickly identify the issue, trace it back to the supplier, and implement corrective actions.

Medical imaging manufacturers must comply with strict industry regulations. A BI data mashup enables them to automate compliance reporting by aggregating data from different sources, ensuring they meet regulatory requirements efficiently. Instead of manually compiling reports from disparate systems, compliance officers can use real-time dashboards that pull in machine performance, safety tests, and service history data, making audits more manageable.

By integrating customer service data with product performance data, manufacturers can improve the customer experience. When a hospital reports an issue with an MRI scanner, support teams can access a comprehensive history of the machine, including previous maintenance logs, sensor readings, and software updates. This allows for faster troubleshooting and personalized support, leading to higher customer satisfaction.

A BI data mashup provides insights that drive innovation. By analyzing how different imaging devices perform in real-world conditions, manufacturers can identify trends in equipment failures, user behavior, and imaging accuracy. This data can then inform the design of new models, ensuring that future imaging machines are more reliable, efficient, and user-friendly.

In a highly competitive industry, leveraging BI data mashups gives medical imaging manufacturers a strategic edge. They can respond faster to market changes, improve product reliability, reduce costs, and enhance customer service. With real-time insights from multiple data sources, they can make data-driven decisions that lead to better patient outcomes and stronger business growth.

We will help you get started Contact us