Sitting for a Data Scientist or a data analyst interview, you can afford to miss this post!

So you have decided to save the world by finding insights from the data which are otherwise not visible to the  naive world out there So if you are not sure of what data scientists are doing and how it is impacting the world then we advise you to follow our facebook page by clicking here

So I hope that you have already liked our page and have clicked on 'Following' by now. So now its time to get your hands on to some interview questions that may helpful while sitting in any interview.

Our friend who is working for an analytic firm has been generous enough to provide these questions and answers to us. If you find these of any use we would appreciate if you could leave a thank you note in the comment box below.

Question 1. Can you outline the various steps in an analytics project?

Broadly speaking these are the steps. Of course these may vary slightly depending on the type of problem, data, tools available etc.

1. Problem definition – The first step is to of course understand the business problem. What is the problem you are trying to solve – what is the business context? Very often however your client may also just give you a whole lot of data and ask you to do something with it. In such a case you would need to take a more exploratory look at the data. Nevertheless if the client has a specific problem that needs to be tackled, then then first step is to clearly define and understand the problem. You will then need to convert the business problem into an analytics problem. I other words you need to understand exactly what you are going to predict with the model you build. There is no point in building a fabulous model, only to realise later that what it is predicting is not exactly what the business needs.

2. Data Exploration – Once you have the problem defined, the next step is to explore the data and become more familiar with it. This is especially important when dealing with a completely new data set.

3. Data Preparation – Now that you have a good understanding of the data, you will need to prepare it for modelling. You will identify and treat missing values, detect outliers, transform variables, create binary variables if required and so on. This stage is very influenced by the modelling technique you will use at the next stage.  For example, regression involves a fair amount of data preparation, but decision trees may need less prep whereas clustering requires a whole different kind of prep as compared to other techniques.

4. Modelling – Once the data is prepared, you can begin modelling. This is usually an iterative process where you run a model, evaluate the results, tweak your approach, run another model, evaluate the results, re-tweak and so on….. You go on doing this until you come up with a model you are satisfied with or what you feel is the best possible result with the given data.

5. Validation – The final model (or maybe the best 2-3 models) should then be put through the validation process. In this process, you test the model using completely new data set i.e. data that was not used to build the model. This process ensures that your model is a good model in general and not just a very good model for the specific data earlier used (Technically, this is called avoiding over fitting)

6. Implementation and tracking – The final model is chosen after the validation. Then you start implementing the model and tracking the results. You need to track results to see the performance of the model over time. In general, the accuracy of a model goes down over time. How much time will really depend on the variables – how dynamic or static they are, and the general environment – how static or dynamic that is.

Question 2.   What do you do in data exploration?

Data exploration is done to become familiar with the data. This step is especially important when dealing with new data. There are a number of things you will want to do in this step –

a.        What is there in the data – look at the list of all the variables in the data set. Understand the meaning of each variable using the data dictionary. Go back to the business for more information in case of any confusion.

b.        How much data is there – look at the volume of the data (how many records), look at the time frame of the data (last 3 months, last 6 months etc.)

c.         Quality of the data – how much missing information, quality of data in each variable. Are all fields usable? If a field has data for only 10% of the observations, then maybe that field is not usable etc.

d.        You will also identify some important variables and may do a deeper investigation of these. Like looking at averages, min and max values, maybe 10th and 90th percentile as well…

e.        You may also identify fields that you need to transform in the data prep stage.

Question 3: What do you do in data preparation?

In data preparation, you will prepare the data for the next stage i.e. the modelling stage. What you do here is influenced by the choice of technique you use in the next stage.

But some things are done in most cases – example identifying missing values and treating them, identifying outlier values (unusual values) and treating them, transforming variables, creating binary variables if required etc,

This is the stage where you will partition the data as well. i.e create training data (to do modelling) and validation (to do validation).

Question 4: How will you treat missing values?

The first step is to identify variables with missing values. Assess the extent of missing values. Is there a pattern in missing values? If yes, try and identify the pattern. It may lead to interesting insights.

If no pattern, then we can either ignore missing values (SAS will not use any observation with missing data) or impute the missing values.

Simple imputation – substitute with mean or median values

OR

Case wise imputation –for example, if we have missing values in the income field.

Question 5: How will you treat outlier values?

