The Future of Spreadsheets in in the Big ig Data Era David Birch - PowerPoint PPT Presentation

Jun 28, 2023 •130 likes •513 views

The Future of Spreadsheets in in the Big ig Data Era David Birch 1* , David Lyford-Smith 2 & Yike Guo 1 1 Data Science Institute, Imperial College London 2 ICAEW IT Faculty * david.birch@imperial.ac.uk @verifyveracity 20/07/2017 2 The

The Future of Spreadsheets in in the Big ig Data Era David Birch 1* , David Lyford-Smith 2 & Yike Guo 1 1 Data Science Institute, Imperial College London 2 ICAEW IT Faculty * david.birch@imperial.ac.uk @verifyveracity 20/07/2017 2
The Future of the Spreadsheet in the Age of Big Data The Success of Challenges with Drivers of Directions of Research Implications for the Spreadsheet current Change Change Directions Users Spreadsheet technology 20/07/2017 3
The Success of the Spreadsheet 20/07/2017 4
The Success of the Spreadsheet 20/07/2017 5
The Success of the Spreadsheet 20/07/2017 6
The Success of the Spreadsheet 20/07/2017 7
The Success of the Spreadsheet 20/07/2017 8
20/07/2017 9
Challenges with Spreadsheets 20/07/2017 10
Challenges with Spreadsheets 20/07/2017 11
Challenges with Spreadsheets 20/07/2017 12
Challenges with Spreadsheets 20/07/2017 13
Challenges with Spreadsheets 20/07/2017 14
Challenges with Spreadsheets 20/07/2017 15
20/07/2017 16
Drivers of Change 20/07/2017 17
Drivers of Change 20/07/2017 18
Drivers of Change 20/07/2017 19
Drivers of Change 20/07/2017 20
Drivers of Change 20/07/2017 21
Drivers of Change 20/07/2017 22
20/07/2017 23
Directions of Change 20/07/2017 24
Directions of Change 20/07/2017 25
Directions of Change 20/07/2017 26
Directions of Change 20/07/2017 27
Directions of Change 20/07/2017 28
Directions of Change 20/07/2017 29
Research Directions 20/07/2017 30
Research Directions 20/07/2017 31
Research Directions 20/07/2017 32
Research Directions 20/07/2017 33
Research Directions 20/07/2017 34
Research Directions 20/07/2017 35
Implications for Users 20/07/2017 36
Supporting Users 20/07/2017 37
Conclusions David.Birch@imperial.ac.uk @VerifyVeracity 20/07/2017 38

Recommend

Data O Organization in S Spreadsheets Learning Objectives Good data entry practices -

Data O Organization in S Spreadsheets Learning Objectives Good data entry practices - formatting data tables in spreadsheets How to avoid common formatting mistakes Approaches for handling dates in spreadsheets Basic quality

195 views • 15 slides

Introd u ction to spreadsheets STR E AML IN E D DATA IN G E STION W ITH PAN DAS Aman y Mahfo

Introd u ction to spreadsheets STR E AML IN E D DATA IN G E STION W ITH PAN DAS Aman y Mahfo uz Instr u ctor Spreadsheets Also kno w n as E x cel les Data stored in tab u lar form , w ith cells arranged in ro w s and col u mns Unlike

976 views • 51 slides

Using Spreadsheets to Manage and Analyze Data Data & Donuts Series, Fondren Library

Using Spreadsheets to Manage and Analyze Data Data & Donuts Series, Fondren Library November 10, 2017 Monica Rivero | mpr1@rice.edu Best Practices for Managing your Data Tips for Using Excel Productively Importing Data Data

400 views • 7 slides

Build Better Relationships With Your Constituents Turn Your Spreadsheets into Usable Data A

Constituent Management Alternative Build Better Relationships With Your Constituents Turn Your Spreadsheets into Usable Data A Strategy to Effectively Organize, Manage, Track, Engage & Connect Presented by: Amy Gibbs Design Guru /

