Chapter 5 – 100 Solved Case Studies and Guesstimate

Topic – Solved Case Studies and Guesstimate
Welcome to the 2200 questions series from The Data Monk, in this series we will cover all the topics in a Question-Answer mode that are required for anyone who wants to make a career in the following field:-

– Data Analysis
– Business Analysis
– Business Intelligence Engineering
– Machine Learning
– Data Science
– Product Analysis
– Data Engineering
– Risk Analysis

These 2200 questions are useful for anyone who is in their 2nd-3rd year of engineering to 8-10 years of experience in the IT industry( be it QA/Development/Support) and are willing to make a career in Analytics.
Solved Case Studies and Guesstimate

Why Analytics is a domain for you?

If you want to make a handsome switch with a good package then Analytics is for you because of the following reasons:-

– It is a high-paying job
– It is interesting as you will have a good impact on the growth of the organization
– It involves a lot of things like requirement gathering, building logic, making ETL, pipeline creation, reporting to the CXOs, and so on. So, it is a very impactful role
– It has a HUGE demand in the future as the data will keep on growing and so will your role

How much does an analytics role pay?

The CTC of the role will definitely depend on multiple factors but just to give you a glimpse of it:-

“Anyone from a tier 2-3 college with good knowledge of the material that we are providing will have a fair chance to bag something like 15+ LPA for a fresher. The more you grind the better you get and the CTC grows with experience.”

Now coming back to why you should try The Data Monk for your Analytics journey.

Why The Data Monk?

We are a group of 30+ Analytics Engineers working in various product-based companies like Zomato, Ola, OYO, Google, Rapido, Uber, Ugam, BYJUs, etc. and we observed that people do not have a well-structured way to enhance their knowledge. There are multiple courses here and there, but no one has consolidated what needs to be learned in order to move to the analytics domain.

Further, there are courses from Large institutes where they charge you something like 2-5 lacks and try to teach you everything from Data structure to SQL to Power BI to ML. You do not have to spend so much on these topics.

We followed a very old-school way, take a topic and solve 100-200 questions on these topics. Learn them, understand them, and revise them. This should be enough for you to crack that domain.

For example, if I am a very beginner in SQL, then I will just try to solve 200 questions starting from the definition to advance level questions. After solving and revising these questions I should have a good amount of knowledge to answer 6 out of 10 questions asked in an interview and going by that calculation I can be a strong candidate in 5-7 out of 10 companies.

See, by the end, you need to convert a job first and then keep on learning in the organization.

Most of the books are on questions like ‘250 questions to crack SQL interview’ and this will cost you around 250 rupees, take the book, understand, and learn it. This small amount can bag you a 15 LPA job 🙂

You can trust us as we have guided more than 1000 people to make a career in Analytics

2200 Analytics Interview Questions

Coming back to the topic, below is the list of 250 SQL questions to Ace any Analytics Interview
Chapter 1 – SQL – 250 SQL questions to Ace any Analytics Interview
Chapter 2 – Python – 200 Most Asked Python Interview Questions
Chapter 3 – Pandas – 100 Most Asked Pandas Interview Questions with solution
Chapter 4 – Numpy – 100 Most Asked Numpy Interview Questions with solution
Chapter 5 – Case Study and Guesstimate – 100 Case Study and Guesstimate with a complete solution

653.What are the metrics to evaluate a website? A search engine?

654. Punjabi By Nature is going through a rough phase and is wasting 30-40 Kgs of biryani on some days of the week.

Management is thinking to find a method to sell the left over biryani or reduce the amount of biryani prepared.

You are the manager and you are supposed to come up with a methodology for the same

655. TVF recently went to app/website only mode. How do you think it makes money to survive and pay the actors ?

656. How to increase the marketing of online games?

657. Given a set of webpages and changes on the website, how will you test the new website feature to determine if the change works positively?

658. What is root cause analysis? How to identify a cause vs. a correlation? Give examples.

659. Can you choose a strategy for increasing the number of songs listened by the user on an online application? How will you decide the types of playlists to suggest him?

660. How would you measure the success of acquiring new users through a 30-day free trial at Netflix?

661. How would you measure the success of Facebook Groups?

662. Describe how you would build a model to predict Uber ETAs after a rider requests a ride.

Common machine learning case study problems like this are designed to explain how you would build a model. Many times this can be scoped down to specific parts of the model building process. Examining the example above, we could break it up into:

How would you evaluate the predictions of an Uber ETA model?

OR

What features would you use to predict the Uber ETA for ride requests?

