Author: Akshay Kher

What to expect in an Analytics Interview?

Once I posted my first blog “How to Start a Career in Analytics for Free”, I was flooded with questions on how to prepare for analytics interviews. After giving a good amount of interviews in the last 6 months I could find a clear pattern in which they are conducted.

Although Analytics as a field has been present for a long time, people have recently started adopting it as a career. Hence, there is a lot of scattered information available on the net, relating to interview preparation, but no material complete in itself.

It is also impossible to prepare for each potential question, as Analytics is a vast field. However, the same questions can be bucketed into different categories and one can concentrate on specific categories depending on the work profile. Each company tests on these categories by holding different interview rounds which will also be covered subsequently.

Before jumping into categories of interview questions and different interview rounds, it is necessary to understand the flow of data analysis and associated designations.


flow data analysis

    1. Define your Questions: One must begin with the right question(s). Questions should be measurable, clear and concise. Design your questions to either qualify or disqualify potential solutions to your specific problem or opportunity.
    2. Decide on the Objectives: It is impossible to do sound analysis without knowing what you wish to achieve. Too often an analysis is started without a clear idea of where it is going. The result is usually a lot of wasted time and an inadequate analysis. Avoid this by deciding on the objectives of the analysis before starting it.
    3. Data Collection: The way you collect data should relate to how you’re planning to analyze and use it.Essentially, collecting data means, putting a design for collecting information into operation. You’ve decided how you’re going to get information – whether by direct observation, interviews, surveys, experiments and testing, or other methods – and now you want to implement your plan. Recording and organizing data may take different forms, depending on the kind of information you’re collecting.
    4. Data Cleaning: Improving data quality is an essential step in data analysis. It includes converting data into a structured format, handling missing data, feature engineering and weeding out futile information. Analyzing bad quality data will result in erroneous conclusions unless steps are taken to validate and clean it.
    5. Analysis: Analysis involves examining information in ways that reveal the relationships, patterns and trends in it. That may mean subjecting it to statistical operations that can tell you not only what kinds of relationships seem to exist among variables, but also to what level you can trust the answers you’re getting.  The point, in terms of your evaluation, is to get an accurate assessment in order to better understand your work and its effects on those you’re concerned with, or in order to better understand the overall situation.
    6. Data Modeling: This involves building models that correlate the data with the business outcomes and then make suitable recommendations. This is where the unique expertise of an analyst becomes critical to business success—correlating the data and building models that predict business outcomes. Such an analyst must have a strong background in statistics and machine learning to build scientifically accurate models and avoid the traps of meaningless correlations and models that are so reliant on existing data that their future predictions are useless. But statistical background is not enough; analysts need to understand the business well enough that they will be able to recognize whether the results of the mathematical models are meaningful and relevant.
    7. Optimize and Repeat: The flow of data analysis is a continuous and repeatable process. Each stage should be monitored and optimized accordingly for better results.


      • Data Architect:-
        Large enterprises generate huge amounts of data from various different sources. The Data Architect is someone who can understand all the sources of data and work out a plan for integrating, centralizing and maintaining all the data. He must be able to understand how the data relates to the current operations and the effects that any future process changes will have on the use of data in the organization. He needs to be able to have an end-to-end vision, and to see how a logical design will translate into one or more physical Databases, and how the Data will flow through the successive stages involved.
        This may include things like designing relational databases, developing strategies for data acquisitions, archive recovery, and implementation of a database, cleaning and maintaining the database by removing and deleting old data etc.
      • Data Engineer:-
        Data engineers are hard core engineers who know the internals of database softwares. He compiles and installs database systems, writes complex queries, scales it to multiple machines, ensures backups and puts disaster recovery systems in place. He usually has a deep knowledge and expertise in one or more different database softwares (SQL / NoSQL).
      • Data Analyst/Business Analyst:-
        The primary task of a data analyst/business analyst is compilation and analysis of numerical information. They usually have a computer science and business degree. They get analytical insights out of all the data which an organization can have (Database soft wares or just excel sheets) which makes sense for the organization and compile them into decent reports so that other non-technical folks can understand and decide their course of action.
        An analyst usually works to get analytical insights out of data and this job profile does not include working with statistics (usually) and has nothing to do with “Big Data” in particular.A decent mid-sized organization can have many analysts. For example – a sales analyst may look at total sales in the past quarter and figure out a proper sales strategy (where to sell and whom to sell to maximize profits). He will then communicate the report to the leadership.
      • Data Scientist:-
        “Data Scientist” is a very recent phenomenon. The overall mission of a scientist is same as an analyst but once the volume and velocity of data crosses a certain level, it requires really sophisticated skills to get those insights out.
        A “Data Scientist” usually has many overlapping skills – Database Engineering, handling Big Data systems, knowledge of statistical programming languages, business knowledge and knowledge of statistics / data mining.
        Whereas a traditional data analyst may look only at data from a single source a data scientist will most likely explore and examine data from multiple disparate sources. The data scientist will sift through all incoming data with the goal of discovering a previously hidden insight, which in turn can solve a business problem. Good data scientists will not just address business problems, they will pick the right problems that have the most value to the organization.
      • Business Intelligence Engineer:
        These are the people who consume historical data from transactional databases, denormalize it, write huge gigantic SQL/Hive queries to flatten, reshape and aggregate the data, do some basic statistical analysis and then build fancy data visualizations using tools/programming to present/communicate the data effectively. The dashboards they build are often used by senior management and VPs. These people are not the strongest technical people, but they are jack of all trades and can fill in anyone’s shoes whenever required. This is also a very cross-functional role as you work with data engineers to get the data, data scientists to get statistical analysis done and with business analysts/managers to present the insights.
      • The above mentioned designations are loosely defined in the analytics industry. Hence it is best to look at work profiles rather than designations as they can often be misleading.
      • Now that we have covered the flow of data analysis and associated designations, we can move towards the categories of interview questions and different interview rounds.


      1. Basic Overview of Analytics Field: One should have a broad picture about what the analytics industry is all about. A knowledgeable candidate will always have an upper hand.
      2. Basic Domain Knowledge: Analytics can help solve problems for various industries like e-commerce, retail, banking, telecom, pharmaceutical, BFSI etc. If the role offered is industry specific, then it’s always a plus to have a basic domain knowledge.
      3. Communication and Presentation Skills: This is one of the most important skills. No matter how strong your other skills are, a company will not compromise on effective communication and presentation skills (both verbal and written) i.e. a candidate lacking such skills will rarely make it through.
      4. Energy and Passion: The first question of any one-to-one interview will always be “tell me about yourself and how you landed here?” Skills can be taught but passion sure cannot, a passionate candidate leaves a wonderful first impression. Matching this passion with energy reflects confidence of the candidate and becomes an instant hit with the interviewer.
      5. Logical Thinking: Logical thinking is the process in which one uses reasoning consistently to come to a conclusion. Problems or situations that involve logical thinking call for structure, relationships between facts and chains of reasoning that “make sense.
        ”Companies evaluate logical thinking on “• points” by the help of “-> points”:-
      • Structural Approach
      • Problem Solving Skills
      • Attention to Details
      • Ability to Handle Pressure
        -> Aptitude Test
        -> Puzzles
        -> Case-Studies
        -> Guess Estimates
      1. Basic Statistics: Statistics is the study of the collection, analysis, interpretation, presentation, and organization of data.
        Generally our knowledge of statistics is limited to what we learnt in high-school. Hence, it is important to brush up and learn more advanced concepts which can be done using innumerable free resources available online.
      2. Basic Mathematics: Mathematics is the science of numbers and their operations, interrelations, combinations, generalizations, abstractions of space configurations and their structure, measurement, transformations, and generalizations.
        If you’re mathematical skills are rusty, it is advisable to revisit the high school mathematics curriculum which in my opinion is quite comprehensive.
      3. Machine Learning: In general, machine learning is about learning to do better in future based on what was experienced in the past. The emphasis of machine learning is on automatic methods. In other words, the goal is to devise learning algorithms that do the learning automatically without human intervention or assistance.
        For example, Facebook’s News Feed changes according to the user’s personal interactions with other users. If a user frequently tags a friend in photos, writes on hiswall or “likes” his links, the News Feed will show more of that friend’s activity in the user’s News Feed due to presumed closeness.
        Machine Learning is considered an advanced skill and definitely a must in highly technical roles.
        Other examples of machine learning problems include face detection, spam filtering, medical diagnosis, customer segmentation, fraud detection and weather prediction.
      4. Databases & Big Data Concepts: A database is a structured set of data held in a computer, especially one that is accessible in various ways whereas Big data is a buzzword used to describe a massive volume of both structured and unstructured data that is so large that it is difficult to process using traditional database and software
        It is important to understand how data was traditionally stored and retrieved from databases and update oneself on how to handle such data, now that it has increased in volume exponentially.
      5. Basic Programming: In the most basic sense, programming means creating a set of instructions for completing some specific task.
        All programming languages are built on (more or less) the same basis. You can be asked to perform simple operation/algorithms using any programming language (of your choice) to check your basic programming skills.
      6. Statistical Tools: There are tools that help you in statistical analysis.
        This is a must skill to have and the most popular statistical tools in the market today are R, SAS and Python.
      7. Data Visualization: Data visualization is a general term that describes any effort to help people understand the significance of data by placing it in a visual context. Patterns, trends and correlations that might go undetected in text-based data can be exposed and recognized easier with data visualization
        In my opinion, this is not a necessary skill as it can be easily acquired but it definitely gives you an edge over other candidates.
      8. Related Projects/Competitions: The best way to check skills (both technical and non-technical) of a candidate is by asking him to explain his related projects/competitions.
        Hence it is very important to do a lot of projects and also participate in competitions (Kaggle, Data-Hackathons etc.) which display your ability to practically apply your skills. A candidate will never be selected just on the basis of his theoretical knowledge.
      9. Resume: I cannot stress enough on the fact that this is probably the most vital and often neglected (from the candidate’s side) part of the interview process. This is a powerful document that summarizes your entire professional life in at most a couple of pages.
        I have been in interviews where all the technical questions were asked only from my resume and if we think about it, this should not sound strange. One is called for an interview on the basis of their resume (as the company finds your mentioned work profile, skills and projects appealing). Hence many a times they limit their questions to the points mentioned in your resume only.
      • Preparation for freshers vs experienced candidates:-
      1. Freshers are generally tested more on their non-technical skills and taught technical skills on board, though knowledge of technical skills do provide them an edge. (Some companies also test freshers on knowledge of their respective undergraduate discipline)
      2. Experienced candidates (having no technical skills) wanting to shift their career into analytics should also concentrate on non-technical skills and compete against freshers for entry level positions.
      3. Experienced candidates (having technical skills) but no related work experience should concentrate on both non-technical and technical skills when applying for desired work profiles.
      4. Experienced candidates (having technical skills) with related work experience should concentrate more on technical skills when applying for desired work profiles.
      • It is important to understand the work profile when applying for a certain designation. Preparation should then be work profile specific and not designation specific.


      1. Aptitude: This round checks for quantitative, verbal and problem solving skills. This is not used to identify suitable candidates but rather remove the unsuitable ones.
      2. Group Discussion: In short, group discussions tests if you know the topic well, are able to present your point of view in a logical manner, are interested in understanding what others feel about the same subject and are able to conduct yourself with grace in a group situation.
        This (like the aptitude round) also acts as an elimination round.
      3. Personality Fit: Despite having apt skills, selection of a candidate might boil down to whether he will fit the company’s corporate culture or not.
        It is best to research about the company, its core values and processes beforehand.
      4. Logical: This round involves testing on puzzles, case-studies and guess estimates as discussed in “Categories of Interview Questions (Non-Technical)”
      5. Technical: This round involves testing on technical skills as discussed in “Categories of Interview Questions (Technical)”
      6. Coding: A coding round is used to assess ones basic programming skills.
      7. Resume Based: As discussed earlier, resume is a vital part of the interview process. A candidate should be thorough with each and every line written in their resume.
      • Different companies have different “categories of interview questions” and different “interview rounds”. This blog, to my knowledge, covers each and every type of the same.


      • People willing to start a career in analytics can read my first blog “how to start a career in analytics for free”
      • Both blogs are aimed towards freshers or professionals in early stages of their careers.
      • Both blogs are applicable for all types of organizations (small, mid-sized or large corporations)


