SPC Analytics Strategic Predictive Consulting
Analyzing Online Reviews with AI · Full curriculum

Thirteen chapters. Three parts. One dataset carried through all of them.

Online reviews are market signals, not opinions. Reading them rigorously takes a real analytical stack, and the barrier was never the statistics: it was the tooling. Running the analysis through Google Colab and Gemini removes the coding barrier, so the attention goes where it belongs, to why a method exists, how to read its output, and what the result does and does not license.

This page is the chapter by chapter map of the book by Jeong-Yeol Park, Ph.D., written for graduate students, researchers, and working professionals who need rigorous quantitative analysis of review data without a coding background. Between the parts are three analyses you can run today, on your own exported reviews or on the public companion file. The program page has the pitch and the instructor companion; this page has the curriculum.

Watch lesson one freeThe methods programGet the book

Chapters 13 Plus one hands-on mini-project
Parts 3 Foundations · methods · applications
Coding background needed 0 Plain requests typed into Colab and Gemini
Companion corpus 1 Every number in the book computed from it
Part I · Chapters 1 to 4, then the lab

Foundations: what the data is before any model touches it.

Four chapters and one lab, before a single estimate. They set what a review actually measures, what the platform already selected away, the working environment you will use for the rest of the book, and the vocabulary every later chapter assumes. The part ends with an analysis you run end to end, so the first model you meet arrives after you have already handled data yourself. The chapter one lesson is free to watch now, with no account.

Chapter 1 · You can State the case for the whole stack Introduction Say why review data is a market signal rather than an opinion archive, and why reading it well takes an integrated set of methods rather than one favorite technique.
Chapter 2 · You can Read a review as data, field by field Understanding Online Review Data Name what each component of a review measures and what it does not, and describe the selection the platform applied long before the file reached you.
Chapter 3 · You can Work in a live notebook, no install Getting Started with Google Colab and Gemini Open a notebook, upload a dataset, and get an analysis running by typing plain requests. This is the chapter that removes the coding barrier, and it comes early on purpose.
Chapter 4 · You can Choose the question before the method Thinking Like a Data Analyst State your unit of analysis, and tell description, prediction, explanation, and causality apart. Most bad review studies go wrong here rather than at the estimator.
Mini-project · You can Run one analysis start to finish Analyze 500 Reviews in 30 Minutes Load review data, summarize it, find what positive and negative reviewers talk about, measure sentiment, and finish with recommendations someone could act on. About thirty minutes, no code written.
Try a piece of it now

Open Colab and meet your own review file.

Export your reviews as a CSV, or take the public companion file from the book's data repository. Open a Google Colab notebook with Gemini enabled, upload the file, and paste the request below. Nothing to install, nothing to configure. This is a chapter 3 environment doing chapter 2 work: before you model anything, find out what you are holding.

Copy this prompt
I uploaded a CSV of online reviews called [your_file.csv]. Load it and report: the number of rows; every column name with its data type; the earliest and latest review date; how many distinct businesses appear; the number of reviews per business as a minimum, median, and maximum; and the count of missing values in each column. Then list the columns you would not yet trust as analysis variables, and say why for each one. Do not drop or clean anything yet.

Companion file and code: github.com/jeong-yeol/AOR_with_AI. Maple City v3 is 11,010 synthetic reviews across 200 restaurants, 2019 to 2022, and every number printed in the book is computed from it.

Reading what came back

1. Check the row count against what you exported. A gap means the platform, the export, or the load dropped something, and you want to know which before anything else.

2. Look at reviews per business. If the median business carries a handful of reviews, no method in Part II will rescue that, and the honest move is to change the unit of analysis rather than the estimator.

3. Read the date range as a history of the platform, not of the market. Does your window cover the change you care about, with enough on both sides of it to see a before and an after?

4. It named columns it would not trust. Take one and decide for yourself: is it merely noisy, or is it measuring something other than what its name promises? Those two problems have different fixes.

Nothing on this page shows what any of these requests returned, and that is deliberate. The output that teaches you anything is the one your own file produces; a printed answer would turn a piece of work back into a piece of reading.

Part II · Chapters 5 to 11

Methods: seven of them, each in the same three moves.

Every methods chapter holds one shape. WHY the method exists, and what question it answers that the others cannot. How to INTERPRET the output, line by line, including the parts that look like results and are not. How to APPLY the finding, in a paper and in a decision. The shape is the point: it is what lets a reader who has never estimated a model before arrive at a defensible reading of one.

