Exploiting Data

1
Exploiting Data

• James Miller, Daisy, Florence Nightingale,
  Artemis and Data Mining and Visualisation

2
Mining or Visualisation

• Data Mining to Search for and Solve Problems
• Visualisation to Distribute Reports, Graphs,
  Summaries and the Complete Picture
• Intranet Deployment
• Use the Internet to Deploy Further
• Develop an Analysis Based Culture
• Get the Managers Out of the Kitchen

3
An Example of Data Mining

• Lets Look at Phone Calls on a Complex Switch
• Why Choose Phone Calls?
• Phone Cards Against Smart Cards
• User Information Data Rich Records
• Call Information Simple but Numerous
• Sessions and Multiple Journeys
• Data Decoding Phone Numbers, Exchanges etc.
• Saving and Benefits
• Data is Data is Data!!!

4
Choose Your Tools

• Even Plumbers Dont Use One Tool
• Microsoft Office ADO Internet Explorer
• Small Products Affordable
• Large Products Expensive
• Deploying Web Pages
• Windows, Linux or UNIX
• Managers, Professionals, Do-ers or Specialists
• Hardware, Software, Intranets and Warehouses
• Cinemascope

5
Microsoft

• Dont Be Prejudiced Either Way!
• Dont Underestimate Microsoft
• Affordable
• Most People Are Familiar Especially Managers
• Office Excel
• ADO Universal Data Access One Size Fits All!
• Internet Explorer
• Visual Basic and VB.Net

6
Microsoft Excel

• Powerful Tool for Mining
• Learn to Use it Properly
• Most Computer Users Know the Program
• An Ideal Partner for a Large Expensive System
• Excel Workbooks are a Good Format for
  Distributing Information to Front Line Staff
• Excel Can Read CSV Files which are Easily
  Generated by Programs and Products

7
Microsoft ADO

• ADO is Microsofts One Size Fits All System for
  Reading Databases
• Its Free! Installed in Windows 2000
• And It Works!
• It Can be Used to Open, View and Link Virtually
  All Database Formats
• Its Not That User Friendly, but Good Tools are
  Available Daisy Analysis has some!

8
Microsoft Internet Explorer

• What has Internet Explorer to do with Data
  Mining?
• Ideal Data Visualisation Tool for Management
  Reports
• Most Computer Users Know the Program
• Distribute Reports on the Intranet/Internet as
  Web Pages
• Get the Managers Out of the Kitchen

9
Small Products

• Affordable Large Choice in Magazines, Libraries
  and on the Internet
• Google Search for Simple Graphical Programs,
  Data Mining, Visualisation or Visualization
• Understandable and Compatible Technology
• Daisy I Have to Dont I?
• Dont Ignore Shareware and Freeware!
• What Do You Cost Per Day?
• Buy If Under 300

10
Daisy

• Circular Charts and Charts
• Extensive Filtering Dates, Times, Phone
  Numbers, Numbers, Addresses etc.
• Links to Show Correlations
• Click and Show Underlying Data Visual SQL
• Windows Based
• Heavily Mouse Driven
• Mine and Visualise Various Database Formats
• Full ActiveX Interface

11
Circular Histograms
12
Daisy Charts
13
Date and Time Charts
14
Large Products

• Expensive
• 250,000 for a System is not Unknown!
• Often UNIX Based and Very Centralised
• Need Specially Trained Personnel
• Good for the DP Managers Ego!

15
Deploying Web Pages

• Intranet/Internet Web Pages are a Powerful Way of
  Distributing Statistics, Reports, Summaries etc.
• No Specialised Software and Understandable
  Technology for the User
• Access Anywhere with the Correct Permissions

16
Cinemascope

• Big Screens are Essential for Successful Data
  Mining and Visualisation
• At Least 1600 x 1200 pixels!
• And Good Graphics Cards Too!
• Often Big Screens Give Better Value than
  Expensive Software
• No Expensive Training Needed!

17
Reasons for Choice

• Usability
• Cost
• Operating System
• Speed
• Interface
• Can Engineers, Marketeers, Accountants Use it?

18
Transport Data

• User Information Data Rich Records
• Journey Information Simple but Numerous
• Tube Statistics
• Comparison with Phone Data
• Fraud Churn User Patterns
• Operating Statistics Delays Reliability
• Statistics and Charts on the Internet

19
Conclusions

• Get That Large Screen
• Make Sure You Have Enough Power
• Be Open With Your Results
• Scientific Rather Than Political Correctness
• Deploy Reports, Summaries and Statistics on the
  Internet/Intranet
• Beg, Borrow, Steal or Purchase a Set of Varied
  Tools
• Develop an Analysis Led Culture in All the Staff
  in Your Company or Organisation

20
Questions
21
Contact

• Daisy Analysis
• East Green Farm, Great Bradley,
• Newmarket, Suffolk CB8 9LU
• United Kingdom
• http//www.daisy.co.uk
• 44-1440-783789
• James_at_daisy.co.uk