Intermediate Excel Course

Pivot Examples: Business Intelligence 1

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.

0 of 136 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop