Information discovery analysis interpretation
This presentation is the property of its rightful owner.
Sponsored Links
1 / 24

Information Discovery, Analysis, & Interpretation PowerPoint PPT Presentation


  • 84 Views
  • Uploaded on
  • Presentation posted in: General

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*

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Information discovery analysis interpretation

Information Discovery, Analysis, & Interpretation

Lecture 7

Tues 24 Feb 2009


Information discovery analysis interpretation

Plan

  • Pareto Chart

  • PIM


Pareto analysis

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


Problems with car x in jan 2009

Problems with Car X in Jan 2009

Which problems should we focus on?


Pareto chart

Pareto Chart

80/20

0r

70/30?


Sort data

Sort Data


Choose column descending option

Choose Column & ‘Descending’ Option


Use autosum to add occurences

Use ‘AutoSum’ to add Occurences


Add formula to calculate

Add Formula to Calculate %


Click on autofill handle drag down

Click on ‘AutoFill’ Handle & Drag Down


Add formula to calculate cumulative

Add Formula to Calculate Cumulative %


Click on autofill handle drag down1

Click on ‘AutoFill’ Handle & Drag Down


Highlight relevant columns click on chart wizard

Highlight Relevant Columns & Click on ‘Chart Wizard’


Click on custom types line column on 2 axes

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


Add title and label axes

Add Title and Label Axes


Right click on 2 nd y axis and click format axis

Right Click on 2nd Y Axis and Click Format Axis


Change scale to maximum of 100

Change ‘Scale’ to ‘Maximum’ of 100


Information discovery analysis interpretation

Done!


Pareto chart in excel

Pareto Chart in Excel

  • Formulas

  • Autofill

  • Sum function

  • Data sorting

  • Custom Type Charts

  • Edit Chart: Text Orientation, Scale


Assignment 2 problems

Assignment 2 Problems


Which to act on

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?


Information discovery analysis interpretation

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?


Time permitting

Time permitting…

Remember EVERYTHING!

www.evernote.com

Could evernote be a useful PIM tool?

HOMEWORK if time doesn’t permit


Homework

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


  • Login