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
Query by example (QBE)
- user fills out template/grid (form)
- drag and drop
Characteristics of a data warehouse
- time variant
- non volatile
- multidimensional
- integrated
- organized by business dimension or subject
- use online analytical processing
Social network analysis
- process of investigating structures through the use of networks and graph theory
- points connected by links
e.g. family / financial ties
Sensitivity analysis
- the study of how the uncertainty in the output of a mathematical model or system can be divided and allocated to different sources of uncertainty in its inputs
3 examples of data visulation features in excel that can be used to create dashboards
- summarized and highlighted text
- calculated data and summary metrics
- conditionally formatted data - icons
- alerts
- up / down
- on / off - graphs and charts
- line charts
- pie charts
Filed properties in access that can be used to customer the way users view your table
- input mask
- validation
- format
New consultative functions of MIS department
- install and design
- system integration
- innovative ideas
- alliances with other business partners
Traditional functions of MIS departments
- system development
- computer operations
- staffing, training, developing
- infrastructure, planning, development and control
WIKI characteristics
- web-based
- collaborative
- interactive
