Analytic Basics
Step in DIKW model that would have terms like individual facts, figures, signals and measurements.
What is data.
Data from a billing, CRM, flat file, or ERP systems could all be stored in this.
What is a data warehouse.
You use this to compute the results of changing the values in one input variable and show the results of one or more output variables.
What is a one variable data table.
Best chart for displaying 90 days of sales data for three different regions.
(Temporal data)
What is a line chart.
When performing data mining what step in the data cycle should you spend the most time on.
What is setting the business objective.
The type of analytics focus on outliers, goes beyond summarization and allows for drilling into the data, can sometimes determine causal relationships and may rely on association analysis to find correlated variables all at a deeper level.
What is diagnostic analytics.
IT employee that focuses on computer hardware.
What is a network engineer.
Tab where the "What if Scenarios" are located
Data
The chart that you should use if you were going to present the composition of something such as income by product category.
Trick question...
What is a pie chart, waterfall chart, stacked bar chart or area chart. Any of these would work.
Excel function that would allow you to return a tax rate of 15% if the taxable income was over 75,000 otherwise the rate is 10%.
Hint: Think of our 401K spreadsheet example of the employer match being 7% if we saved at least 7 % otherwise it was = to what we saved.
What is =IF()
This type of data is typically added in addition to current and historical data when you move from descriptive analytics to diagnostic analytics.
What is external data.
These are the largest, most powerful computer systems.
What is a supercomputer.
You would use this if you wanted to compute the results of changing the values of one input variable and show the results of one or more output variables in a spreadsheet.
One variable data table.
Chart that could be used to show the relationship between items.
What is a scatterplot, line or bubble chart.
A stock high low chart would not work.
$A$1 is an example of this.
What is an absolute reference.
When looking at sudden changes in data you should consider all of measures.
What is:
Absolute basis (looking quarter over quarter)
Percentage basis
YOY change basis (2nd quarter last yeat to 2nd quarter this year)
YOY % Change basis. ALL OF THESE
It is fast, electronic, more expensive per byte and also called RAM.
What is computer memory.
The what if function that allows you to change multiple inputs and see multiple outputs.
What is scenario manager.
In the following formula: =vlookup(B5,C10:E15,2,False) This is represented by 2?
What is in column D will be returned if it matches what is in B5.
This is the excel feature that would work best to highlight all the classes that occurred in the Fall semesters.
What is conditional formatting.
What data technique would require large amounts of data to do.
What is data mining.
This technology is used to write data across several disks to serve as a back-up.
What is a RAID.
When incorporating a 3D reference it is easiest to use this.
What is the pointing method.
This is the tab in excel that freeze panes can be found under.
What is view.
The function that would be used if you wanted to add up all the courses that were transferred in versus taken at Loras in a spreadsheet.
What is =sumif()