it in m e n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
IT in M&E PowerPoint Presentation
Download Presentation
IT in M&E

Loading in 2 Seconds...

play fullscreen
1 / 33

IT in M&E - PowerPoint PPT Presentation


  • 84 Views
  • Uploaded on

IT in M&E. Not (always) a bad idea. Alastair “Bell” Turner Khulisa Management Services. What are these things?. “Database” Repository Capture Tools Reporting Tools. Why do we do it?. Immediate feedback Rapid communications Structure Versioning Distributed Capture.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'IT in M&E' - martin-cross


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
it in m e

IT in M&E

Not (always) a bad idea.

Alastair “Bell” Turner

Khulisa Management Services

what are these things
What are these things?
  • “Database”
  • Repository
  • Capture Tools
  • Reporting Tools
why do we do it
Why do we do it?
  • Immediate feedback
  • Rapid communications
  • Structure
  • Versioning
  • Distributed Capture
some cheese with that
Some cheese with that …?
  • “It was so much easier/quicker without a database”
  • “We spend our lives pushing stuff into this system and we never get anything out again”
  • “It suits x’s needs fine, but does nothing for me”
why are they so unhappy
Why are they so unhappy?
  • Navigation / process intensive interfaces
  • Inflexible
    • Insufficient meaningful extraction
    • Broad programme / donor relevant indicators
    • Long data periods
what computers do well
What computers do well
  • Arithmetic
    • Big numbers
    • Lost of numbers
    • Fast
  • Repetition
    • Comparison and matching
  • Accuracy
how does this help us
How does this help us?
  • Aggregate at all levels
  • Aggregate in all possible combinations
  • Multi Dimensional Analysis
  • OLAP
illustration
Illustration
  • Impact on new car sales
  • Gas guzzlers and small passenger diesels
  • Manufacturers
  • Inland / coastal
    • Provinces
slide10

260

25

104

slide15

564

79

58

267

60

43

348

37

103

89

7

29

300

88

40

220

79

58

700

200

165

99

16

27

447

89

103

75

12

30

700

200

165

560

200

55

320

44

38

608

400

50

155

75

28

405

165

37

99

23

25

700

200

165

520

30

120

230

88

77

75

10

14

450

150

77

270

99

45

157

11

50

571

88

99

880

78

200

602

67

77

99

24

17

462

157

68

133

56

14

440

79

33

568

46

33

430

79

67

500

120

78

345

100

90

456

78

56

345

99

120

320

78

99

789

300

54

120

88

20

550

125

70

340

56

44

340

45

100

600

57

138

77

11

24

99

10

30

700

200

165

420

88

57

557

99

145

444

22

64

570

125

33

230

150

44

700

200

165

790

400

210

688

67

92

53

2

20

607

300

157

88

15

27

183

5

30

654

54

33

176

33

5

244

67

45

700

200

165

slide23

Organisation

Time

Indicator

getting data in easily
Getting data in easily
  • Import sources are not always stable
  • Extension of the organisation hierarchy during import
  • Atomic data makes time aggregation possible
time based aggregation
Time based aggregation
  • Discrete
    • Just add/compare numbers over time
  • Continuous
    • Generally “Continuing” + “New”
    • When aggregating over time “New” has some important qualifiers
old fashioned data capture
Old fashioned data capture
  • Tally sheets or registers
  • Order of fields/columns
  • Produce registers or forms from system
in summary
In summary
  • Multi Dimensional Analysis
    • Reporting flexibility
    • Capture system / Import flexibility
      • Cascades
      • Subdividing dimensions
        • Time is the tricky one
  • Capture from paper
    • Watch the order
    • Print them from the system
a word from our techies
A word from our techies
  • Exceptions are the enemy of reliability
  • Not complexity

Thank You