Week 1 – Intro & Basic Excel

Question 1

What are the various tools a person can use in excel

Answer 1

• Formulas -
• Sorting -
• Filters -
• Pivot tables and charts -
• Powerview -

Question 2

What drives analytics?

Answer 2

• Data availability
• Inexpensive data storage
• Faster computer processing

Question 3

Why is analytics difficult?

Answer 3

• Data is power.

- Industry lacks the skills to quickly move into analytics.

Question 4

What are business examples where analytics is

important?

Answer 4

1990s: retail outlets tailored customer prices to the individual
2000: Amazon.com tailored customer web pages based on browsing and purchasing behavior in 350 milliseconds (0.35 seconds)
2010: highly customized content delivery to customers