339 views • 15 slides

Extracting Linked Data from statistic spreadsheets Tien-Duc Cao tien-duc.cao@inria.fr Ioana

Extracting Linked Data from statistic spreadsheets Tien-Duc Cao tien-duc.cao@inria.fr Ioana Manolescu ioana.manolescu@inria.fr Xavier Tannier xtannier@limsi.fr Semantic Big Data workshop, Chicago, May 19th, 2017 Agenda 1. Context: data

491 views • 19 slides

R and spreadsheets combining different programming paradigms Erich Neuwirth

R and spreadsheets combining different programming paradigms Erich Neuwirth erich@statconn.com Topics covered Spreadsheet examples Conceptual issues User profiles UseR 2009, Rennes Why spreadsheets as client? Well known user interface

258 views • 11 slides

Excel Tips for handling large spreadsheets of collections data Melissa Belvadi University of

Excel Tips for handling large spreadsheets of collections data Melissa Belvadi University of Prince Edward Island October 2017 Excel Spreadsheet Vocabulary and Limits Spreadsheet = Workbook = Book = Entire File Sheet = Tab =

585 views • 35 slides

Kentucky-Specific SPF Spreadsheets Purpose Allow for easy application of the Kentucky-

Kentucky-Specific SPF Spreadsheets Purpose Allow for easy application of the Kentucky- specific SPFs Ensures uniform use of the SPFs across the state Assists in safety analysis and identifying high crash segments *Spreadsheets

380 views • 10 slides

African bull elephant by L0k1m0nk33 CC-BY-SA-3.0 Problems with spreadsheets African bull

African bull elephant by L0k1m0nk33 CC-BY-SA-3.0 Problems with spreadsheets African bull elephant by L0k1m0nk33 CC-BY-SA-3.0 95% of all U.S. firms use spreadsheets for financial reporting Wall Street - New York Stock Exchange by Carlos

467 views • 21 slides

Spreadsheets 2 - Functions and Charts Lecture 12 COMPSCI111/111G SS 2019 Todays lecture

Spreadsheets 2 - Functions and Charts Lecture 12 COMPSCI111/111G SS 2019 Todays lecture IF function recap VLOOKUP and HLOOKUP Sorting data Inserting chart IF functions Makes a decision Different values used in the

484 views • 35 slides

A Better Way to Teach Algebra: Spreadsheets and Modeling Eric Gaze Bowdoin College National

A Better Way to Teach Algebra: Spreadsheets and Modeling Eric Gaze Bowdoin College National Numeracy Network Macaulay Honors College Manhattan, NY October 13, 2012 Spreadsheets and Modeling Timeline 1996 Berea College Modeling with

278 views • 17 slides

Chapter 12 Information Systems 1 Hofstra University - CSC005 11/12/06 Chapter Goals Define

Chapter 12 Information Systems 1 Hofstra University - CSC005 11/12/06 Chapter Goals Define the role of general information systems Explain how spreadsheets are organized Create spreadsheets for basic analysis of data Describe the elements

1.07k views • 39 slides

TaCLe Learning constraints in spreadsheets and tabular data Samuel Kolb, Sergey Paramonov, Tias

TaCLe Learning constraints in spreadsheets and tabular data Samuel Kolb, Sergey Paramonov, Tias Guns, Luc De Raedt September 6, 2017 1 / 29 Inspiration: Flash-fill 2 / 29 Inspiration: Flash-fill 2 / 29 Inspiration: Flash-fill 2 / 29

808 views • 51 slides

The Future of Open Data THE FUTURE OF OPEN DATA AFRICA OPEN DATA CONFERENCE Edward Anderson Dar

The Future of Open Data THE FUTURE OF OPEN DATA AFRICA OPEN DATA CONFERENCE Edward Anderson Dar es Salaam, September 5 th 2015 1 Presentation outline The Future of Open Data is? 1 Global 2 Five Stars and Linked Data 3 Apps and Services

