Progress

I have my own SQL server on my machine now. Frustratingly I don't really have the tie to try to do much with it as Zara is off and I'm covering her work. Managed a bit of a fiddle today and a small play with the Data Mining addin for excel which was the reason I got it in the first place. Tomorrow hopefully I will have time to try pulling a suitable data set from our sales db to see if it can tell me interesting things.

In other news, my budding acting career has died before it began as the filming I was supposed to be an extra for tomorrow got rearranged so they needed people today instead, which I couldn't do. Poo.

Have had some dashboard building successes over the past week though, developing both a new calls widget to give a breakdown of call status after downloading, and then a complete re-work of the sales activity stats and creation of a spreadsheet where the guys can see how they are doing. The sales activity one was pretty easy and is almost entirely built off the cube, aside from a couple of bits I have to enter manually (bits from systems that are totally separate and with the access I have now I can't integrate them - I think....just had a thought on that one). The calls widget has to come from the db via powerpivot as the calls data isn't in the cube. At the moment it doesn't really do anything special, but I'll see if I can improve this going forward. At the moment the manual link via the call generation is the only way to try to track downloads start to finish, so I'll be having words with the boys to try to see if I can get any halfway respectable data.