Getting Data Out of Tableau Server

At Alight, we use Tableau Server – branded Channelmix.com – as our client reporting portal. This works wonderfully for getting data to our clients, but they may need it in another form for further distribution to their customers. Here are some pointers for getting data …

A Bit Wiser

Background A lot of Alight’s development work consists of writing interfaces to various different APIs. Our clients have social media data they want us to pull together (Twitter mentions, Facebook likes, Youtube shares). They have online media that we report on (Google analytics, Adwords, and …

Optimizing Media Efficiency with Google Analytics

We’re very fortunate in that we get to work with some rockstar clients who really utilize the data they’re getting out of a solution like ChannelMix and Google Analytics. Most of our clients also work with various media agencies, and often times utilize our data analysis …

Why Python

At Alight Analytics we use Python for our ETL system as well as production models.  Much of the reason for choosing Python was happenstance but looking back, it was a good choice.  When choosing a language there are many things to consider; I’ll discuss a …

What Google Tag Manager Can Do For You

With Google Tag Manager, marketers have the ability to add all of their tags to a single container to control how they will fire throughout the site. Learn more!

Stop Showing Me Pretty Graphs & Charts

There is a lot of hype and over promising by visualization software providers today. The promise of these types of providers, such as Domo and Bime to name of few, is that with their type of solution, your analytics problems will be solved. The reality …

How Marketers Should Answer “What Is It You Do Here?”

If you’re a marketer, there’s a possibility you’ve been asked, likely in the absence of any reality, this infuriating question by a salesperson: “what is it you do here again?” Salespeople live in a world between the brass tacks of success or failure. You hit …

Fun with Multi-Channel Fun-nels

Google Anaytics is great.  What marketer doesn’t want to have a bunch of data that maps out exactly how users interact with their site?  When implemented correctly, there is SO much data that can be rolled up into the interface.  And as if Google wanted to …

Cloud Plumbing

AWS and the CLI Much of Alight’s reporting infrastructure run’s on the Amazon Web Services cloud computing platform. Since we’re a Python shop, we use the boto library in our codebase. For operations and adhoc activities, though, we sometimes need to inspect the components that …