Exam 2 - Chapter 6

Question 1

DATA SOURCES FOR BUSINESS ANALYTICS

- _____ can come from many sources

Answer 1

DATA SOURCES FOR BUSINESS ANALYTICS

- Data can come from many sources

Question 2

DATA SOURCES FOR BUSINESS ANALYTICS
- Internal data stores
     
      
      

Answer 2

DATA SOURCES FOR BUSINESS ANALYTICS
- Internal data stores
    Archived historical data
     Data generated by applications
      Outputs from other analytical processes

Question 3

DATA SOURCES FOR BUSINESS ANALYTICS
-External data sources
     
    
   

Answer 3

DATA SOURCES FOR BUSINESS ANALYTICS
-External data sources
    Government sources (SBA, Census, etc.)
   Social Media
   Industry data sources

Question 4

WHAT ARE ‘DATA GENERATING’ SYSTEMS?

-  _____ that generate data for the ____ time

Answer 4

WHAT ARE ‘DATA GENERATING’ SYSTEMS?

- Systems that generate data for the first time

Question 5

WHAT ARE ‘DATA GENERATING’ SYSTEMS?
Examples include
 
 
  
 
 
 


Answer 5

WHAT ARE ‘DATA GENERATING’ SYSTEMS?
- Examples include
Point of sale system
Billing Systems
Social Media feeds (user generated content)
Sensors and other IOT data streams
CRM systems
Web Logs
Analytics systems

Question 6

WHAT ARE ‘DATA GENERATING’ SYSTEMS?

- Just like an assembly line, these systems generate ____ for __________________

Answer 6

WHAT ARE ‘DATA GENERATING’ SYSTEMS?

- Just like an assembly line, these systems generate data for other systems and people to consume

Question 7

WHICH DATA SHOULD I USE?
- It starts with



Answer 7

WHICH DATA SHOULD I USE?
- It starts with
Business Understanding
Data Understanding

Question 8

WHICH DATA SHOULD I USE?
- Driven by constraints



Answer 8

WHICH DATA SHOULD I USE?
- Driven by constraints
How useful is the data?
How accessible is the data

Question 9

USABILITY AND ACCESSIBILITY
- The best data is usually



Answer 9

USABILITY AND ACCESSIBILITY
- The best data is usually
Highly useful
Highly available

Question 10

USABILITY AND ACCESSIBILITY

- ____ data sources on these axes helps us to ____

Answer 10

USABILITY AND ACCESSIBILITY

- Mapping data sources on these axes helps us to prioritize

Question 11

USABILITY AND ACCESSIBILITY

- Data that is ____ ____ should be de-prioritized.

Answer 11

USABILITY AND ACCESSIBILITY

- Data that is not useful should be de-prioritized.

Question 12

USABILITY AND ACCESSIBILITY

- Remember that ____ often comes at a cost

Answer 12

USABILITY AND ACCESSIBILITY

- Remember that availability often comes at a cost

Question 13

DATA WAREHOUSES AND AVAILABILITY
- One of the purposes of the data warehouse is to increase data \_\_\_\_\_
       
        
        
      

Answer 13

DATA WAREHOUSES AND AVAILABILITY
- One of the purposes of the data warehouse is to increase data availability
Single source of truth
All of the data is in one place
Some sources can be combined with other sources to increase their usefulness
Be careful because sometimes this can work in reverse

Question 14

INCREASING ACCESSIBILITY WITH A WAREHOUSE




Answer 14

INCREASING ACCESSIBILITY WITH A WAREHOUSE
The process of putting data from a source system can increase its availability to other users
Do this correctly and you can also increase usability
Do it incorrectly and you can make the data useless

Question 15

COMBINING DATA TO INCREASE USEFULNESS
Data that comes from different source can be


This combination process generally happens at ____

Answer 15

COMBINING DATA TO INCREASE USEFULNESS
Data that comes from different source can be
Compatible with other sources
Be combined to provide a more complete picture
This combination process generally happens at staging

Question 16

DATA VALIDATION

Invalid data generates useless ______

Answer 16

DATA VALIDATION

Invalid data generates useless analytics

Question 17

DATA VALIDATION
The data warehouse is the single source of truth



Answer 17

DATA VALIDATION
The data warehouse is the single source of truth
The data must be trustworthy
Data should not be moved to the warehouse unless it has been validated

Question 18

DATA VALIDATION
Validate data at the source
      
      
      
     

Answer 18

DATA VALIDATION
Validate data at the source
     Application control
     Programmatic rule enforcement
     Data auditing and corrections
     Transformation when necessary

Question 19

how to organize priortize your data sources datagrams

usability and assessibility

difference in each classification in supervisor and unsupervisor (guarentee a couple question on that)

Answer 19

-