663. You’re a Data Scientist / Business Analyst working for a new eCommerce company called A&B Co. (similar to Amazon) and you’ve been asked to prepare a presentation for the Vice President of Sales and the Vice President of Operations that summarizes sales and operations thus far. The summary should include (at a minimum) a summary of current state the business, current customer satisfaction, and a proposal of 2-3 areas where the company can improve. Here are some facts:

It’s currently September 2018 (e.g., you can ignore all data after September 2018)

The company’s inception was January 2017 (so you can ignore all data before January 2017)

Company is US-based, but launched in Brazil (which is why some information is in Portuguese)

You can assume all orders are delivered (so ignore the order state field)

Your presentation should not have more than 10 slides of content, and the presentation itself should only take ~15 minutes.

664. Profit of a company selling mobile back cover is declining. List out all the possible reasons

665. How would you construct a feed to show relevant content for a site that involves user interactions with items?

666. How would you design the people you may know feature on LinkedIn or Facebook?

667. How would you predict who someone may want to send a Snapchat or Gmail to?

668. How would you suggest to a franchise where to open a new store?

669. In a search engine, given partial data on what the user has typed, how would you predict the user’s eventual search query?

670. Given a database of all previous alumni donations to your university, how would you predict which recent alumni are most likely to donate?

671. You’re Uber and you want to design a heat map to recommend to drivers where to wait for a passenger. How would you approach this?

672. How will you change the UI of the game to increase the number of people buying coins from the shop section (Clash Of Clans)?

673. Taj Group of Hotels is planning to start a new branch, What are the parameters it should consider to find the appropriate place?

674. List the e-commerce metrics

675. The case study was to increase the number of conversions of freemium customers to premium customers for a telecom company in India.

676. Flipkart has recently observed that people are falling out of it’s buy funnel i.e. a list of pages following which a customer makes a payment.

The pages are – Listing page, Description Page, Delivery option page, Payment Page and Redirection page.

How would you identify the problem faced by the customers

677. For a particular e-commerce company, there has been a decline in the number and value of items stored in the cart. Tell all the possible reasons for this decline?

678. KFC wants to open its first branch in India, what data points should be considered before it entering in a new market?

679. For a particular e-commerce business the number of supplier and user both have grown by 5% week over week, but the revenue has declined by 5 %, what could be the reason?

680. What are the factors to consider if you work in the sales department of Samsung and you want to start a store in one of the most crowded malls of Bangalore?

Think through all the points like

-Foot fall

-Customers

-Supply and demand issue (connect with warehouse)

-Break even point of profit

-Exit points if things fail

680. Customer Obsession

681. Invent and Simplify

682. Are Right, A lot

683. Hire and Develop the Best

684. Think Big

685. Frugality

686. Earn Trust

687. Deliver Results

688. What are the KPIs for Nykaa?

689. What  are the KPIs for Zomato?

690. What are the KPIs for Uber and Ola?

691. What are the KPIs of Amazon or e-commerece company?

692. What are the KPIs of Google?

693. What are the KPIs for Apple?

694. What are the KPIs of Tesla?

695. What are the KPIs for Walmart?

696. What are the KPIs for Microsoft?

697. What are the KPIs for iTC?

698. What are the KPIs of Pfizer?

699. How would you go about designing a recommendation system for an e-commerce website, and what data sources and algorithms would you consider?

700. Imagine you’ve been given a dataset on customer churn in a telecom company. What kind of analysis would you conduct to identify the key factors that contribute to customer churn, and what recommendations would you make to reduce it?

701. Suppose you’re working on a project to improve customer engagement for a mobile app. What metrics would you use to measure engagement, and what techniques would you employ to increase it?

702. You’re tasked with building a fraud detection system for a bank. What features and data sources would you consider, and what models and techniques would you use to identify fraudulent activity?

703. How would you go about developing a predictive maintenance system for a fleet of trucks, and what data sources and algorithms would you use to anticipate maintenance needs?

704. You’ve been asked to build a chatbot for a customer service team. What kind of data would you need to train the chatbot, and what technologies and techniques would you use to ensure it provides accurate and helpful responses?

705. You’re working on a project to optimize the pricing strategy for a ridesharing company. What data sources would you use to inform your analysis, and what techniques would you employ to set optimal prices in real time?

706. You have been given a dataset containing millions of online transactions for an e-commerce platform. How would you analyze the data to identify customer behavior patterns and preferences, and what insights would you extract to optimize the platform’s user experience and increase sales?

707. You are working on a project to build a recommendation engine for a streaming media platform. How would you design and implement the recommendation engine, and what algorithms and data sources would you use to provide personalized recommendations to users?

