Business Intelligence and Jidoka | Toyota’s Simon Dorrat | PEX

See on Scoop.itlean manufacturing
Simon Dorrat is Manager of Toyota’s Business Intelligence function where he is responsible for defining and delivering all services relating to Business Intelligence and Data Warehousing including BI, ETL, Data Quality, Master Data and OLAP. […] Simon shares his thoughts on how Business Intelligence fits with the Toyota Way, suggests three ways for IT to provide better value to the business and even explains why doing a kitchen renovation helped some illuminate important aspects of software development.

Michel Baudin‘s insight:

For the IT-phobic, a Data Warehouse is a database that makes historical data from multiple sources accessible for analytics. It is commonly used to provide management with Business Intelligence (BI). The process of periodically feeding a data warehouse is called Extract, Transfer and Load (ETL).

Of course, analysis is only worth doing on data that is complete and accurate, hence the need for tools to ensure Data Quality. The different sources usually have different nomenclatures for products, processes, or facilities, and you need your Master Data to integrate them in a single, consistent model. Finally, “OLAP” stands for Online Analytical Processing.

The first sentence in the article describes Toyota as “creating the precursor to Lean Manufacturing” and nearly made me stop reading further. It would have been a mistake.

See on www.processexcellencenetwork.com