ICT Technologies. Session 1 4 June 2007 Mark Viney. Introduction. www.abs.gov.au. Mark Viney Director, Technology Application for Economic Statistics Group Technology Application Branch Technology Services Division firstname.lastname@example.org. Australia. Population = 21 million Area =
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.
ICT Technologies Session 1 4 June 2007 Mark Viney
Introduction www.abs.gov.au • Mark Viney • Director, Technology Application for Economic Statistics Group • Technology Application Branch • Technology Services Division • email@example.com
Australia Population = 21 million Area = 7.7 million sq km Coastline = 59 740 km http://www.sentinel.csiro.au
Australian Bureau of Statistics We assist and encourage informed decision making, research and discussion within governments and the community, by leading a high quality, objective and responsive national statistical service.
Australian Bureau of Statistics We assist and encourage informed decision making, research and discussion within governments and the community, by providingleading a high quality, objective and responsive national statistical service
Australia - Population distribution 90% of Australia's population contained in 2.2% of the continent (mainly east and south-west coasts)
ABS Offices Head office in Canberra Offices in each Australian State and Territory Rainfall
the ABS • covers all "subject matters": Economic, Social, Health, Environment, Technology, Agriculture.. • 3600 staff • 9 offices (in each State & Territory capital) • we publish 3 - 4 publications each working day • largely professional staff - • Maths/Stats • Economists • ICT • Accountants
ICT Technologies • Almost everything a statistical agency does can be supported by ICT • Today we will cover: • which technologies fit where in "statistical lifecycle" • Next 2 sessions: other applications of ICT (eg. knowledge management), future technologies, IT management
ICT Technologies What does the ABS use? • Hardware • 3400 pc + 1100 laptop (Microsoft Windows XP SP2) • 110 Windows servers (Windows server 2005) • 1 Fujitsu mainframe (MSP OSIV) • 8 Sun microsystems midrange servers (Solaris unix)
ICT Technologies What does the ABS use? • Infrastructure Software • SAS • ORACLE • Lotus Notes (Lotus smartsuite) • Blaise • Supercross
ICT Technologies What does the ABS use? • Applications Environment • SAS • ORACLE (PL SQL + Java SP) • Lotus Notes (Lotus script) • C, C++, C#, VB.net, Centura
Layers of Technology Applications Statistical Infrastructure "Business" Infrastructure IT Infrastructure
IT Infrastructure Applications Statistical Infrastructure "Business" Infrastructure • Servers and OS • PCs and notebooks • Networks - Local Area, Wide Area, Internet • Printers, plotters, scanners, disks, tape drives • Directories (assets, people) • Generic software packages: • Word, Spreadsheet, Databases (eg. Access, ORACLE) • Web site IT Infrastructure
Statistical Infrastructure Applications • Shared Data capture systems • Meta data management systems • Business Register • Data Warehouses • Publishing systems • Statistical Packages: CSPro, SAS, Blaise, SPSS, FAME, PC-Axis... Statistical Infrastructure "Business" Infrastructure IT Infrastructure
Business Infrastructure Applications • systems common to businesses • regardless of business function • Financial Systems • Personnel Systems • can buy "off the shelf" Statistical Infrastructure "Business" Infrastructure IT Infrastructure
Applications • systems to support specific functions of the organisation • Statistical Applications • National Accounts • Population Census • Personnel Applications • leave • travel • payroll Applications Statistical Infrastructure "Business" Infrastructure IT Infrastructure
"Stove Pipe" approach INPUT THRUPUT OUTPUT INPUT THRUPUT OUTPUT INPUT THRUPUT OUTPUT
"Clearing-House" Approach INPUT OUTPUT OUTPUT INPUT THRUPUT OUTPUT OUTPUT INPUT OUTPUT Standardized interface Standardized interface
"Clearing-House" Approach INPUT OUTPUT OUTPUT INPUT THRUPUT OUTPUT OUTPUT INPUT OUTPUT Standardized interface Standardized interface Data Warehouses Applications Standards "Business" Infrastructure Statistical Infrastructure Meta Data Management IT Infrastructure
Statistical "Lifecycle" Statistical Leadership Design and Tune Analysis and Explanation Process Inputs Transform Inputs into Statistics Decision Support Acquire Data Assemble and Disseminate Manage Quality and Processes
Overall Support • Project Management (MS Project) • Software Development Methodology (eg. Prince)
Design and Tune • Metadata stores: • standard questions • classifications • data item definitions • processing metadata • Form Design (eg. Word, PageMaker) • Mapping (eg. Mapinfo) • Interviewer instructions/ Training
Acquire Data • Scanning/ Repair • Coding - Automated/ Assisted • caTi - telephone • caPi - personal • Key Data Entry • OMR, OCR, ICR • Collection Registers • E-form (internet)
Process Inputs • SAS • SPSS • Blaise • SQL database • CSPro • Supercross • MS Access
Transform Inputs into Statistics • SAS, SPSS, Blaise, CSPro, Supercross, Access • Confidentialisation - suppress cells which may disclose details of individuals • Tau Argus (Netherlands) • DAAS (ABS)
Analysis and Explanation • SAS, SPSS • "OLAP" tools (eg. Brio, Discoverer, Pro Clarity, Cognos Powerplay) • Seasonal Adjustment • Graphics & graphs, thematic mapping
Assemble and Disseminate • Desktop publishing (Word, Ventura, Pagemaker) • Datasets: spreadsheets, time series datasets, "cubes" • on-line data access services: CANSIM, PC-AXIS, INFOS, Beyond-20/20, SuperWeb, Cognos PowerPlay..
Decision Support • telephone • internet • e-mail
Some suggestions... • select a "standard" set of tools and methodologies and try and stick to them • Develop a plan for your shared "statistical infrastructure" • maintain skills • invest to keep existing systems "up to date"