A client had a time based activity that had a start and end datetime . The client wanted to be able to calculate a service level agreement (SLA) metric based on the duration of time to complete the activity. This SLA included requirement that time only be included in the metric if it was during […]
Time based SLA KPI created using MS Access VBA Read More »
This is based on City of Toronto’s Open Data website 311 call performance data for the 4 years 2010, 2011, 2012 and 2013. The data is provided by the City in a Google Spread Sheet and has been downloaded and saved here in Excel 2013 format 311_daily_contact_centre_data. I used Excel pivot tables and charts for analysis and
Visualization of Toronto’s 311 contact centre open data Read More »
Car2Go provides developer access to their real-time vehicle location and parking availability, and service area boundaries for all of their city locations around the world. I was using the Car2Go API to power a website created for my own use after struggling with the official Car2Go map on their site when using my mobile phone. I
A while back LinkedIn sneakily vacuumed up all of my contacts from my phone via the Android Cardmunch app. Turns out Cardmunch is owned by LinkedIn. There must be fine print somewhere that indicates they do this but I sure didn’t see it. Many of my contacts that were imported were out of date and in
LinkedIn ‘People You May Know’ web scraping and analysis Read More »
This Sankey chart represents human arterial blood flow from the heart down into the smallest named arteries. A Sankey chart visualizes directional connections between nodes. In this case the nodes are artery names and the connections are flow of blood through the arteries. The full sized chart is huge, so first take a look at
Visualizing human arterial blood flow with a D3.js Sankey chart Read More »
