
Step into a career in politics by becoming the new aide to the senior senator, sign in with the secretary, and enter the busy office for a five-minute welcome.
Assess an island quarantine concept for Z 20, guided by a 96% accurate test and infection data, and evaluate Tri Pharmaceuticals' role in a data-driven recommendation.
Capture the main points from meetings and shape statements into themes that guide your work, then review the first module as needed and compare notes with the sample solution.
Learn to structure complex projects using the scqs tool, organizing notes into situation, complication, target question, and scope to align stakeholders and focus project outcomes.
Demonstrates applying Alvis's bulletproof structure and the five BP's rules to sharpen problem solving in strategy consulting and structure a project approach.
Explore building a driver tree for Z 20 infections by comparing a baseline scenario with quarantine island interventions, outlining level-1 drivers and progressing to level-two hypotheses through targeted research.
Apply insights from Tom's research to refine the driver tree and develop level two drivers, strengthening your approach to structuring and solving strategic problems.
Builds on your driver tree to clarify the target of your analysis and map a rough path, then launches the analysis as you check an email from Julie.
Evaluate the quarantine proposal using Julie's email and the new infections formula. Use the driver tree with infections constant 0.3 and spread coefficient 1.0 to deliver a data-driven recommendation.
Master Microsoft Excel basics by distinguishing hardcoded versus calculated cells, building simple revenue models, and formatting inputs and formulas to prevent errors.
Calibrate a quantitative analysis model in Excel following a driver tree structure to compare infection outcomes between doing nothing and quarantining, using input, throughput, and output worksheets.
Use input sheet to model Z 20 spread with infection constant 0.3, spread coefficient 1.8, starting infection rate 2%, population 320 million, test accuracy 96 percent, and linear antidote availability.
Construct the throughput sheets using the three-level driver tree to quantify total population, infection rate, and the infected and uninfected counts for the do nothing and other scenarios.
Apply the island quarantine scenario by copying cells on the second throughput sheet, populate light gray cells, and compute populations for mainland and quarantined island groups; compare with sample solution.
Open the last Excel file and navigate to the output sheet. Fill the grey cells, avoid hard coded entries, and compare results to the sample solution.
Explore quarantine sub-scenarios—single testing, increased accuracy, and double testing—and adapt the existing Excel model to compare outcomes, consult Julie for feasibility.
Make two copies of the last downloaded Excel files, rename one to increased accuracy sub scenario and the other to double testing sub scenario, adjust both models, and compare results.
Set up adjusted Excel model to analyze a fast track approval scenario, using Julie's assumption that antidote availability grows linearly from 10% at year 1 to 100% at year 7.
Cutting bureaucratic red tape reduces infections from 2.9 million to 2 million, a 30 percent decrease, and demonstrates the value of fast-track approval.
Learn to turn analysis into a final presentation that makes insights heard and acted upon, from an empty PowerPoint to a professional deck for the Z 20 case.
Adopt a top-down approach to creating presentations and craft a stringent, convincing story that flows through the document. Learn how five principles guide the Z20 presentation, as Tom demonstrates.
Begin storylining with an audience assessment by stepping into the senator's shoes and asking what he knows, his view, and what he would want to know and for which concerns.
Clarify your stance on where the senator stands, then transition into content creation mode. Decide which slide you should always create first.
Before you move on, we'd like you to download & install two elements. This will allow you to follow the course exercises most effectively.
Transform the first slide into a title slide, insert a text slide for the executive summary, and structure its content in four parts: context, questions, answers, next steps.
Frame the context of z 20, a fast spreading disease threatening the U.S., and the quarantine proposal based on a positive z 20 test, for the senator.
Run step four of five-step process by creating a two-column slide that presents two statements about Z 20: its fast spread and hard to manage nature, rephrasing them across columns.
Polish the first slide by presenting three mutually exclusive, collectively exhaustive bullets. Space them with 18.4 point line spacing and add a left callout for the exponential growth curve.
Outline the content of the second slide to function as the introduction, clarifying what should be included for a clear, engaging start.
Compare the relevant facts, refine the executive summary, and present the third statement in a takeaway box on the slide with bold keywords, citing the U.S. government as the source.
Analyze two scenarios, single testing and double testing, to guide the new slide layout in the analysis chapter, building on the executive summary to demonstrate structured problem solving.
Use a two-column illustration to compare single-testing and double-testing scenarios, employing a simple flowchart with text boxes and connectors to keep the concepts clear and easy to grasp.
Create a multi-scenario line chart to compare annual infections across do nothing, single testing, and double testing, with data transfer from Excel to PowerPoint and clear labeling.
Analyze how antidote availability reaches 100 percent by year eleven, and how bubbles, call outs, and a summary box illuminate do nothing versus double testing quarantine scenarios.
Speed up the antidote development by three years, a challenging yet feasible goal, and outline option a with a two-column slide of assumptions and the probabilistic year-by-year availability curve.
Please remember to download your PDF summary of key course concepts!
Learn the key skills you'd obtain from spending years at a top management consulting firm such as McKinsey, BCG and Bain.
Alumni of those firms are highly sought after for their skill-set. Now you can benefit from this steep learning curve and put yourself ahead of the curve!
This course is highly interactive:
You'll follow Tom, an ambitious young professional looking to excel in his first assignment.
Work with him to solve a challenging and far-reaching issue.
Find a way to break down the problem and structure the work.
Carry out a laser-focused analysis using Excel.
Build an impressive and to-the-point PowerPoint presentation.
At the end of the course, you'll be able to:
Manage projects and deliver exceptional results in significantly less time than ever before.
Structure and break-down problems effectively
Build quantitative models
Convince management with powerful and to-the-point presentations.
Professionally animated and narrated, interspersed with a multitude of quizzes and exercises, the learnings from this course are designed to click & stick.
Take your career to the next level!
Taught by two seasoned ex-BCG consultants.