As some of you would already know, I started from scratch a little more than a year ago. There are a lot of free (high quality) resources available online to kick start your career in analytics.
Currently, there is a huge demand for people with the right skills in the analytics industry and companies, for a change, are running after such candidates. You are not only in a position to choose between companies but also dictate your own salary. If one concentrates on acquiring the right skills then I am sure everything will fall into place.
As per me, after weighing my options, I have decided to move into “” next month as a Junior Data Scientist.


If you like this post then do share your questions, comments or add suggestions (You will only need to enter your email address and name).
You also have an option of sharing this blog via Twitter, Facebook or Google+


How to Start a Career in Analytics for Free?

Introduction Word Cloud

What & Why Analytics?

Analytics is defined as the scientific process of transforming data into insight for making better decisions. It helps improve processes, saves cost and enhances revenue.

Although analytics has been around for a long while, it wasn’t until the last 5 to 10 years that its importance in the business field has been realized. It was in the last 10 years that technology has been revolutionized and we now produce about 2.5 Quintilian bytes of data every day. What has also changed in the last decade is that we now have the means to sift through these 2.5 Quintilian bytes of data in a reasonable amount of time, with little cost to store it.

  • 90% of the world’s data has been generated in the last 2 years. The same data is predicted to double every 18 months from now on
  • In 1990, cost of storing 1GB data = $9000 (cost of a car)
    In 2010, cost of storing 1GB data = 8 cents (cost of a lollipop)

