Link to this course(special discount)
https://www.udemy.com/course/business-analysis-cases-in-excel/?ranMID=39197&ranEAID=Gw%2FETjJoU9M&ranSiteID=Gw_ETjJoU9M-uBguGkYhDH5V.j8uACq6_Q&LSNPUBID=Gw%2FETjJoU9M&utm_source=aff-campaign&utm_medium=udemyads
How to become world class Business Analyst – Cases in Excel – learn Business Analysis
What you will learn in this course ?
What you’ll learnKill any discussion with solid data analysesDo the analyses 10x fasterStructure complex problems and solve them in ExcelPerform the analyses in a very effective mannerUnderstand the main challenges in analyzing different aspects in sales, marketing and operationsBuild business models for e-commerce, service companies and B2C servicesYou will get ready made examples of complex analyses from top-notch consulting companiesYou will learn what kind of analyses can be performed during a management consulting project
What is the aim of this course?This course will help you drastically improve your knowledge and skills in business analysis through a series of practical cases. It is designed for people who want to become business analyst or do a lot of business analyses at their work. It is based on my 14 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement and turn-arounds in biggest companies from FMCG, SMG, B2B sector that I worked for. On the basis of what you will find in this course I have trained over 100 business analysts who now are Investment Directors, Senior Analyst, Directors in Consulting Companies, Board Members etc. On top of that my courses on Udemy were already taken by more than 51 000 students including people working in EY, Walmart, Booz Allen Hamilton, Alvarez & Marsal, PwC, Dell, Walgreens and many others.I teach through cases so most of the lectures will be a case study showing some business problem solved in Excel. To every lecture you will find attached (in additional resources) the Excel shown the specific business analysis shown in the Lecture. Thanks to this as a part of this course you will also get a library of ready-made business analyses that can, with certain modification, be applied by you in your work. Every business analysis show in this lecture is easy to edit and adjust to your need. The analysis are taken from real life management consulting projects
Why I decided to create this course?The companies I have worked with so far as a Board Member (I am usually, Chief Restructuring Officer VP responsible for Strategy and Development) still have huge problem with proper analyzing intermediate and advance issues – they are usually preoccupied by current activities and have close to no time for business analysis and strategic decision. Moreover, they do not know how to approach many subject from the analytical point of view to make sure that they are taking the right decision. Therefore, quite often they hire consultants who in turn lack the practical knowledge and experience. This course is my small contribution to improving both consulting as well operational and strategic analyses in FMC, SMCG, B2B companies including also on-line models like e-commerce, SaaS, marketplaces.
In what way will you benefit from this course?The course is a practical, step by step guide loaded with tones of analyses, tricks, hints that will significantly improve the speed with which you do the business analyses as well as the quality of the conclusions coming out of available in your company data. Every business analysis is well described and presented in a form of Excel, attachted to the lecture. 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 know:How to analyze different aspect of sales, marketing, operations?How to draw conclusions from those analyses – both for current operations as well ase strategic ones?How to be efficient in your work as analyst? How to build Excels and Power Points so that it is understandable for you and your team, even after some time?Chose the right business analysis to identify problems and opportunitiesYou can also ask me any question either through the discussion mode or by messaging me directly.
How the course is organized?The course is divided currently in 5 sections and will be adding new section to address other important issues. Currently you will find the following sections:Introduction. We begin with little intro into the course as well as some general info on the role of business analyst – what skills, education, knowledge is required from you and what are the available career paths for youTools. In the second section we briefly go through main tools and concepts for business analysts. We devote some time to the most popular ones: Excel an Power PointBusiness modelling – example of analyses. On some occasion you analyz
source
