A blog by Oleg Shilovitsky
Information & Comments about Engineering and Manufacturing Software

PLM, Information Discovery and Excel Provisioning

PLM, Information Discovery and Excel Provisioning
Oleg
Oleg
17 July, 2013 | 2 min for reading

Excel is one of the most widely accepted PLM systems. PLM vendors and consultants may disagree with this strong statement. Despite that, I believe the amount of product data that lives today in Excel spreadsheets spread around organizational servers and cloud storage like Dropbox and Google is huge. The main reason companies are getting into DIY Excel PLM business is related to simplicity of data capturing and Excel ease of use. Long time ago I blogged about Why do I like my Excel spreadsheets. In my view, 4 years blog post is relevant today too.

One of the trends that I can see today is related to establishing of services helping people to discover the information. Widely spread product data can be very useful when it comes to the point of decision making, design reuse and analyzes.

Oracle acquired search and data processing outfit Endeca last year. I was following Endeca activity for some time. One of the articles caught my attention yesterday – David Sowerby at 3sixty-analytics outlines the setup in, Endeca Provisioning – ‘Self Service’. The article describes how you can find a spreadsheet, load it into the system, experimenting with the data and getting the results. Here is an interesting passage:

The future direction of Endeca by including a feature described as ‘Provisioning’. In practice, this is the facility to load a single spreadsheet, perform some simple but useful data cleansing, and then let Endeca generate an application. Although it currently only loads a single spreadsheet per application, it is a great way to see some of Endeca’s capability first hand, and also to act a hands on introduction to building an application from your data.”

The following Oracle video shows how you can work with data and create applications.

http://www.youtube.com/watch?v=2MGqOFyJ3bo

The idea of creating application out of Excel data, made me think about past experience and technologies invented during my previous work at Inforbix. During that work, Inforbix product data crawlers loaded lots of CAD and Excel spreadsheets data and provided a way for customer to explore this data using simply and easy to use interfaces – tables and charts. Saved queries can be stored for future use.

What is my conclusion? The value of information is getting more and more important these days. Lots of organizations understood that data reuse and information discovery can provide a significant value to organization and help to improve decision process. The cost of data migration, cleansing is high. Therefore, applications that can make it possible getting more and more focus. Just my thoughts…

Best, Oleg

Recent Posts

Also on BeyondPLM

4 6
22 June, 2010

I’d suggest to have some fun in the beginning. What is PUI? Do you think this is a new PLM...

8 June, 2016

I’m attending PTC LiveWox 2016 event these days in Boston. An impressive gathering of ~4000 people sharing and learning about...

9 December, 2016

One of the complex topics in product development and manufacturing is multi-level BOM. Very often, multi-level BOM is presented as...

21 June, 2018

We are producing so much data these days. Every single movement, work done, project, activity, order, customer communication, design… practically...

7 November, 2013

Budget and cost. These are important elements of every IT solution. PLM is not an exclusion from this list. There...

25 March, 2016

A growing number of manufacturing companies are dependent on the experience of aging workforce. Often process guidelines or rules are...

29 September, 2011

PLM is a lot of lifecycle. It is a very important characteristic of PLM to support product access the multiple...

1 June, 2010

I already had chance to mention Geoffrey Moore presentation during Google’s Atmosphere 2010 event. One of the things he mentioned...

26 January, 2017

Artificial Intelligence (AI) is having a renaissance moment these days. With the risk to disclose my age, I can remind...

Blogroll

To the top