'Csci n207 data analysis' presentation slideshows

9a. Charts

CSCI N207 Data Analysis Using Spreadsheet. 9a. Charts. Lingma Acheson linglu@iupui.edu. Department of Computer and Information Science, IUPUI. Purpose of Charts. Provide a pictorial representation of your data Help understand data better E.g. N207 Spring Grades. Purpose of Charts.

236 views • 12 slides

5 . Database Design

CSCI N207 Data Analysis Using Spreadsheets. 5 . Database Design. Lingma Acheson Department of Computer and Information Science IUPUI. What Design is About. You are hired by a small business, and are asked to build a database system. How would you proceed?

234 views • 11 slides

11. Multivariate Analysis

CSCI N207 Data Analysis Using Spreadsheet. 11. Multivariate Analysis. Lingma Acheson linglu@iupui.edu. Department of Computer and Information Science, IUPUI. Multivariate Data Analysis. Univariate data analysis concerned itself with describing an entity using a single variable.

290 views • 11 slides

2 a . What and Why Database?

CSCI N207 Data Analysis with Spreadsheets. 2 a . What and Why Database?. Lingma Acheson Department of Computer and Information Science IUPUI. What is a Database?. In a general sense, a database is any organized collection of data. Examples: Grocery List Audio CD Catalog Phone Book

274 views • 10 slides

220 views • 10 slides

106 views • 10 slides

4 b . Structured Query Language - WHERE Clause

CSCI N207 Data Analysis with Spreadsheets. 4 b . Structured Query Language - WHERE Clause. Lingma Acheson Department of Computer and Information Science IUPUI. SELECT Statement and WHERE Clause. Select all columns and some rows Example 1, show only employees from the accounting department:

191 views • 9 slides

6 . Database Reports

CSCI N207 Data Analysis Using Spreadsheets. 6 . Database Reports. Lingma Acheson Department of Computer and Information Science IUPUI. What are Database Reports. Printed documents that display information from a database in a clear and well-organized manner.

209 views • 9 slides

4 a . Structured Query Language - SELECT Statement

CSCI N207 Data Analysis with Spreadsheets. 4 a . Structured Query Language - SELECT Statement. Lingma Acheson Department of Computer and Information Science IUPUI. WPC Database.

170 views • 8 slides

4 c . Structured Query Language - Built-in Functions

87 views • 8 slides

9c . Line Charts

CSCI N207 Data Analysis Using Spreadsheet. 9c . Line Charts. Lingma Acheson linglu@iupui.edu. Department of Computer and Information Science, IUPUI. Line Charts. Univariate analysis Data represented as single-valued points. Data values are on the y-axis. X-axis contains data labels only.

117 views • 4 slides