Pivot Examples: Business Intelligence 1

Please sign up for the course before starting the lesson.

Pivot Examples: Business Intelligence

Now using the data available and what you have learnt, answer the following questions about this data. You can do it whatever way you want.

1- What are the top 5 most dialed numbers (based on the sum of bill) over the entire period for weekdays, and weekends?

2- Graph what time of day Voicemail is usually retrieved (use call duration as data)?

3- Graph what time of day are SMS’s sent?

4- What date has no calls or sms’s? (try for a bit and then look at the solution- bit of a trick question)

5- What was the time of the earliest call or sms over the period and what was the latest?

To see the full course contents click here.

Back to: Intermediate Excel Course > Pivot Tables