Sarbanes-Oxley (SOX) - Pivot

This diagram is a pivot diagram showing the data from an audit.

SOX audit Pivot - Excel File - Down load

SOX audit Pivot - Excel file download

Diagram Flow

Create a excel file with following data headers

• Control Number – Unique ID for the data table

• Control Name – The unique name for each control

• Component – The What the control does

• Department – Department name

• Business Unit – The name of the department

• Risks

• Risk Level – The level of risk, 1 to 5

• Process Complexity – Complexity level, 1 to 5

• Maturity Level – Maturity, 1 to 5

How to create a Pivot chart
Step 1 : Create data in an Excel file or Database
Step 2 : Use the data to create a PivotDiagram via the Insert Pivot Diagram menu
Step 3: Expand the Pivot Node to show various levels of sub-nodes that correspond to the data you want to analyze

A Pivot Diagram is a collection of shapes arranged in a tree structure that helps you to analyze and summarize data in a visual, easy-to-understand format. It starts out as a single shape, called a top node (the “Total” shape in the diagram), that contains information imported from the Excel worksheet. You can break the top node into a level of sub nodes to view your data in various ways.

The PivotDiagram enables users to create data linked dynamic drawings faster & easier than ever before

Data Graphics are made up of elements that give the user a more complete view of their system

Data Graphic - Pivot

•  Title – Text element

•  Control Number – Text element

•  Risk Level – Data bar

•  Maturity Level – Data bar

•  Risk Level(Avg) – Icon set

•  Maturity Level(Avg) – Icon set