I’m starting to play with http://d3js.org/ as it appears to be the way of the future for data visualizations. I’ve set out to create an app that serves and displays images that are in a chronological order in some kind of time-series/timeline, almost a Read More
Set additional label based on event for Quantcast
Quantcast is a great resource and data source for site owners and clients. One of the first to provide demographics data in the web analytics space. Thier feature for “labels” or “Audience Segments” as its also known is an even Read More
Web Analytics/Media Tagging on ASP.net AJAX Pages
More often than not a site build is deployed with little focus on analytics or any kind of measurement in mind- or, if it was; it was built against a moving target which is now little help to the current Read More
EASILY Bulk Load files into a table with different columns
with NO FORMAT FILE! I consider this a gem just hiding on the MSDN docs : Using BULK IMPORT on a View The following example creates the v_myTestSkipCol on the myTestSkipCol table. This view skips the second table column, Col2. Read More
Get Value from XMLA result file in NAnt with xmlpeek
If I got paid for every hour spent wrangling with XML… Oh wait, I do Problem: Read a scalar-result out of an XMLA response file from an MDX query run against a cube. Store it in a NAnt property. Jiest Read More
Get current domain from NAnt
I use NAnt for a build and deployment tool for databases and OLAP. I wanted to be able to add only the accounts needed per-environment to certain objects on the fly through the script, as they are run on whatever Read More
Analysis Services Add role members programmatically in C#
First, I don’t know why; but it seems like as soon as you add in the word OLAP or Analysis Services to your problem things just stop working as you would normally expect. Problem: I’m using NAnt as a deployment Read More
Usability: Degraded
Recently I’ve come across two cases where it appears in the interest of usability, we’ve gone too far and invaded what I thought used to be “boundaries” for UX, and proper accessibility practice. 1. Google Hijacking My Down Arrow Have Read More
ADD NEW COLUMN TO GOOGLE SPREADSHEET
Yes, ALL CAPS, here is EXACTLY what I want to do: Add new column to google spreadsheet using java api Maybe now that term will be google-able? As with everything handy, it’s impossible to find what you need in the Read More
OLAP: Make XML(A) work for you
The bread and butter at work is all the magic that happens in OLAP, Microsoft Analysis Services in particular. Alot of people assume OLAP is going the way of the Buffalo, they probably also like buzzwords such as “nosql”, “bigdata”. Read More