708. You are tasked with developing a predictive model for a healthcare provider to identify patients who are at risk of developing chronic conditions. What data sources and features would you use to train the model, and what algorithms and techniques would you employ to improve the accuracy of the predictions and inform targeted interventions?

709. You are working on a project to optimize a supply chain for a consumer goods company. What data sources and analytics tools would you use to identify bottlenecks and inefficiencies in the supply chain, and what recommendations would you make to improve performance and reduce costs?

710. You have been given a large dataset of sensor data from a fleet of industrial equipment. How would you analyze the data to identify patterns of performance and maintenance needs, and what techniques and models would you use to inform a predictive maintenance strategy?
711. You are tasked with developing a fraud detection system for a financial services company. What features and data sources would you use to train the model, and what algorithms and techniques would you employ to improve the accuracy of fraud identification and reduce false positives?

712. You are working on a project to optimize marketing spend for a consumer packaged goods company. What data sources and analytics tools would you use to inform decisions around channel allocation, audience targeting, and ad creative, and how would you measure the impact of the marketing campaigns on sales and customer engagement?

713. You have been given a dataset of social media activity for a large retailer. How would you analyze the data to identify trends and sentiment among customers, and what recommendations would you make to improve the retailer’s social media presence and customer engagement?

714. You work for an e-commerce company that sells a variety of products online. The company has a website, mobile app, and social media accounts, and it uses various online marketing channels to drive traffic to its website and app. The company has been experiencing declining sales over the past few months and has brought you in to help identify the problem and recommend solutions.

Question:

How would you use digital analytics to help the e-commerce company identify the problem and recommend solutions to increase sales?

715. KPIs for Telecommunication companies

716. KPIs for Human Resource department

717. KPIs for Data Platform of any Technology company

718. KPIs for Finance Department

719. KPIs for Marketing Department

720. KPIs for Pharmaceutical client

721. KPIs for Insurance client

722. KPIs for Football Match

723. KPIs for a Chess Match

725. KPIs for Mobile Game

726. KPIs for Electric Vehicle

727. KPIs for stores

728. How OTT platform earns money?

729. KPI for Meesho

730.Number of Maggi sold in a day in India

731. How many t-shirts e-commerce companies selling in India per day?

732. What is the number of laptops sold in Bangalore on an average routine day?

733. What are the number of smart phones sold in India per year?

734. What is the total number of people who get a new job in India in a year?

735. How many red colored Swift cars are there in Delhi?

736. How many paan shops are there in India?

737. What is the maximum number of human beings that can survive on the earth?

738. How to calculate the number of taxis operating in Mumbai per day?

739. How to calculate the number of weddings in India per year?

740. How many KGs of paint are used in the USA annually?

741. How many street lights are there in India?

742.  How many cups of tea were consumed in Mumbai last month?

743. How many iPhones are currently being used in India?

744. What is the size of the laptop market in the USA?

745. What number of tennis balls can fit inside a room?

746. How many cups of tea were consumed in Delhi in a month?

747. How much paint will be required for painting a 20 m x 20 m wall?

748. How many refrigerators are sold in India every year?

749. How many cups of coffee do Americans drink in New York City per month?

The Data Monk Product and Services

1. Youtube Channel covering all the interview-related important topics in SQL, Python, MS Excel, Machine Learning Algorithm, Statistics, and Direct Interview Questions
   Link – The Data Monk Youtube Channel
   
2. Website – ~2000 completed solved Interview questions in SQL, Python, ML, and Case Study
   Link – The Data Monk website
   
3. E-book shop – We have 70+ e-books available on our website and 3 bundles covering 2000+ solved interview questions
   Link – The Data E-shop Page
   
4. Mock Interviews
   Book a slot on Top Mate
   
5. Career Guidance/Mentorship
   Book a slot on Top Mate
   
6. Resume-making and review
   Book a slot on Top Mate 

The Data Monk e-book Bundle 

1.For Fresher to 7 Years of Experience

2000+ interview questions on 12 ML Algorithm,AWS, PCA, Data Preprocessing, Python, Numpy, Pandas, and 100s of case studies

2. For Fresher to 1-3 Years of Experience

Crack any analytics or data science interview with our 1400+ interview questions which focus on multiple domains i.e. SQL, R, Python, Machine Learning, Statistics, and Visualization
 

3.For 2-5 Years of Experience

1200+ Interview Questions on all the important Machine Learning algorithms (including complete Python code) Ada Boost, CNN, ANN, Forecasting (ARIMA, SARIMA, ARIMAX), Clustering, LSTM, SVM, Linear Regression, Logistic Regression, Sentiment Analysis, NLP, K-M