Hypnopoison
New member
- Joined
- Oct 29, 2016
- Messages
- 12
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi everyone
I'm new and I was hoping I could ask for some help please, as I'm a bit stuck :-(
I am attempting to make a Telesales Call Centre monitoring Power Pivot file, which will monitor outbound call volumes against target, by the hour.
I'm able to link to my source data ok, but I understand that I need to add a calendar table in my data model, and I have found many tutorials to show me how to create one, but what none of them seem to include is how I include the times for each of the days in the calendar table.
Ideally for each date listed in the table, I'd have the corresponding hours of the day, I was thinking of using 30 minute increments (but not sure if it would be better to include set increments or every minute of every day), to enable me to compare actual outbound call volume against the hourly targets.
Does anyone know how to to create such a calendar/time table using either Power Pivot or Power Query?
I've attached a quick example file to show what I'd need to create but including every day from 01-01-2016 for the next few years.
I could create this manually in Excel - but that might take quite a while and I thought that there has to be a more efficient way to do this.
Any help would very much appreciated.
Thanks
Regards
Debbie
I'm new and I was hoping I could ask for some help please, as I'm a bit stuck :-(
I am attempting to make a Telesales Call Centre monitoring Power Pivot file, which will monitor outbound call volumes against target, by the hour.
I'm able to link to my source data ok, but I understand that I need to add a calendar table in my data model, and I have found many tutorials to show me how to create one, but what none of them seem to include is how I include the times for each of the days in the calendar table.
Ideally for each date listed in the table, I'd have the corresponding hours of the day, I was thinking of using 30 minute increments (but not sure if it would be better to include set increments or every minute of every day), to enable me to compare actual outbound call volume against the hourly targets.
Does anyone know how to to create such a calendar/time table using either Power Pivot or Power Query?
I've attached a quick example file to show what I'd need to create but including every day from 01-01-2016 for the next few years.
I could create this manually in Excel - but that might take quite a while and I thought that there has to be a more efficient way to do this.
Any help would very much appreciated.
Thanks
Regards
Debbie