News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Competitor Analysis - Comparing org charts

Started by steven nunn, May 16, 2011, 12:42:24 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

steven nunn

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

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 134 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1050KB.
Tokens: post-login.
Cache hits: 14: 0.00168s for 26,764 bytes (show)
Cache misses: 3: (show)
Queries used: 17.

[Show Queries]