Excel Process
You should you always do this before you sort data in Excel.
What is save the file.
The purpose of predictive analytics
What is determine what might happen
The correct Parameter in a VLOOKUP function if you want it to return the exact result
What is False
In the DIKW data hierarchy this is best represented by applied knowledge.
What is knowledge
Which of the following IT employees would have overall responsibility for all the organizations systems?
What is the CIO (Chief information Officer)
You would use the advance filter option instead of the filer option if you wanted to do this.
What is extract the list of selected records
One of the reasons that predictive analytics is becoming more widely used.
What is:
Growing volumes of data
Software is easier to use
Computer power is cheaper and faster
Need for competitor differentiation due to tougher economy
If you are displaying stock prices along with a moving average line what would cause the line to be smoother or flattest line.
What is more days.
This is another way of saying data is everywhere
What is ubiquitous
Step in the DIKW model would have terms such as facts, figures, signals and measurements.
What is Data
Tabs in Excel that has the sort tools.
What is Home and Data.
The type of data that is used to train predictive models.
What is historical data
The formula you would use to count text values in cells, such as names.
What is CountA()
if your organization built a predictive model to determine if a potential customer was a good credit risk this would be an example of this type of model.
What is a classification model.
A big retailer like Walmart will see big swings in sales on particular items due to this.
What is seasonality.
You should do this to the data before you use Microsoft Excel's subtotal feature.
What is sort
Type of analytical technique that would look at what things happened.
What is descriptive
Function that includes the following: database range, criteria range, field to sum.
What is =DSUM()
A series of yes/no question would indicate this type of predictive model.
What is a decision tree.
Another term for time-based data
What is temporal
A students network ID would be a good example of this item used in database structure.
What is a primary key.
Data used in diagnostics analytics that is different from that used in descriptive analytics
What is external data.
A tool that might be easier to use than data base functions such as =DAVERAGE().
What is a Pivot table
The most important step in the data lifecycle.
What is identify or formulate the problem.
A method of reviewing large amounts of data to obtain information.
What is data mining.