1 / 24

Information Discovery, Analysis, & Interpretation

Information Discovery, Analysis, & Interpretation. Lecture 7 Tues 24 Feb 2009. Plan. Pareto Chart PIM. Pareto Analysis. Vilfredo Pareto C19 Italian Economist Investigated distribution of wealth Discovered 80/20 ‘rule’ Pareto Chart Chart based on 80/20 principle*

davida
Download Presentation

Information Discovery, Analysis, & Interpretation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Information Discovery, Analysis, & Interpretation Lecture 7 Tues 24 Feb 2009

  2. Plan • Pareto Chart • PIM

  3. Pareto Analysis Vilfredo Pareto • C19 Italian Economist • Investigated distribution of wealth • Discovered 80/20 ‘rule’ Pareto Chart • Chart based on 80/20 principle* • Heuristic i.e. rule of thumb • Prioritisation tool • Separate important few from the ‘trivial many’ *Sometimes 70/30

  4. Problems with Car X in Jan 2009 Which problems should we focus on?

  5. Pareto Chart 80/20 0r 70/30?

  6. Sort Data

  7. Choose Column & ‘Descending’ Option

  8. Use ‘AutoSum’ to add Occurences

  9. Add Formula to Calculate %

  10. Click on ‘AutoFill’ Handle & Drag Down

  11. Add Formula to Calculate Cumulative %

  12. Click on ‘AutoFill’ Handle & Drag Down

  13. Highlight Relevant Columns & Click on ‘Chart Wizard’

  14. Click on ‘Custom Types’ & ‘Line - Column on 2 Axes’

  15. Add Title and Label Axes

  16. Right Click on 2nd Y Axis and Click Format Axis

  17. Change ‘Scale’ to ‘Maximum’ of 100

  18. Done!

  19. Pareto Chart in Excel • Formulas • Autofill • Sum function • Data sorting • Custom Type Charts • Edit Chart: Text Orientation, Scale

  20. Assignment 2 Problems

  21. Which to act on? • Tally answers from questionnaires? • What are pro’s and con’s of this? Pareto voting • Vote for top 3 problems • Create Pareto Chart • Separate vital few from trivial many • What are pro’s and con’s?

  22. PIM What PIM problems do you have? • Think about work projects, college assignments, personal projects • What PIM tools do you use? • If you were feeling adventurous, what PIM tools could you use? • Would you use a wiki? • Plan PIM strategy for assignment 3. What information will you need to manage? How will you manage it?

  23. Time permitting… Remember EVERYTHING! www.evernote.com Could evernote be a useful PIM tool? HOMEWORK if time doesn’t permit

  24. Homework • TreePad • askSam • MyInfo • ConnectedText • EasyNoter • CUEcards • Onfolio • Paperport • myInfoSafe • OneNote • Debrief • Ultra Recall • myBase • Zoot • The Guide • The Journal • Quosa • NotaBene • KnowledgeWorkshop • WhizFolders • Action Outline • BrainStorm • GoBinder Evaluate 1 PIM software in terms of usefulness to you for next week http://code.google.com/p/kognite/wiki/DocumentManagementSoftware

More Related