In organizations, analytics enables professionals to convert extensive data and statistical and quantitative analysis into powerful insights that can drive efficient decisions. Therefore with analytics organizations can now base their decisions and strategies on data rather than on gut feelings. Thus with powerful insights, analytics promises reduced costs and increased profits.

  • The analytics Industry is one of the fastest growing in modern times, poised to become a $50 billion market by 2017.
  • With this sudden surge in the analytics industry there is a tremendous increase in the demand for analytics expertise across all domains, throughout all major organizations across the globe.
  • It has been predicted that by 2018, the United States alone could face a shortage of 140,000 to 190,000 people with deep analytical skills as well as 1.5 million managers and analysts with the know-how to use the analysis of big data to make effective decisions.

Who Can Get Into Analytics?

There is no dedicated undergraduate degree for analytics as it is combination of various fields. Hence, no degree in itself can guarantee a career in analytics. However, Engineering or Statistics/Maths degrees are preferred but not necessary.

Pros:   Almost any undergraduate can apply
Cons: Tough Competition due to high number of applicants

Data Scientist
*Note: Designations like data scientist, business analyst, data analyst and consultant are used interchangeably by different organizations.

How to Prepare for a Job in Analytics?

Scenario 1 : On-Campus Jobs

Selection of applicants in this case is less technical and more focused on the following skills:-

  • Structured Thinking
  • Attention to Details
  • Numerical Skills
  • Problem Solving Capabilities
  • Communication Skills
  • Knowledge of Undergrad Discipline

