The majority of companies that have a large amount of data, but sometimes we have to find a hard time, what to do. I thought that you frequently use a common strategy to analyze data in a company. General Division and discharged from an Excel worksheet in the same way:

1. Use Pareto chart before the row "total" and "total" column.

2. Then use the Pareto chart, and the greatest contribution in each row or column to analyze.

Case Study

Here is a table with a simplified installation of garage doors, problems with realization of the benefits of the service and warranty has been requested.

Lubricants customize installation as a whole has replaced

Gate 2 5 1 0 8

Engine 2 1 20 11 6

Track 1 0 6 4 12

T block 10 9 0 1 0

A total of 25 7 19 10 61

Since the company installs doors to generators, has sometimes more calls to the service of installing each port-bit. You can install, replace, adjust or greasing the right port. Working with five main components: door, vinyl trim, Rails and T-lock.Pareto Graph

First focus is total parts.

The engines are 33% of the full review (20/61 * 100%). We can then run to find the type of service:

Lubricants customize installation as a whole has replaced

Gate 2 5 1 0 8

Engine 2 1 20 11 6

Track 1 0 6 4 12

T block 10 9 0 1 0

A total of 25 7 19 10 61

Adaptation of the engine are 55 percent of all motor vehicle service (11/19 * 100%).

Now we have to look at something! We must now cut and and see the line in service:

Lubricants customize installation as a whole has replaced

Gate 2 5 1 0 8

Engine 2 1 20 11 6

Track 1 0 6 4 12

T block 10 9 0 1 0

A total of 25 7 19 10 61

As you can see, the installation is followed by adjustments to the 41 per cent of the total (25/61 * 100%). These two are 72% of the total. Pareto Graph

We can then understand, install, look at column:

Lubricants customize installation as a whole has replaced

Gate 2 5 1 0 8

Engine 2 1 20 11 6

Track 1 0 6 4 12

T block 10 9 0 1 0

A total of 25 7 19 10 61

Vinyl installations, account for 80% of the total, followed by blocks, for now we have to analyze. We can install a vinyl analyzed team and analyze another installation of T-lock.