Technical

Question 1

What’s the difference between an observation and an insight?

Answer 1

Observations are just raw data (i.e. things you saw and heard) — what you recorded without judgment. Insights, however, are a deeper interpretation and understanding of what you are seeing and hearing.

Question 2

What is an insight?

Answer 2

An insight is the identification of cause and effect relations among elements of a data set that leads to the formation of an action plan which results in an improvement as measured by a set of KPIs.

Question 3

What is a KPI?

Answer 3

KPI stands for key performance indicator. It is a quantifiable measure of performance over time for a specific objective.

Question 4

Name 4 characteristics of insights.

Answer 4

Stable: i.e. if I use two different samples from the same data set to create a predictive model, then the resulting models have to provide the identical result under the same new data input.
Reproducible: regardless of how many times a feed a particular data set through an insight-generation system, the same insight will be produced.
Robust: in big data environments a certain amount of noise in the input data will not diminish the quality of the insight.
Enduring: the insight is valid for an amount of time that is related to the underlying data’s “half life.”

Question 5

For this company, what are the most important measures and KPIs to track?

Question 6

What kind of clients do we serve?

Answer 6

Pharmaceuticals!

Question 7

What services does DH offer?

Answer 7

Branding
Launchworks
Agile content
Fluid CRM
Health innovation
Product and service design
Technology strategy and enablement
Data and analytics

Question 8

What is CRM?

Answer 8

Customer Relationship Management: a process in which a business administers its interactions with customers, typically using data analysis to study large amounts of information

Question 9

Tell us your current favorite ad campaign

Answer 9

Hims/Roman – They position these medical conditions as not something to be swept under the rug, but rather as something to talk about freely.
And they do it by using casual, friendly language. Very un-pharma like, even going so far as to mock traditional pharma ads

Question 10

There are two mobile restroom stalls at a construction site where I work.
There are also three situations that have an equal chance of occurrence:
a. none of them is occupied
b. only one of them is occupied
c. both are occupied

1. If I were to pick one at random, what is the probability that it is occupied?
2. If it turns out that that first one I go to is occupied and I decide to try the other one, what is the probability that the second one is also occupied?

Answer 10

1. There are also three situations that have an equal chance of occurrence - meaning each have probability 1/3 to occur.
   1/3 - the probability that I chose the option where they are both occupied.
   1/3 * 1/2 - the probability that if one occupied and the other isn’t , I chose the one that is occupied
2. .25

Question 11

what is logistic regression?

Answer 11

Logistic regression is a predictive analysis. To explain the relationship between the one dependent variable with another independent variable

Question 12

Imagine a cube 1x1x1, then imagine that you form a cube of 10x10x10 with all these little cubes of 1x1x1. How many cubes do you have to remove to get rid of the surface of cubes.

Answer 12

488

10x10x10) - (8x8x8

Question 13

Measures and Dimension in Tableau ?

Answer 13

Dimensions contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view.

Measures contain numeric, quantitative values that you can measure. Measures can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default)

Question 14

what’s your most proud project?

Question 15

Experience that relate to the requirements of the position

Question 16

In an 8x8 checkerboard, how many squares are in it totally?

Answer 16

204

Question 17

Explain P-Value in a given marketing context. As if you are presenting to the client.

Answer 17

If Null Hypothesis says advertisement campaign is not effected by hurricane storm. suppose if the p value is 0.045 so explanation would be there is 4.5% chance that Null Hypothesis is True. As p <0.05 we can reject the null hypothesis

Question 18

If we do an A/B testing, how would you divide the population, like percentage-wise?

Answer 18

Never 50%– then who’s left to send the winning Test to. My Rule is stick to 20/80… 20% of your list gets tested and the the other 80% gets the winner/ (Best performer), be it subject line or content.

Question 19

Email conversion rate. How do you calculate further significance?

Answer 19

Use Statistical p-test, z-test, two sample t-test

Question 20

Name a very bad product and tell me why it’s so bad. What I would do to overcome the challenges from a marketing perspective?

Answer 20

Astro – ads don’t focus on privacy

Question 21

You’ve listed many skills on your resume. Does that mean that we could throw any of these technologies and skills at you right now and you’d be able to show us expert proficiency in all of them?

Answer 21

I have worked with all of the technologies that I listed, so I have at least strong familiarity with all of them, a few more advanced proficiency than others. However, for example, if you wanted me to create a detailed flowchart

Question 22

Why should we hire you as you do not have any experience whatsoever in our Industry ?

Answer 22

willingness is the major catalyst for success ,If i feel I can then i will be the outstanding performer