419 views • 15 slides

Big Data with ADAMS Big Data with ADAMS What the heck is ADAMS? Peter Reutemann What is ADAMS?

Big Data with ADAMS Big Data with ADAMS What the heck is ADAMS? Peter Reutemann What is ADAMS? Java, GPLv3 Data mining: MOA, WEKA, MEKA, R Spreadsheets and databases Image and video processing Visualizations (plots, GIS)

671 views • 18 slides

Spreadsheets: an Introduction to utilized the notion of a malleable matrix to develop the

From word munching to number crunching In 1978 Harvard grad student Dan Bricklin Spreadsheets: an Introduction to utilized the notion of a malleable matrix to develop the first computer spreadsheet program Excel Vastly expanded

185 views • 7 slides

The Explosion in New Data And What it Means for Economic Development Big Data and Algorithms and

The Explosion in New Data And What it Means for Economic Development Big Data and Algorithms and Spreadsheets, Oh My! Introduction to GIS WebTech Technology company focused exclusively on economic development Fastest-growing provider

441 views • 19 slides

DATA, DATABASES, AND QUERIES CS1100 Microsoft Access - Introduction 1 What is this About

Managing Data in Relational Databases DATA, DATABASES, AND QUERIES CS1100 Microsoft Access - Introduction 1 What is this About Storing, accessing, searching, and viewing data are important in any business. While spreadsheets work well

533 views • 34 slides

Big Data and the Future of Big Data and the Future of Water Treatment Water Treatment 1.

Big Data and the Future of Big Data and the Future of Water Treatment Water Treatment 1. embrace data-driven technology Facility for water treatment management 2. with a people-centered strategy teams 3. or run the risk of a)

779 views • 51 slides

Auditing spreadsheets: With or without a tool? Simone Schalkwijk BSc Dr Felienne Hermans Dr

Auditing spreadsheets: With or without a tool? Simone Schalkwijk BSc Dr Felienne Hermans Dr Michiel van der Ven Dr Hans Duits RA A joint student project between the HU University of Applied Sciences Utrecht and the TU Delft University of

379 views • 10 slides

Introduction to CFIRMS Post Analysis Spreadsheets ( Defense against the dark arts 100 ) By Paul

Introduction to CFIRMS Post Analysis Spreadsheets ( Defense against the dark arts 100 ) By Paul Brooks, University of California, Berkeley. 2014 ASITA UC Davis Acknowledgments Mark Rollog, formerly USGS Palo Alto. William Rugh, EPA

1.11k views • 80 slides

WebEvent: Your Jobvite Data: Connected & Simplified With PeopleInsight www.peopleinsight.com

WebEvent: Your Jobvite Data: Connected & Simplified With PeopleInsight www.peopleinsight.com 1 2 3 Data is the HR should be Technology is game changer doing HR. Not no longer a for HR. spreadsheets. valid excuse. 20 Minute Focus

842 views • 12 slides

AS Distribution Spreadsheets Disclaimer: All spreadsheets have been updated to reflect what we

May 2015 Revenue Distribution Training Hands On Special Distributions Revenue Distribution Breakout Session B Hands On Special Distribution Calculations Revenue Distribution Training - May 2015 1 Discussion Topics Components of the

583 views • 12 slides

HOW TO SET UP EXCEL SPREADSHEETS TO MEASURE, TRANSFER AND BILL BILLS OF QUANTITIES IN A REAL

HOW TO SET UP EXCEL SPREADSHEETS TO MEASURE, TRANSFER AND BILL BILLS OF QUANTITIES IN A REAL TIME MANNER by Mr. TANG KI-CHEUNG FHKIS, RPS(QS), AVS, FSZCEA, MHKIVM Director, K C Tang Consultants Ltd., Hong Kong (E-mail kctang@kctang.com.hk)

420 views • 27 slides