The unknown Flashcards
Problem solving and modelling process
- formulation
- solution
- interpretation
Data delivery functions
- filters unique values
- creates drop down and data validation menus
- lookup functions
Choose function
returns a value from a specified list of values on a specified position number
Modelling approach to problem solving
- benefits
- phases
- layers
Benefits of modelling approach
- timeliness
- feasibility
- economy
Components of business intelligence
- reporting
- analytics
- dashboards
What-if-analysis
The study of how the uncertainty in the output of a model can be attributed to different sources of uncertainty in the model inputs
What-if-analysis tools in excel
- goal seek
- scenarios
- data tables
Data definition language (DDL)
- defines each data element
- used by programmer and database administrators in creating a database
Data manipulation language (DML)
- query and reporting capability in database management system
- used to manipulate data
- used to get data into and out of a database
Metadata
- structure and descriptions of stores files
includes: file name, location, format
Data dictionary
- definitions of data elements and their characteristics
e. g. input mask, validation rules, mandatory/optional inputs
Advantages to master data management
- improves search effectiveness
- increases accuracy
- streamlines new product entry into the database management system
- facilitates processing of transactions
Entity relationship diagram (ERD)
-methodology for documenting databases illustrating relationships between database entities
Structures query language (SQL)
- most popular language used for interacting with a database
- allows people to perform complicated searches by using relatively easy words
e.g. where, from, select
