Data Analysis Techniques
Techniques to transform and interpret data in a useful way.
Quantify Impact
I want to, Understand how big is a change.
(i.e. calculate the relative change)
How
Lets say a bank raised a rate from 3% to 5%, difference is 2% but is ambiguous to say “the rate was increased by 2%”. It looks like a very small increase, from a +2 increase from an original of 3.

Absolute change was 2% but

Relative change (5  3) / abs(3) = 0.66(6), so rate was increased by 66%.
Relative calculation general formula: (new  reference) / abs(reference)
For negative numbers needs that denominator to have abs(), to force negative number into a positive one.
I want to, Understand how much is one number bigger than other
You looking at a table of numbers, and comparing 2 numbers, wondering by how much one is bigger than the other ?

Starting with: 22 out of 4236

approximate to a rounder number 20 out of 4000 (some precision is lost but depending on application that is often ok)

take out same number of 0’s from each (dividing by 10) 2 out of 400

divide to get the smaller number to 1, try divide by prime numbers under 10: 2, 3, 5 or 7 (in this case 2) 1 out of 200
I want to, quickly size up something to see how important it might be
The art of guess estimating can be very useful to quickly run numbers on what is going to happen, or impact, etc…
Data Quality: confidence interval
I want to
Give out some certainty on the average number i am giving out, by adding a range to where is this number is expected to fall into, most of the time.
How
When estimating a parameter like a mean from random samples, confidence interval helps quantify uncertainty, giving an interval in which we can expect the value to be most of the time.
Prepared Excel: confidence_interval.xlsm
Python:
def confidence_interval (s):
from scipy import stats
import scipy as sp
import numpy as np
import math
n, min_max, mean, var, skew, kurt = stats.describe(np.array(s))
std=math.sqrt(var)
#The location (loc) keyword specifies the mean.
#The scale (scale) keyword specifies the standard deviation.
# We will assume a normal distribution
R = stats.norm.interval(0.975,loc=mean,scale=std/math.sqrt(len(s)))
return R
Data Quality: hypothesis testing
I want to, Make sure the results i got are statistically significant (and not due to chance).
Test of Proportion
For comparing percentages metrics like Conversion Rate, Clickthrough Rate etc, use a proportion test.
Finding Sample Size
To find what sample size is needed for a test, use:
In R stats:
To go from a 1.5% to a 2.5%, thus a 1% increase rate, at a 5% significance level and 80% power of test:
> power.prop.test(p1=0.015, p2=0.025, sig.level=0.05, power=0.8)
Twosample comparison of proportions power calculation
n = 3075.582
p1 = 0.015
p2 = 0.025
sig.level = 0.05
power = 0.8
alternative = two.sided
We need at least 3076 samples in each group.
In Python:
To go from a 1.5% to a 2.5%, thus a 1% increase rate, at a 5% significance level and 80% power of test:
> import statsmodels.stats.api as sms
> es = sms.proportion_effectsize(0.015, 0.025)
> sms.NormalIndPower().solve_power(es, power=0.8, alpha=0.05, ratio=1)
We need at least 3029 samples in each group. (not sure why they not exactly same as in R, might use slightly different calculation approximations)
Test if statistically significant
ChiSquared Test
In R:
For example, to test two campaigns each with a 1000 displays, 32 and 54 conversions:
> prop.test(c(32, 54), c(1000,1000))
2sample test for equality of proportions with continuity correction
data: c(32, 54) out of c(1000, 1000)
Xsquared = 5.3583, df = 1, pvalue = 0.02062
alternative hypothesis: two.sided
95 percent confidence interval:
0.040754721 0.003245279
sample estimates:
prop 1 prop 2
0.032 0.054
The pvalue is less than 0.05, so we can reject the hypothesis that conversion rates are equal and assume the second group has a higher rate.
Prepared Excel: hypothesis_testing_proportion.xlsm
Prepared Excel: hypothesis testing proportion_Chisquared.xlsm
Reference:
 Comparing Population Proportions 1  https://www.youtube.com/watch?v=a1Ye5RcWOqg
 Comparing Population Proportions 2  https://www.youtube.com/watch?v=MNbat1lrJW4
 Hypothesis Test Comparing Population Proportions (part 3)  https://www.youtube.com/watch?v=dvSa_tx04hw
