Author Topic: Competitor Analysis - Comparing org charts  (Read 3635 times)

0 Members and 1 Guest are viewing this topic.

steven nunn

  • Newbie
  • *
  • Posts: 1
Competitor Analysis - Comparing org charts
« on: May 15, 2011, 07:42:24 PM »
We are trying to use Visio to visualise our data. We cannot find a way of grouping the data by firm and department in order to create competitor analysis in the form of organisational Charts

Is seems that visio doesn't like the idea that people work at different companies but in the same types of department.

Any suggestions on how to do this would be extremely welcomed.

Example data:

 
Company   Name                Department
Firm A   Feros, Erin    Banking & Finance
Firm A   Thatcher, Adam    Banking & Finance
Firm A   Evans, Chelsey    Corporate & Commercial
Firm A   James, Peter    Corporate & Commercial
Firm A   Zillmann, Ben    Energy & Resources
Firm A   Baartz, John    Litigation
Firm A   Pappalardo, Alf    Litigation
Firm A   Beckinsale, John    Property & Construction
Firm A   Niemann, Ren    Property & Construction
Firm A   Young, Dan    Property & Construction
Firm A   Newman, Paul    Property & Construction
Firm A   Allen, Peter    Tax
Firm A   Parkyn, Katrina    Tax
Firm B   Gallimore, John    Banking & Finance
Firm B   Ilott, Michael    Corporate & Commercial
Firm B   Knox, Andrew    Corporate & Commercial
Firm B   Greig, John    Energy & Resources
Firm B   Harrip, Tracey    Litigation
Firm B   Rankin, Geoffrey    Litigation
Firm B   Higgins, Grant    Property & Construction
Firm B   Davies, Tony    Property & Construction
Firm B   Millhouse, Alan    Property & Construction
Firm B   McCredie, Bill    Property & Construction
« Last Edit: May 15, 2011, 07:47:50 PM by steven nunn »