You can identify outliers using graphical analysis and univariate analysis. If there are only a few outliers, you can assess them individually. If there are many, you may want to substitute the outlier values with the 1stpercentile or the 99th percentile values.

If there is a lot of data, you may decide to ignore records with outliers.

Not all extreme values are outliers. Not all outliers are extreme values.

Question 6: How do you assess the results of a logistic regression analysis?

You can use different methods to assess how good a logistic model is.

a. Concordance – This tells you about the ability of the model to discriminate between the event happening and not happening.

b. Lift – It helps you assess how much better the model is compared to random selection.

c. Classification matrix – helps you look at the false positives and true negatives.

Some other general questions you will most likely be asked:

• What have you done to improve your data analytics knowledge in the past year?
• What are your career goals?
• Why do you want a career in data analytics?

If you are following our page on facebook we can assure you that you will know the answer to the last question atleast by now.  

Read More

All you need to know about Six Sigma

Most of the companies nowadays ask for 6 sigma certified people or atleast they demand that the candidates must have atleast prelimnary knowledge of six sigma. At Expertmasterji we have created a jist of what six sigma is and how it is used in the industry. Hope it helps you in your interviews. For more material on interviews please click here.

Question: - What is Six Sigma?
Answer: - Six Sigma (Six Standard Deviations from mean) is a methodology to enhance the efficiency and minimize the errors in any given process through some special tools & techniques.

It was applied for the first time in the manufacturing division of the Motorola Company, where this process was and infact has been rigorously used for minimizing the errors in the processes of producing several millions of different parts. However under Jack Welch Six Sigma was adopted by GE and its concerned companies and it was so rigorously used there that Six Sigma became more related with GE then with Motorola .Although Six Sigma was primarily designed to reduce errors in manufacturing domain with time however its application widened with the inclusion of non-manufacturing processes too. Today It has spread to such a level that its use can be witnessed in the fields as different as call centers, medical processes and insurance processes etc.

The impetus Six Sigma lays on quality can be gauged by the very fact that six sigma allows only 3.4 defects per million of transactions. It uses statistical techniques for reducing the error and measuring the quality of the final process or product.

Question: - What is the methodology used by Six Sigma? 

Answer: - Six Sigma helps in improving the process via constant revisions and alterations.Business process improvement is done in SIx sigma using the novel methodology called DMAIC (Define opportunities, Measure performance, Analyze opportunity, Improve performance, Control performance).

Besides process improvement Six Sigma can also be used for new product development(NPD), however for NPD it uses the process known as DFSS (Design for Six Sigma).

Some of the important elements for the improvement of process by Six Sigma are: continuous improvement, metrics & measures, customer requirements, employee involvement and design quality.

Question: - What is the meaning of Green Belt and Black belt in six sigma?

Answer: - 

Question: - What are the 3 core elements of Six Sigma ?

Answer: - The 3 core elements of Six Sigma are :-

i) Customer satisfaction:

ii)Defining processes & metrics and measures

iii) Involvement of employees and team building

The Six Sigma is very strict towards the customer satisfaction. Under the Six Sigma methodology, it is ensured that the satisfaction of the customers is never compromised with.

This element Of Six Sigma defines the usefulness and the understanding of data & systems as well as sets the goals for improvements.

Under Six Sigma, it is imperative to involve all the employees by the company and to provide the employees with proper incentives and opportunities. This way the employees can be motivated to do their work more sincerely. Besides, Six Sigma also ensures that each of the employees has a defined role in the company and there is no scope of ambiguity, at all.

Read More

Approach for behavioral interview - HR interviews

Before you approach any interview you should remember that the most potent way of cracking any behavioral interview is practice , but the question is what to practice and how to put your points in a framework such that your answer just flows out in front of the interviewer and that it seems as if the answer is prompt, however to make it sound so it is imperative that you do lots of practice. We interviewed a couple of students last week and formulated a framework which you can put to use and be successful in the next interview you attend.
The framework is simple : its a STAR

S - Situation: - Any situation or incident in your life which can explain the interviewers question
T- Task: - Any Situation which is similar to the task mentioned.
A- Action: - Course of action you opted to resolve the situation/task
R- Result: - Mention the results of your actions and the outcomes of the same, interviewer will highly appreciate if you can quantify the results and give him some figures which resulted out of your course of action.