Test of Means
Comparing nonfractional values that follow a normal distribution (e.g. Average Order Value, Time Spent on Page etc.) is done with a Twosample unpaired ttest.
Welch Two Sample ttest TwoSample TTest
Find Sample size
In R:
The recommended values for h are: 0.2 for small effects, 0.5 for medium and 0.8 for big effects. Sample call for computing the test sample size for a campaign with an estimated medium effect and 10000 customers in the control group:
> pwr.t2n.test(n1=10000, d=0.5, sig.level=0.05, power=0.90)
t test power calculation
n1 = 10000
n2 = 42.21519
d = 0.5
sig.level = 0.05
power = 0.9
alternative = two.sided
Only around 43 customers are needed in the test group.
Test for significance
In R:
> t.test(group1, group2)
Welch Two Sample ttest
data: group1 and group2
t = 1.5631, df = 99.423, pvalue = 0.1212
alternative hypothesis: true difference in means is not equal to 0
95 percent confidence interval:
7.0219603 0.8334419
sample estimates:
mean of x mean of y
125.0789 128.1731
Our pvalue is greater than 5% so we cannot reject the hypothesis that the values are different. More tests or a larger sample size may be necessary.
Reference:
 http://www.marketingdistillery.com/2014/08/03/abtestsinmarketingsamplesizeandsignificanceusingr/
 http://www.evanmiller.org/abtesting/ttest.html
 http://stattrek.com/hypothesistest/hypothesistesting.aspx
Data Quality: Get an idea on the dispersion of the data
I want to
Get an idea on the dispersion of the data, what values are more common, what values are outliers.
See chart type Histogram and Boxplot from: http://al3xandr3.github.io/datavisualizationtechniques.html
Simulations
This is a great way to test out models / hypothesis / behavior by generating random and (on purpose) biased data to test, evaluate formulas, algorithms, theories. And this is something that computers are great at, and that a few years ago was not possible to do.
This also allows for optimization, plot the convergence over time, see if possible to make the algol converge faster, plot the simulation progression over time.
Specifically, can be useful for:
 Generate random data
 Try to guess what should it look like.
 Predict the future (based on the historical observations)
 Simulate theories, instead of complex math: hypothesis testing alternative, resampling
Sometimes in paper is enough. Paper is costly (especially in time) to run many simulations. To get for example the distribution of the solutions. For more than a few executions, use a computer (Excel, Python, Ruby, R, etc…).
Example:
 Given the history of values, what is the expected value in a week?
 Given the history of values, in how many days is expected to reach a certain value ?
 Trying to figure out whether the data im looking is being generated by sampling on visitors or being generated by sampling on visits, do a simulation on paper on what are the expected volumes sizes for each, see which one is closer.
Python Code: simulate.py
http://en.wikipedia.org/wiki/Resampling_(statistics)
Analysis: Reveal impacting features in a specific goal.
Lets say i am looking at a web site new user registration flow, and i want to find areas that can be improved, for example i might find that users in mobile devices in Portugal are having a hard time to register and that consequently might lead to the finding that a page in that flow is incorrectly translated.
For then we need to break down the data by the dimensions available and look at them combined, to find strong signals.
This is also useful to pin down performance problems or even outliers.
How to
 Decide on the main goal to use, for example, the registration rate (completed registration / started registration)
 Create (probably multiple) break downs by all the variables available to you (Country, Operating System, Device, Browser, Entry Page, Channel, referrer domain, etc…)
When doing breakdowns:
 Keep in mind the context of the data, what dimensions make sense to look into and which ones it does not, start there.
 Discard dimensions  Find if there’s enough volume in that dimension to be worth pursuing or not.
 Discard dimensions values lower than a significant volume (rows of a dimension, keep only the top 100, or 1k, etc…), not worth the investment of fix for Antarctic where there’s only 1 person getting stuck in the registration. For example a column in Excel named Worth looking at? =IF(AND(G41>100, H41< 40%), TRUE, FALSE)  that is enough volume and bad performing, then label with True.
 Play around with the breakdowns, try combining in different orders, find generalizations, example mobile vs nonmobile users, instead of looking at operating systems list (in case they are significant enough). Find the simplest breakdown possible to find strong signal, look to simplify. End up with a couple of high level dimensions, containing only a few values (mobile vs nonmobile and natural vs paid search, for example).
 Choose dimensions and the way to analyze them on the way they can be acted upon, example android failing to register will mean a fix in the android dedicated web flow. For a bad performing referrer domain maybe makes more sense to pick up only the very successful ones and try to incentive those more, the bad performing ones, nothing much can be fixed there.  varies a lot on situation.
