BMGT 301 Lecture 1: Lecture 1

43 views2 pages

For unlimited access to Class Notes, a Class+ subscription is required.

BMGT 301: Information Systems
January 26th, 2017
Databases
A database is a table or collection of assorted things complied together.
Step 1: Understand the data
Step 2: Organize the data
Step 3: Summarize the data
Data Information & Knowledge
Apply knowledge to data to turn it into information
10 Bites - Excel
Pattern Recognition Techniques
“Power Pivot”
Flash Fill 2013 & up
Case insensitive
Functions
Ex: =Average, = IF, put the function after the equal sign, then place a
(arg1,arg2,…arg[n])
Anything in square brackets will be optional, not necessary. No spaces between comma
and arg.
All the functions will have the same syntax.
Power Functions
= AverageIF
= SumIF
find more resources at oneclass.com
find more resources at oneclass.com
Unlock document

This preview shows half of the first page of the document.
Unlock all 2 pages and 3 million more documents.

Already have an account? Log in

Get access

Grade+
$10 USD/m
Billed $120 USD annually
Homework Help
Class Notes
Textbook Notes
40 Verified Answers
Study Guides
1 Booster Class
Class+
$8 USD/m
Billed $96 USD annually
Homework Help
Class Notes
Textbook Notes
30 Verified Answers
Study Guides
1 Booster Class