I have a bunch of websites that have the same structure and content that vary only by the category for each site. So content for all sites can reside in a single database schema and filtered to specific categories for each site. In order to do this I created a custom CakePHP application with one […]
Single CakePHP application & MySQL database to serve multiple domains Read More »
Back in the days when I was working in environmental science, the consulting firm I was working for was doing storm water drainage planning in Surrey, BC, Canada. The City of Surrey was planning for a new sub-division. The new sub-division would have lots of new hardened surfaces eg roads, roofs, and lawns instead of
How a new salmon stream was carved from the land Read More »
I happened to have an dataset of Car2Go vehicle locations in Vancouver and used Tableau to plot them by latitude and longitude. There are a lot of observations over the time data was collected. There are limited physical number of parking spots so cars are parked in locations that are very close to other car
Tableau vizualization of Vancouver Car2Go vehicle locations Read More »
This is a Qlikview solution I posted on Qlikview’s forum in response to a user request for displaying employee work schedules in a Gantt chart style presentation. https://community.qlik.com/thread/51554 The solution included setting up the data for the Qlikview chart in a table format as shown below. Original: Load WorkDate, Employee From [C:\BI\schedule demo – data.xls]
How to vizualize a work schedule using a Qlikview Gantt chart Read More »
UK wedding marquee rental website Google analytics data was analysed using Tableau Public. The client’s target geographic area is UK Northwest centered around Manchester. It was interesting to see significant number of site visitors from Pakistan, India and Phillippines. A bit of customer research reveals that these site visitors are friends and family helping with
How a UK tent rental company used Google analytics and Tableau to improve sales Read More »