Interview Process is as follows:-

  • Round 1 – Aptitude Test
  • Round 2 – Group Discussion/Video Synthesis
  • Round 3 – Technical (Puzzles, Guess-Estimates, Case Studies, Undergrad Questions)
  • Round 4 – HR

If you are from a tier-1 institute then there are a good number of companies offering analytics related roles like data scientist, business analyst, data analyst, consultant and so on. Interview preparation (as mentioned above) is pretty standard and abundant information/resources can be found on the web.

However, for tier-2 and tier-3 institutes very few and sometimes no company offers such roles. The only reason is that the number of applicants is so high that they need to filter out candidates.

Scenario 2 : Off-Campus Jobs or Shifting Jobs Early in your Career

My story falls under this category so I would want to describe how I went about things. I only intend to share an approach that worked well for me:-
  • I have done engineering from tier-2 institute and very few companies offered analytics related roles on campus. Not that I was too concerned with placements, not until the companies actually started pouring in.
  • After initial carefree years, every final year student has to decide what he/she really wants from life. I was no different, confused as to what I really wanted to do. I did give GRE (getting a good score) but soon dropped the idea of pursuing MS as I had no inclination towards a particular subject. I dropped the idea of giving the MBA/MTech entrances as well.
  • I sat for Accenture and got placed as an Associate Software Engineer. As the job situation in the market was pretty tight, once placed, we were not allowed to sit for other companies coming on campus. I applied for other companies off campus but could not even manage to get interview calls from most of them. With thousands of people applying for the same position, I was in no way better than them.
  • So on 26th August, 2014 I started working in Accenture. I liked my work but this is not what I wanted to do for the rest of my life, neither did I want to pursue Post Graduation without an aim in mind. I did not want to get into a trap just to run away from one.
  • Two months after joining I started reading about analytics on the net. I started reading blogs, watching videos on YouTube and going through work profiles of people in it. The more I read about it, the more it fascinated me.

