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

Thirteen chapters. Three parts. One dataset.

A chapter map of the video course, built on the book by Jeong-Yeol Park, Ph.D. Each tile is what that chapter leaves you able to do. Three Colab analyses sit under the parts; open them if you want to run the work today. This page is the map. Lesson one is free. A seat is $249.

Start chapter one freeBuy a seat, $249Get 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. The chapter one lesson is free to watch now, with no account.

Chapter 1 · You can State the case for the whole stack Introduction
Chapter 2 · You can Read a review as data, field by field Understanding Online Review Data
Chapter 3 · You can Work in a live notebook, no install Getting Started with Google Colab and Gemini
Chapter 4 · You can Choose the question before the method Thinking Like a Data Analyst
Mini-project · You can Run one analysis start to finish Analyze 500 Reviews in 30 Minutes
Try 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. 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.

WHY the method exists. How to INTERPRET the output. How to APPLY the finding. That shape is what lets a reader who has never estimated a model arrive at a defensible reading of one.

Chapter 5 · You can Turn text into variables you can defend From Text to Numbers
Chapter 6 · You can Separate change from difference Panel Regression
Chapter 7 · You can Say caused, or decline to Causal Inference
Chapter 8 · You can Tell a signal from a wobble Time-Series Analysis
Chapter 9 · You can Take geography seriously Spatial Econometrics
Chapter 10 · You can Test a theory, not just a table Structural Equation Modeling
Chapter 11 · You can Predict well and explain nothing Machine Learning for Prediction
Try 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 looking for the cases where the score and the star rating disagree.

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, then look at how to judge a new capability before adopting it.

Chapter 12 · You can Carry one question across methods Case Studies
Chapter 13 · You can Judge what arrives next Where Review Analytics Is Heading
Try now: Audit a classifier before you cite it

This is the chapter 13 discipline in its smallest form. The request asks for labels and nothing else. The scoring is yours, 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.

Where to start

Start with the thirty-minute analysis. A seat is $249.

The mini-project is the entry point. After that, take the chapter your question needs. Every number in the book is computed from Maple City v3 (11,010 synthetic reviews, 200 restaurants, 2019 to 2022), public at github.com/jeong-yeol/AOR_with_AI. Lesson one is free. The full program is $249 for the first thirty seats, then $399. Both programs together are $399 introductory, $649 after.

Start the mini-project freeBuy a seat, $249Get the book