Every answer you give to the interviewer should have these attributes and should address them in entirety. Follow this simple framework and prepare your answers based on the this framework for the questions written below.


Question : Tell me something about yourself ?

Answer :- This approach to this question should be a simple reverse chronological approach an example :

Sir I am xxx pursuing my marketing majors from yyyy institute of management. Prior to coming here I was working at zzz consulting helping pharma and healthcare industries to increase their customer footfall and increase their profitability via better customer segmentation. I have key interest in (something related to the job profile and a one liner for your achievement in that field) . Apart from that my hobbies are playing ping pong and chess(Achievements if any). I was born and brought up in Punjab and that's the place where I have spent most of my life. However I am open to travel anywhere, in fact I love traveling and public speaking I believe they help me in learning more about myself.


Question:- Why this particular industry?
Answer: - What ever may be the industry you are applying to, i strongly advise that you use the following keywords. Trust me it helps :
1. Variety in job.
2. Steep learning curve

The following questions are perfect for the STAR framework for an HR interview. Streamline your answer on the lines of star framework. Remember that for each attribute of this framework you should prepare a one liner ie a line for situation , a line for task, a line for Action and so on ..

Question: - Tell me of a time when you were a team player?
Question: - Tell me of a time when you persuaded a group?
Question: - Tell me of a recent crises you handled?
Question: -  Your biggest failure

There can be innumerable questions which can be answered using this framework.

Question: - What do you know about our company?
Answer :- The main intention behind asking this question is to know how serious you are for that company or for that job and whether or not you have done your homework. To answer this question you should know the promoters /founders of the company. Revenue and last year profits. It is advisable that you know about the domain which brings most revenues for the firm and which other fields is the company looking to foray into.
For this info it is advisable that you read atleat one of the whitepapers of the company. Read its last year's balanced sheet and if you can find out some insights the better carry it to the interview panel and present your findings by highlighting them.

Question: - Which other industries are you looking into?
Answer: - Look for the related or like- industries to answer this question. For instance if you are sitting for a bank you may answer : Other industries which excite me are Insurance and capital markets, although banking would be first priority but if not banking then ill try to get into these industries.

Question: - If you go back to your previous organisation what would be the changes you would bring to it?
Answer: - Talk in terms of improving the employee engagement and if you have insights about operation of that industry and its best practices than it would be fruitful to bring it out here.

Question: - Tell me something about your previous boss? What you like and what you dislike about him?
Answer: - The person who is taking your interview today may be your x-boss some day and so I would say that no matter how horrible your stay have been with your previous boss talk only about his positives and the impact he had on your career progression.

Last but not the least be cheerful while replying to the interviewers question, show some vitality and if possible subtle humor, everyone prefers having people with cheerful disposition in their team.

All the very best. Have a happy job hunting.

If you need any help then feel free to comment us below. We assure to write back to you in 24 hours.
Also if you have some material which may be useful for other fellas who are preparing for interview, please share it with us at expertmasterji@gmail.com

Read More

Razor Pay- New startup in the market

Soni, Flipkart's chief product officer, has made a personal investment in RazorPay, a payment gateway company designed for the Indian market. 

Soni confirmed his investment at a TiE conference in Santa Clara, California. He did not reply to email queries on the stake purchased and quantum of investment. 

The former Google executive is also an adviser and investor in two US-based companies: messaging app Snowball and mobile engagement platform Phigital, according to his LinkedIn profile. 

"(Soni's investment) happened through a lot of networking," said RazorPay CEO Shashank Kumar. 

RazorPay, a graduate of Silicon Valley-based accelerator YCombinator, raised $120,000 (Rs 76 lakh) in funds in December. The one-year-old company competes with payment gateways such as PayU and Zaakpay. 

The company is still raising funds for an angel round. Tikhon Bernstam, cofounder at US-based book membership service Scribd.com, has also invested in it. 

RazorPay's unique selling proposition is in being able to reduce hassles for merchants who want to sell their wares online. It allows them to upload their documents and automate the entire payments process. 

It allows consumers to complete payments in a single page, saving them from multiple redirects. It also allows merchants to start receiving payments in the existing account without the need for opening a new account. 

"Today, even if a student wants to open a website and sell goods, he will be able to," said Kumar. "Our target market is ecommerce and travel companies." 

Read More