Is this something that I like?  Yes

Is this what I really want?  Don’t know

Is this something that I would be good at?  Can’t say

Should I start applying to other companies?  Considering the above, don’t think so

Should I introspect and apply after a few months?  Yes, seems like a good option

  • Around this time I was first introduced to the concept of Massive Open Online Courses (MOOC). It is a course of study made available over the Internet without charge to a very large number of people. So I had the access to analytics courses offered by world’s best universities for free. It was as if I had struck gold. I could work on these courses after office hours and during weekends without compromising on my job work. For the next 8 months I not only completed these certification courses but also participated in online competitions, became part of professional communities and read various blogs/articles.

 MOOC that I had completed:-

  12. Classroom/Virtual Training’s in Accenture

Competitions that I had participated in:-


Blogs that I followed:-


Communities that I am part of:-


What happened after I finished my preparation:-

I started applying to companies for roles like data scientist/analyst/statistical modeler and so on (It’s the work profile that matters and not the designation as designations can be misleading). I got calls from many companies and in almost every interview I did well.

I had developed the industry knowledge by reading blogs/articles and being part of professional communities, technical knowledge by doing MOOCs, hands on experience by completing MOOC assignments/projects and online competitions and most importantly developed the confidence that I was the right candidate.  It’s amazing what you can do in an interview when you’re confident about yourself.

Ultimately I had a few offers to choose from.  I chose to shift into Accenture Analytics after a round of interviews.

Accenture Analytics

Summarizing on “How to Prepare for a Job in Analytics”:-

  • Interview Process – Every company has its own interview process as I had described earlier. Some are rigorous and some can be cracked more easily. Prepare for them in advance.
  • Internships – There are analytics companies willing to hire you as an intern. Not only will you learn a lot but it reflects well on your resume.
  • MOOC – It provides you with wealth of knowledge and hands on experience. Do not complete it for the certifications. I was never asked to show even a single certificate for over a dozen of interviews. If you can convey what you learnt from such courses, it’s more than enough.
  • Projects/Competitions – It’s best when you can show your work in form of a project or some competition. Its gives credibility to your knowledge and skills. Create a Github account and put all your work there.
  • Professional Communities –When you’re part of professional communities you meet loads of people having similar interest and you get to learn a lot. I have mentioned a few of the communities that you can join.
  • Reading Blogs and Articles – It widens your horizon. As it is a gradual process, its best to read simultaneously with your preparation.
  • Resume – Having a cracker of a resume helps you get the crucial interview calls. Give your resume time and consideration before applying.


If you really want to start a career in analytics you can do so for free. All you need to give is time and dedication to it and utilize the resources that are available to you, I can speak so from my personal experience. I fly to Mumbai next week moving into Accenture Analytics. All I hope is this post will help many like me, who just need a little push to get them on their way.

Do share your questions, comments and add suggestions to this post. (You will only need to enter your email and name)