Innovation
What is Innovation?
A "new idea, creative thoughts, new imaginations in form of device or method."
Often also viewed as the application of better solutions that meet new requirements, unarticulated needs, or existing market needs.
What does RPA stand for?
Robotic Process Automation
What is a blockchain (in its most basic form)?
A database. A system of record or ledger.
How do you display the shortcut keys in the ribbon?
Press the Alt key
What is the most basic level of analytics?
Descriptive.
What example did Stephen Shapiro give to show what happens when your questions are too broad and you ask for opinions, suggestions, ideas?
Boaty McBoatface
What is the end product called?
Blockchains use a ______ protocol/algorithm to agree on adding transactions?
Consensus.
What is the shortcut key for moving between tabs in a workbook?
Ctrl + PgUp/PgDn
True/False: You MUST follow the data analytics steps in order.
False. Often when completing a step you learn you need to go back and collect more/better data, or reconsider your original question.
What were the three types of questions in the Goldilocks Principle?
Too Abstract, Too Specific, Just Right
Name two types of work are ideal for RPA.
Highly repetitive
Time consuming
Predefined steps
Done frequently with little change
No judgement required, just reason & merit
What is a hash?
The hash is the output of a cryptographic function. Taking whatever information was input and outputting what appears to be a random string of characters.
What does a VLOOKUP do?
VLOOKUP is a function to lookup up and retrieve data in a table. It searches for a value in the first column of a table and returns the value from the same row in specific column.
What is the difference between predictive and prescriptive analytics?
Predictive - What is likely to occur in the future based on historical trends.
Prescriptive - What actions should you take based on current and historical trends.
Who was related to the 'shoulders' in the memory enhancing Ted talk?
Bill Clinton. As all your bills were paid, which lifted the weight off your shoulders.
Name three things RPA bots can do.
Click
Type
Scrape
Create files
Modify files
Perform calculations
Extract data
Input data
Clean data
Launch & use applications
Open emails & attachments
Read & write to databases
...
We talked about public, permissionless, blockchains that rely on Proof-of-work and also ______, _______ blockchains that can use Proof-of-Elapsed Time or Proof-of-Authority.
Private, Permissioned
In VBA, the code for macros always starts with ____ and ends with ____ ____.
Sub
End Sub
Don't over think it - What is the most important starting point with analytics?
The right question! A focused goal to move toward that has a meaningful business reason.
In design thinking, what was the error we all made during the introduction of the wallet exercise? (In Step 1.)
False-Start. We started before we took the time to understand the user needs.
What are two limitations of RPA?
Lacks judgement capability
Static, cannot learn
Has to be updated if inputs/applications change
Can only read electronic data and requires structured inputs
What is a smart contract?
A contract that is written in code, loaded/instantiated onto a blockchain, and can trigger/execute transaction events.
What line of code would change the font size of a selected cell or range?
Selection.Font.Size
Name all 4 levels of analytics.
Descriptive, Diagnostic, Predictive, and Prescriptive.