Anand's Anecdotes Excel - Overview

In this segment, you will listen to a few anecdotes from Anand's past experiences with Excel and analytics.  

Also, you will understand the importance of the type of analysis you have just learnt i.e. segmenting the data into buckets and understanding which segments are more important for the business.

In the telemarketing case-study, the most important question was to identify the most important customer segments. It turns out that this type of analysis is one of the most widely used in the industry, primarily because it leads to actionable insights. 

It is important to remember that analytics is useful only when it can be used by the business. It doesn't matter if you have a lot of data and sophisticated analytics tools; if the analysis doesn't lead to actionable business insights, it is useless.

Thus, it is important for you to ask the right questions before starting the analysis. Anand will talk about a few things to keep in mind while doing so.

You saw that the most common analytics questions are similar across industries - which are the top 10 'x'.

For example, in our case-study, we wanted to know the top customer segments based on their propensity to buy a bank's loan product. 

In the next few segments, you will learn data visualisation and ways to use plots to explore and present data.