Please enable JavaScript.
Coggle requires JavaScript to display documents.
Interview Topics - Coggle Diagram
Interview Topics
Technologies
Visualizations in Tableau
Statistical Softwear: Python
Database Managment: SQL:
MIssed the explanation of doing a left join.
Marketing Tools: Google Analytics
mise the explanation of WITH STATEMENTS ITS ORACLE
Process and Methodologies
Brand Awareness
Unaided Recall
Pre and Post Brand Awareness:
Take questionaires with brand perception Unaided Recall, and Aided recall before and after the tv campaign. (Within Group Differences)
I prefer the use of control groups but in the case of tv adds its harder to assure whether they see the spot or not. Manytimes a way to go about this is using geography. (In Andalucia Region but not in Valencia).
Conduct Surveys:
The data collection process needs to run a significant amount of time or interview enougth people so that the results are meaningfull. This involeve a priaori knowledge of a ballpark value of the effect size.
Hypothesis Testen:
Define Hypothesis:
Those who saw the Advertisement Incresed brand Perception, Unauded Recall and Aided Recall significantly.
Runung Test Statistics :
e.g. for categorical data.
Aided Recall
Brand Perception
A/B Testing:
One gorup of users see futures and another dont. Random assignation to cotron and treatment group. Running test for sufficient duration. Analyse difference in
conversion rates
. Sifgnificant results impliy the new future is significant.
conversion rates
click-through rate
revenue-per-visitor
Prediction and Regression modelling
Linear regression:
Linear regression is a statistical method used to model the relationship between a continuous dependent variable and one or more independent variables by fitting a linear equation to the observed data. e.g. predicting sales based in marketing spending
Logistic regression:
In statistics, the logistic model is a statistical model that models the log-odds of an event as a linear combination of one or more independent variables
Time Series Forcasting
ARIMA
Data Analyst Role (Exp & Skills)
Expirience
Expirience with A/B Testing ?
click-through rate to determine best recommendation system. Appled to all of our active customer database (at least one order recently). Product team made the change on the web. I applied a t-test to determine the significance of the change. No change was found. We decided to run the test longer.
missed the explanation of doing a confidence interval, wropng kind of test for the a/b testing.
Can you describe your experience with marketing analytics?
goe to drive script
Skills
Data Quality & Integrity