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.