Chapter 5 · You can Turn text into variables you can defend From Text to Numbers Produce sentiment scores, topic structure, and engineered features from raw review text, and say in one sentence what each number is a measure of. Everything later in the book rests on this step.
Chapter 6 · You can Separate change from difference Panel Regression Read a coefficient as movement within a business over time rather than a ranking across businesses, and know which of those two questions your data can actually answer.
Chapter 7 · You can Say caused, or decline to Causal Inference Choose among difference in differences, instrumental variables, and selection correction; state the assumption each design buys on credit; and recognize when your data cannot carry any of them.
Chapter 8 · You can Tell a signal from a wobble Time-Series Analysis Separate trend, seasonality, and level shifts in a review series, and set the bar a moving line has to clear before you call it a change worth acting on.
Chapter 9 · You can Take geography seriously Spatial Econometrics Test whether nearby businesses move together, and separate a shared neighborhood condition from a genuine spillover between them. Two explanations, very different implications.
Chapter 10 · You can Test a theory, not just a table Structural Equation Modeling Settle the measurement model before the path model, read loadings, fit, and indirect effects for what they are, and stop short of the mediation claim the design cannot support.
Chapter 11 · You can Predict well and explain nothing Machine Learning for Prediction Build an honest train and test split, pick the performance metric your problem actually needs, and say plainly why a strong predictor is not an account of why anything happens.
Try a piece of it now

Build one variable out of text, then try to break it.

Same notebook, same file. This is the chapter 5 move that every later chapter depends on, run as an audit rather than a demonstration. You are not looking for a good score. You are looking for the cases where the score and the star rating disagree, because that is where you find out what your new variable is measuring.

Copy this prompt
Using the review text column in the file I uploaded, compute a sentiment score for every review and add it as a new column. Then report: the distribution of that score; its correlation with the star rating; the same score aggregated to the business-month level, together with how many business-months contain fewer than five reviews; and the 15 reviews where the sentiment score and the star rating disagree most sharply, printed with their full text and their rating. Do not interpret the results for me.
Reading what came back

1. Read the 15 disagreements and label them yourself before you accept the score. If most of them turn on sarcasm, negation, or a mixed review with one loud complaint, your variable is tracking wording rather than evaluation.

2. Correlation with the star rating is a sanity check, not a validation. Very near one means you have rebuilt the star rating slowly; near zero means at least one of the two is not measuring what you assumed.

3. Find the thin business-months. Every panel, time-series, and spatial method in Part II inherits them, so decide now whether to aggregate up, restrict the sample, or narrow the question.

4. Say what the number measures in one sentence without using the word sentiment. If you cannot, you have a column, not yet a construct, and the chapters after this one will amplify that gap rather than close it.

Part III · Chapters 12 and 13

Applications: whole questions, and what is coming next.

Real problems do not arrive labeled with a method. The last two chapters put the methods back together on complete questions, then look at where review analytics is going and how to judge a new capability before adopting it. The second of those matters more than it sounds: most of what arrives next will be easy to run and hard to validate.

Chapter 12 · You can Carry one question across methods Case Studies Work a full problem from text measurement through to a finding, and justify every handoff from one method to the next rather than running them because they are available.
Chapter 13 · You can Judge what arrives next Where Review Analytics Is Heading Follow a protocol for validating a language-model classifier before you cite it, and decide which new tool is worth adopting on evidence rather than on novelty.
Try a piece of it now

Audit a classifier before you cite it.

This is the chapter 13 discipline in its smallest form. The request deliberately asks for labels and nothing else: no summary, no accuracy figure. The scoring is yours to do, because a measure you did not check is a measure you cannot report.

Copy this prompt
Draw a random sample of 100 reviews from the file I uploaded, using a fixed random seed so I can reproduce the same sample later. Classify each review on this category: [state your category, for example, mentions a service failure or does not]. Output a table with the review id, the review text, and the assigned label, sorted by review id. Do not summarize the results, do not report an accuracy figure, and do not tell me what the labels mean.
Reading what came back

1. Label the same 100 yourself first, ideally with a second person, and settle your own disagreements before you look at the machine labels. How often two humans disagree is the ceiling on what any classifier can be scored against.

2. Compare row by row and count the two kinds of error separately. A single overall figure hides the direction of failure, and the direction is what determines whether your downstream estimate is biased up or down.

3. Reread the cases where you and the machine disagreed. If your category was ambiguous on those, fix the category definition and rerun, rather than blaming the classifier.

4. Write the sentence you would put in a manuscript, with the sample size and the agreement statistic in it. If that sentence needs a hedge, the hedge belongs in the manuscript too.

The book

One corpus, checked end to end.

Analyzing Online Reviews with AI: A No-Code Guide from Raw Data to Research Findings, by Jeong-Yeol Park, Ph.D. Every number in the book is computed from a single companion corpus, Maple City v3: 11,010 synthetic reviews across 200 restaurants, 2019 to 2022. One dataset across thirteen chapters means a reader can rerun any example, compare against what is printed, and see exactly where their own run diverged.

The corpus is public, so nothing here has to be taken on trust. Download it, work the chapters in the order your own question needs, and check the book against itself.

Available as paperback and Kindle. Data and code: github.com/jeong-yeol/AOR_with_AI.

Where to start

Start with the thirty-minute analysis, then take the chapter your question needs.

The mini-project is the entry point for every reader, whether the output is headed for a manuscript or for Monday. After that the order is yours: text measurement first, then whichever of panel regression, causal design, forecasting, spatial diagnostics, theory testing, or prediction your data can actually support. The mini-project is a free video lesson, and the program page carries it in written form alongside the practice files and the instructor companion for programs adopting the book as a methods text.

Start the mini-project freeGet the book