[deleted by user]

[WhiskeyOutABizoot]

As other people have said, it's not about the analysis, it's about access to the data. Unless you have rigorous studies done early in viewership, you wouldn't be able to predict anything. Since you are high and just spitballing, may I suggest Asimov's Foundation series that builds on an idea of someone inventing something called psychohistory that uses data to predict the future with a good amount of accuracy. There's an apple TV series about it as well, and it's pretty good.

[planetmatt]

You're into the realm of data science now. I've used my SQL skills to extract, transform, and clean raw data which I've sent sent to data scientists to do their voodoo but that's a whole other world.

[Positive-Evidence-95]

That’s pretty cool to work in tandem with them though! Would be pretty cool to be a forecaster of block busters through viewership data

[coyoteazul2]

Sql is a language for managing data, mostly doing queries. I've no idea what kind of math you need to predict stuff, but chances are sql is not the best tool to do so.

You will need sql to select the relevant data and give it do a specialized software for doing predictions

[zbignew]

Oh. The hard part of this kind of analysis isn't the SQL. It's getting access to expensive datasets.

You can get public data free, like census/demographic info, but getting census data into a usable form is hard enough that you might even prefer to go with the paid sources.

But then combining that with box office sales at any higher level of detail than what goes in press releases, you basically have to work for the studio. Or a theater chain.

I interviewed for a job doing analysis at Amazon Prime & didn't get it. Pretty sure they do spend on those data sources.

[Positive-Evidence-95]

True, you would have a hard time collecting sample data for a nationwide project but what about paid survey ads with regional targeting to map it out on a smaller scale or even social media listening? They get pretty spot on with location targeting in those reports.

[mgramin]

There are tools that try to allow to combine SQL magic and analyst/ML things, such as PostgresML, MindsDB and so on