Description
What is the aim of this course?During most consulting projects you will have to carry out some sort of market research. You will be analyzing the market size, competition, sales channels, and products. For strategic projects, due diligence, and business development projects, market research is a must and will be the basis for the whole project. Market research is time-consuming and requires combining different methods and sources. This is a must to get the full picture and advise the customer. In this course, I will teach how to perform fast and efficiently market research analyses during consulting projects. In the course, you will learn the following things: How to estimate the market size in ExcelHow to analyze the competitionHow to analyze the market structureHow to model the results of the research in ExcelHow to analyze data from consumersHow to analyze data from sales channelsWhere to find the information, you will needHow to use the jobs-to-be-done frameworkThis course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 190 000 students including people working in EY, McKinsey, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others. I teach through case studies, so you will have a lot of lectures showing examples of analyses, and tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, and materials shown in the lectures so as a part of this course you will also get a library of ready-made analyses that can, with certain modifications, be applied by you or your team in your work. Why have I decided to create this course?Most consulting projects especially those related to strategy will require you to research and analyze the market. To do that efficiently, you will have to master certain skills and tools as well as have a good understanding of what kind of sources of information you can use. Most firms don't give you the full toolbox that you need. This may lead to huge frustration during management consulting projects and a lot of inefficiencies. Therefore, I have decided to create this course that will help students understand or refresh the main skills and tools that they need to do market research during consulting projects. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during projects that will require conducting market research and analyzing market data. You will master how to analyze data and draw conclusions from the analyses using ExcelTo sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of market research and market analyses done during consulting projects. That is why I highly recommend this course to Management Consultants or Business Analysts, especially those that did not finish business school. The course will help you become an expert in market research and market analyses on the level of McKinsey, BCG, Bain, and other top consulting firms. In what way will you benefit from this course?The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve the speed with which you understand and analyze businesses. There is little theory - mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will learn: How to estimate the market size in ExcelHow to analyze the competitionHow to analyze the market structureHow to model the results of the research in ExcelHow to analyze data from consumersHow to analyze data from sales channelsWhere to find the information, you will needHow to use the jobs-to-be-done framework. You can also ask me any question either through the discussion field or by messaging me directly. How is the course organized?The course is divided currently into the following sections: Introduction. We begin with a little introduction to the course as well as some general info on how the course is organizedEstimating Market Size. The first thing you will do is estimate the size of the market. This will help you calculate the shares of competitors and observe trends in the market. In this section, we will see how this can be done. Jobs-to-be-done Framework. This framework is extremely useful for defining the market and the competitors. In this section, we will what it is and how it can be used in practice. Competitive Landscape. As a part of most market research, you will also have to analyze the competitors, understand their shares in the market, what drives profitability as well as what strategies they use. In this section, we will see how we can map and analyze the competitors. Market Structure Analyses. The next step is to understand the market structure and the consumer. This will also give us a deeper understanding of the difference between competitors. Sales Channel Analyses. If you are dealing with other than the retail, marketplace, or e-commerce business models you should analyze what kind of sales methods and channels are used. In this section, you will learn how to analyze the sales channels in Excel. Financial Modeling. Market research is usually followed by financial modeling. The aim is usually to see whether entering certain segments or increasing presence makes economic sense. In this section, you will learn how to create a simple financial model and check whether the business idea makes sense or not. You will be able also to download many additional resources1. Useful frameworks and techniques2. Analyses shown in the course3. Additional resources4. Links to additional presentations, articles, and movies5. Links to books worth readingAt the end of my course, students will learn: How to estimate the market size in ExcelHow to analyze the competitionHow to analyze the market structureHow to model the results of the research in ExcelHow to analyze data from consumersHow to analyze data from sales channelsWhere to find the information, you will needHow to use the jobs-to-be-done frameworkWho should take this course? Who should not?Management ConsultantsBusiness AnalystsManagersFinancial ControllersInvestment AnalystsStartup FoundersProject ManagersWhat will students need to know or do before starting this course?Basic or intermediate ExcelBasic knowledge of economicsBasic or intermediate knowledge of finance & accounting.
