7 Tools for Turning Data Into Dollars

Over the years, in project after project, I have found that I only needed seven tools to solve virtually any operational problems involving delay, defects and deviation. Once in a great while I might need another tool, but I had to look it up because I had long forgotten it. You can easily create breakthrough improvements using these seven tools and the ChartSmartXL.

  The Magnificent Seven Tools for Turning Data Into Dollars

Value Stream Maps identify and remove delays from any process.
(Lean Tools-Value Stream Map)


Spaghetti Diagrams identify and eliminate unnecessary movement of people or materials in any workspace.
(Lean Tools-Spaghetti Diagram )


Excel PivotTables summarize massive dumps of data about defects and money.
(ChartSmartXL PivotTable Wizard )

3 Performance charts to measure and monitor the performance of any process. Without performance charts, you cannot sustain improvements.
(performance charts)

4 Pareto Charts identify the most frequent types of defects, mistakes and errors.
(Pareto Chart)

5 Histograms with Cp and Cpk evaluate deviation in performance.
6 Ishikawa (fishbone) diagrams identify the root causes of the problem.
(See the new, automated Fishbone diagram at: Improvement Tools-Fishbone diagram or Ishikawa diagram)

7 Matrix diagrams like check sheets, countermeasures and action plans collect data and prioritize corrective actions.
(Improvement Tools-Countermeasures Matrix )

Master these 7 Tools and you'll be well on your way to success with Finding Profit. ChartSmartXL will support you every step of the way.

Learn More About Turning Data Into Dollars with ChartSmartXL and Excel