
Gather market data from free reports, government sites, and annual reports as secondary data, collect primary data, then store it centrally and apply segmentation to target customer segments.
Discover free, reputable market data from sources like the US Census, the CDC, ARCView, and Our World in Data; learn to download, visualize, and apply it to sizing and forecasting.
Identify common market drivers across business units by collecting primary and secondary data, storing it in a labeled Excel workbook, and distinguishing input from predicted figures to build solid forecasts.
Explore market segmentation by demographic, geographic, and psychographic methods, learning how to target resonant customer segments and apply behavioral insights to product strategy.
Explore how innovations diffuse into health care markets, using the technology adoption lifecycle and crossing the chasm to move from innovators to early majority, addressing scalability, target customers, and pricing.
Explore the hype cycle: technology trigger to peak of inflated expectations, trough of disillusionment, slope of enlightenment, and plateau of productivity, crossing the chasm for health care innovations.
A copy of GioTrendline.xlsx is attached here for your use. This is for your use only and not to be shared with others who have not taken this course. A previous version of this excel sheet was named "GioForecast.xlsx" and this "GioTrendline" is an updated version of that.
A copy of GioATAR.xlsx is attached here for your use. This is for your use only and not to be shared with others who have not taken this course. This Excel sheet containts both the car and the online grocery example discussed in the lecture. As with all my spreadsheets, the yellow cells are "input" cells, where you can enter your data. All other cells are computed cells, meaning that they are not meant to be changed by the student.
A copy of GioBASS.xlsx is attached here for your use. This is for your use only and not to be shared with others who have not taken this course. This Excel sheet contain the E Vehicles, Satellite Radio and E Books examples discussed in the lecture. As with all my spreadsheets, the yellow cells are "input" cells, where you can enter your data. All other cells are computed cells, meaning that they are not meant to be changed by the student.
Explore how CRM tools support forecasting by tracking customer interactions and purchases, using the sales funnel from leads to win, to forecast future sales and the market.
Explore how professional forecasting models identify driving forces and seasonality to forecast annual demand, and how AI shifts forecasting by using historic output data to generate rules.
Explore forecasting lessons on the annual growth versus market share dilemma and the addressable market, emphasizing ethical, accurate definitions and multi-tool validation.
Celebrate your completion of decode your market: the sizing and forecasting puzzle, and commit to applying the tools and skills learned in this course to future endeavors.
WHY IS THIS COURSE IMPORTANT?
How big is the market—and how much of it can you realistically capture?
Those are two of the most important questions behind any new product, service, or business opportunity. Yet market forecasts are often built on assumptions that are difficult to explain or defend.
This course takes a practical, analytical approach. You'll learn how to research a market, estimate its size, identify the portion you can realistically address, and develop forecasts based on data and clearly defined assumptions.
Along the way, you'll learn how to:
Find useful market data from credible sources
Use primary and secondary market research
Organize and evaluate the data you collect
Segment a market to better understand the real opportunity
Distinguish the total market from the market you can realistically address
Use trendlines to forecast from historical data
Apply the ATAR and Bass models to new-product forecasting
Understand technology adoption using Crossing the Chasm and the Hype Cycle
Use CRM and sales-pipeline information to forecast future business
Recognize the assumptions and limitations behind any forecast
Use the included Excel tools to explore several forecasting techniques
WHO IS THIS COURSE FOR?
This course is designed for product managers, marketers, business-development professionals, entrepreneurs, analysts, consultants, and managers who need to evaluate markets, develop business plans, launch new products or services, or forecast future sales.
WHY LEARN THIS FROM ME?
I've spent more than 35 years in business, moving from engineering to marketing leadership and eventually serving as president of a healthcare IT company. I've also taught MBA students for many years, where market sizing and forecasting was one of my favorite subjects to teach.
My teaching style is very pragmatic. I assume you may be new to the subject, start with the fundamentals, and build from there. Because some forecasting concepts can become complicated quickly, I use practical examples—both healthcare and non-healthcare—to make them easier to understand and apply.
My approach to market sizing and forecasting isn't theoretical. It's based on building forecasts, challenging assumptions, and developing projections that could be explained and defended to management.
My objective isn't to turn you into a forecasting expert. It's to give you practical tools and approaches you can use to answer four important questions:
What do we know? What don't we know? What assumptions are we making? And can we defend them?
By the end of the course, you'll have a practical set of tools for turning market information and business assumptions into forecasts you can explain—and defend.