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.
6- Graph the calls made over the days of the month i.e. calls on the 1st of the month, 2nd etc to see if calls are mostly made at the beginning or end of month (there is a day of month field already in the database).
7- On what day was a baby born (Clue- lots of SMS’s are sent to announce the baby- note the date as you will be asked it in the MCQ at the end)
8- How much Net Profit does the provider make off me for calls and sms’s in total over the period (Use the Net Profit Field)
9- How much Net Profit does the provider make per month
10- How much Net Profit does the provider make per month AND based on each destination (e.g. calls to Vodacom, calls to Cell C etc).
To see the full course contents click here.