Classification
Create a classification, so that we enrich the data set with new useful features to analyze the rest of the data with. Also to use as modeling parameters.
This could include classifying for example: user behaviors, user value, etc…
Clustering and Similarity matching
Find what characteristics users that churned have (a churn model), then look for similar users cohorts from your user base that have similar characteristics and thus potentially at the risk of churning, create hypotheses on activities to help reduce churning.
Regression
Regression as an estimation / prediction technique
What results are we getting in 3 months if this trend continues? When are we getting to result XYZ?
Regression as a causal modeling technique (aka correlation finder)
Regression can be used in explaining how one or many (using multivariate regression) factors affect an outcome of interest.
For example, what contributes more to a movie final revenue is it the movie budget size or the viewers rating? Likely both things influence it… For example a movie with a very low budget can’t compete with a huge budget movie in general, but a big budget movie can also end up not being liked by viewers. So which of those 2 variables contribute the most to the final movie revenue ?
Here we can build a regression model that exactly quantifies how much these contribute to the revenue, given a set of historical data.
Data Cleaning: Fill in missing values
Python and Pandas:
You may use reindex() method of DataFrame:
x = pd.date_range('20130101','20130107',freq='D')
y = range(7)
df=pd.DataFrame(index=x,data=y,columns=['value'])
To add missing days (like holidays) you need to reindex it:
x2= pd.date_range('20130101','20130107',freq='4H')
df2=df.reindex(x2)
Then you may fill the gaps in values using interpolate() method of Series (different interpolation methods are available):
df2.value=df2.value.interpolate(method='linear')
Reference: http://stackoverflow.com/questions/20240749/pandasdataframeinterpolatingmissingdays
Optimization
Optimization Process
Baseline  where you are now?
 what KPI’s are important to look at given the goal? Learn the domain, ask the big scope questions: what is the purpose of this? Why this exists? What do i need to look at to know the end goal is improving?
 Do I have this data ? Need to add more instrumentation ?
 Setup reports / dashboards
Formulate hypothesis on what to change to get to the goal
 play with the data, to came up with theories and hypothesis to test, try correlations, plot, visualize, from different angles, maybe use also external data if possible
Test (A/B test)
 do a change and see its impact on the KPI’s.
 output a story, communicate, put in slides if needed, the results
Iterate
 Go back to Baseline and start again. We using the right KPI’s ? (often the 1st ones are not great)
 more hypothesis, more tests (once in a while might find something worthwhile … )
AB testing
Because correlation does not (always) imply causation, this is the way to test an hypothesis created from an observed data correlation. (output from a previous data science method).
This also, for example, the approach that the medical community uses to tests whether a new medication is effective or not. And is a fairly common solid scientific method.
Hypothesize how to make to make it better, run an experiment to validate it. Assist product changes by ab testing it, and measuring its consequences…
The setup of an experiment is to compare 2 groups where the variable we want to test is different for each group, while keeping all the other variables (possible confounding factors) the exact same. (see also https://en.wikipedia.org/wiki/Ceteris_paribus)
We essentially need 4 data points, these 2 metrics for each group:
 Test group size (at the start of experiment)
 Success group size (at the end of experiment)
We need to assure the experiment runs for enough amount of time so that we can be sure of the results (statistical significance). Apply a proportion test for example (https://www.khanacademy.org/math/probability/statisticsinferential/hypothesistesting/v/largesampleproportionhypothesistesting).
references: sample sizes http://camdp.com/blogs/numbersamplesneededbtest
Intelligent Agents Model
Amazingly, Optimization, AB & Multivariate Testing, Behavioral Targeting, Attribution, Predictive Analytics, … can all be recast as components of a simple, yet powerful framework borrowed from the field of Artificial Intelligence, the intelligent agent.
Artificial intelligence Optimization Process
The goals are what the agent wants to achieve, what it is striving to do.
When the agent achieves a goal, it gets a reward based on the value of the goal.
Given that the agent has a set of goals and allowable actions, the agents task is to learn what actions to take given its observations of the environment – so what it ‘sees’, ‘hears’, ‘feels’, etc… Assuming the agent is trying to maximize the total value of its goals over time, then it needs to select the action that maximizes this value, based on its observations.
So how does the agent determine how to act based on what it observes? The agent accomplishes this by taking the following basic steps:

Observe the environment to determine its current situation. You can think of this as data collection.

Refer to its internal model of the environment to select an action from the collection of allowable actions.

Take an action.

Observe of the environment again to determine its new situation. So, another round of data collection.

Evaluate the ‘goodness’ of its new situation – did it reach a goal, if not, does it seem closer or further away from reaching a goal then before it took the past action.

Update its internal model on how taking that action ‘moved’ it in the environment and if it helped it get or get closer to a goal. This is the learning step.
By repeating this process, the agent’s internal model of how the environment responses to each action continuously improves and better approximates each actions actual impact.
Reference: http://conductrics.com/intelligentagentsabtestingusertargetingandpredictiveanalytics/
Tools
Tool is just the means to an end choose the best tool for the job at hand.
Excel is the notepad for data, great for a quick look, quick chart, prototype, final UI for a adhoc analysis, mostly used for EDA phase. Handles well small dashboards and reports, and some data manipulation, but from a certain size/complexity starts getting too time consuming and better to move on to next tool.
Python, is great on data ETL, data automation, handles building a data product with increasing complexity and size (as opposed to Excel) but also not too bad for EDA, especially with IPython. Fully automated dashboard that creates and html report, sends email to people, runs in a server by itself, with very low maintenance. Allows reproducible data analysis. Might miss all the absolute latest most complex machine learning algorithms.
R is the most complete statistical and machine learning algorithm collection available (?). Better for running algorithms that do a specific thing, not to good to build complex automations and logic on top (compared to python).
Tweetcomments powered by Disqus