|
|
1 -Course Approach.mp4
|
MP4
|
14 MB
|
|
|
1 -Data Visualization What To Expect.mp4
|
MP4
|
21.8 MB
|
|
|
1 -Experimentation What To Expect.mp4
|
MP4
|
20 MB
|
|
|
1 -Framing The Applicant Tracking System.mp4
|
MP4
|
9.4 MB
|
|
|
1 -Game Analytics What To Expect.mp4
|
MP4
|
50.5 MB
|
|
|
1 -Introduction.mp4
|
MP4
|
10.2 MB
|
|
|
1 -Job Application Process Overview.mp4
|
MP4
|
8.8 MB
|
|
|
1 -Q & A With Studio GMs.mp4
|
MP4
|
12.1 MB
|
|
|
1 -Resume What Is Their Purpose.mp4
|
MP4
|
8.2 MB
|
|
|
1 -SQL What To Expect.mp4
|
MP4
|
27.7 MB
|
|
|
1 -Teamwork & Collaboration What To Expect.mp4
|
MP4
|
32.8 MB
|
|
|
1 -Thank You!.mp4
|
MP4
|
18 MB
|
|
|
1 -The Interview Team & Approach.mp4
|
MP4
|
33.8 MB
|
|
|
1 -The StudioGame Atomic Unit.mp4
|
MP4
|
11.3 MB
|
|
|
1 -What Does A Game Analyst Do.mp4
|
MP4
|
18.9 MB
|
|
|
1. game database.sql
|
SQL
|
102.4 B
|
|
|
10 -Statistics What To Do.mp4
|
MP4
|
27.7 MB
|
|
|
10 -Summary Analytics Projects & Prioritization.mp4
|
MP4
|
13.4 MB
|
|
|
10 -Telemetry What To Do.mp4
|
MP4
|
20 MB
|
|
|
11 -Assignment Nexus Battlegrounds Introduction.mp4
|
MP4
|
17 MB
|
|
|
11 -Experimentation Case Study Wordle Engagement Lift.pdf
|
PDF
|
150.6 KB
|
|
|
11 -Experimentation Case Study Wordle Engagement Lift.xlsx
|
XLSX
|
74.1 KB
|
|
|
11 -Experimentation Case Study.mp4
|
MP4
|
98.9 MB
|
|
|
12 -Statistics Case Study - Part I.mp4
|
MP4
|
83.1 MB
|
|
|
13 -Logistic Regression Payer Model.pdf
|
PDF
|
4.1 MB
|
|
|
13 -Logistic Regression Payer Model.py
|
PY
|
7.5 KB
|
|
|
13 -Payer Logistics Regression Model.sql
|
SQL
|
4.4 KB
|
|
|
13 -Statistics Case Study - Part II.mp4
|
MP4
|
151.5 MB
|
|
|
14 -Statistics Case Study - Confusion Matrix & ROC-AUC.mp4
|
MP4
|
29 MB
|
|
|
2 -Applicant Tracking System Overview.mp4
|
MP4
|
20.8 MB
|
|
|
2 -Course Goals.mp4
|
MP4
|
19.2 MB
|
|
|
2 -Data Visualization Case Study.mp4
|
MP4
|
56.3 MB
|
|
|
2 -Data Visualization Case Study.pdf
|
PDF
|
866.7 KB
|
|
|
2 -Data Visualization Case Study.xlsx
|
XLSX
|
94.4 KB
|
|
|
2 -Different Types Of Studio Roles.mp4
|
MP4
|
24.2 MB
|
|
|
2 -Experimentation Analysis Steps.mp4
|
MP4
|
27.6 MB
|
|
|
2 -GM PopCap Games.mp4
|
MP4
|
10.5 MB
|
|
|
2 -Game Analytics Example.mp4
|
MP4
|
18.4 MB
|
|
|
2 -Learning Objectives.mp4
|
MP4
|
10.5 MB
|
|
|
2 -Managing Analytical Requests.mp4
|
MP4
|
25.7 MB
|
|
|
2 -Recap Knowledge & Experience Areas.mp4
|
MP4
|
13.5 MB
|
|
|
2 -Resume Building Blocks & Best Practices.mp4
|
MP4
|
21.3 MB
|
|
|
2 -SQL Examples.mp4
|
MP4
|
71.3 MB
|
|
|
2 -Teamwork & Collaboration What To Do.mp4
|
MP4
|
13.7 MB
|
|
|
2 -What Does A Game Analyst Need To Know.mp4
|
MP4
|
17.3 MB
|
|
|
2 -Where To Find Job Listings.mp4
|
MP4
|
13.8 MB
|
|
|
2 -Why Team Structure Is Important.mp4
|
MP4
|
8.3 MB
|
|
|
2. date_lookup.sql
|
SQL
|
15 KB
|
|
|
3 -Accomplishments & Actions.mp4
|
MP4
|
35.7 MB
|
|
|
3 -D1 Retention.sql
|
SQL
|
1.2 KB
|
|
|
3 -Data Visualization What To Do.mp4
|
MP4
|
16.2 MB
|
|
|
3 -Example Job Listing Analysis.mp4
|
MP4
|
48.7 MB
|
|
|
3 -Experimentation Theory.mp4
|
MP4
|
34 MB
|
|
|
3 -GM Capital Games.mp4
|
MP4
|
18.3 MB
|
|
|
3 -Game Analytics Case Study Engagement Lift.pdf
|
PDF
|
179.7 KB
|
|
|
3 -Game Analytics Case Study Engagement Lift.xlsx
|
XLSX
|
67.9 KB
|
|
|
3 -Game Analytics Case Study.mp4
|
MP4
|
74.4 MB
|
|
|
3 -Game CompanyStudio Organization.mp4
|
MP4
|
13.3 MB
|
|
|
3 -Information Extraction, Matching & Scoring.mp4
|
MP4
|
29.9 MB
|
|
|
3 -Learning Resources.mp4
|
MP4
|
17.4 MB
|
|
|
3 -Resume Keywords & Accomplishments.pdf
|
PDF
|
505.3 KB
|
|
|
3 -SQL Case Study.mp4
|
MP4
|
82.2 MB
|
|
|
3 -Studio Organization & Teamwork.mp4
|
MP4
|
14.9 MB
|
|
|
3 -Summary Game Studio Players.mp4
|
MP4
|
13.5 MB
|
|
|
3 -Summary Interview Process.mp4
|
MP4
|
19.7 MB
|
|
|
3 -The Game Analytics Request Process.mp4
|
MP4
|
6.6 MB
|
|
|
3 -What Skills Does A Game Analyst Need.mp4
|
MP4
|
28.5 MB
|
|
|
3. sales.sql
|
SQL
|
1.8 MB
|
|
|
4 -Analytics Team Models.mp4
|
MP4
|
15.2 MB
|
|
|
4 -Applicant Tracking Systems Mistakes & Tips.mp4
|
MP4
|
14.7 MB
|
|
|
4 -CEO Funcraft Games.mp4
|
MP4
|
17.4 MB
|
|
|
4 -Data Analyst vs Game Analyst Skills.mp4
|
MP4
|
51.7 MB
|
|
|
4 -Experimentation Analysis.mp4
|
MP4
|
29.7 MB
|
|
|
4 -Game Analytics Metric Development.mp4
|
MP4
|
30.3 MB
|
|
|
4 -How To Contact Me.mp4
|
MP4
|
2.5 MB
|
|
|
4 -Job Application & Interview Preparation.mp4
|
MP4
|
14.1 MB
|
|
|
4 -Requirements.mp4
|
MP4
|
12.7 MB
|
|
|
4 -Resume Examples.mp4
|
MP4
|
43.3 MB
|
|
|
4 -Resume Examples.pdf
|
PDF
|
555.2 KB
|
|
|
4 -SQL What To Do.mp4
|
MP4
|
10.1 MB
|
|
|
4 -Summary Job Listings.mp4
|
MP4
|
7.1 MB
|
|
|
4. game_features.sql
|
SQL
|
1.4 KB
|
|
|
5 -Cover Letter Basics.mp4
|
MP4
|
30.7 MB
|
|
|
5 -Data Issues What To Expect.mp4
|
MP4
|
15.8 MB
|
|
|
5 -Estimate The Number Of Dentist In The USA.pdf
|
PDF
|
135.2 KB
|
|
|
5 -Estimate The Number Of Dentist In The USA.xlsx
|
XLSX
|
62.5 KB
|
|
|
5 -Example Job Listings For Keyword Matching.pdf
|
PDF
|
136.3 KB
|
|
|
5 -Experimentation Edge Cases.mp4
|
MP4
|
24.1 MB
|
|
|
5 -Game Analyst Responsibilities.mp4
|
MP4
|
20.3 MB
|
|
|
5 -Job Description & Resume Check.mp4
|
MP4
|
44.4 MB
|
|
|
5 -Lecture 93 - Estimation.mp4
|
MP4
|
32.3 MB
|
|
|
5 -Source Data.mp4
|
MP4
|
12.7 MB
|
|
|
5 -Studio Team Examples.mp4
|
MP4
|
32.5 MB
|
|
|
5. raw_event.sql
|
SQL
|
1.1 KB
|
|
|
6 -Analysis Design.mp4
|
MP4
|
16.4 MB
|
|
|
6 -Cover Letter Examples.mp4
|
MP4
|
42.1 MB
|
|
|
6 -Cover Letter Examples.pdf
|
PDF
|
295.1 KB
|
|
|
6 -Data Issues Case Study.mp4
|
MP4
|
123 MB
|
|
|
6 -Experimentation What To Do.mp4
|
MP4
|
23.4 MB
|
|
|
6 -Game Analyst Career Paths.mp4
|
MP4
|
14.9 MB
|
|
|
6 -Game Analytics What To Do.mp4
|
MP4
|
20.6 MB
|
|
|
6 -Gaming Metrics & KPIs.pdf
|
PDF
|
231 KB
|
|
|
6 -Summary Applicant Tracking Systems.mp4
|
MP4
|
14.5 MB
|
|
|
6 -Types Of Data Analysts.mp4
|
MP4
|
33.5 MB
|
|
|
6. load_raw_event.sql
|
SQL
|
409.6 B
|
|
|
7 -Data Issues What To Do.mp4
|
MP4
|
18.4 MB
|
|
|
7 -Game Analyst Perspective.mp4
|
MP4
|
73.4 MB
|
|
|
7 -Jason Jasinski_Game Analyst Interview Questions.pdf
|
PDF
|
573.1 KB
|
|
|
7 -Results.mp4
|
MP4
|
9.5 MB
|
|
|
7 -Statistics What To Expect.mp4
|
MP4
|
42 MB
|
|
|
7 -Summary Game Analyst Skills.mp4
|
MP4
|
19.5 MB
|
|
|
7 -Summary Resumes & Cover Letters.mp4
|
MP4
|
17.4 MB
|
|
|
7 Day Rolling Average.sql
|
SQL
|
512 B
|
|
|
7.load_game_features.sql
|
SQL
|
409.6 B
|
|
|
8 -Statistics Confidence Intervals.mp4
|
MP4
|
30.6 MB
|
|
|
8 -Telemetry What To Expect.mp4
|
MP4
|
41.5 MB
|
|
|
8 -The Analytics Plan.mp4
|
MP4
|
21.9 MB
|
|
|
9 -Example Analytics Plan.mp4
|
MP4
|
32.4 MB
|
|
|
9 -Sample Analytics Plan.pdf
|
PDF
|
276.9 KB
|
|
|
9 -Statistics Which Statistical Test.mp4
|
MP4
|
14.8 MB
|
|
|
9 -Telemetry Hands On & Walkthrough.mp4
|
MP4
|
164.4 MB
|
|
|
ARPU.sql
|
SQL
|
1.9 KB
|
|
|
Analysis Priorities Role Play Solution.pdf
|
PDF
|
173.6 KB
|
|
|
Analysis Priorities Role Play Transcript.pdf
|
PDF
|
201 KB
|
|
|
Assignment Hutch Job Description.pdf
|
PDF
|
1.4 MB
|
|
|
Bonus Resources.txt
|
TXT
|
102.4 B
|
|
|
CLTV.sql
|
SQL
|
1.5 KB
|
|
|
Committed Users.sql
|
SQL
|
1.5 KB
|
|
|
Cover Letter Examples.pdf
|
PDF
|
295.1 KB
|
|
|
D1 Retention.sql
|
SQL
|
1.2 KB
|
|
|
DARPU.sql
|
SQL
|
1.4 KB
|
|
|
DAU And Installs.sql
|
SQL
|
921.6 B
|
|
|
DAU By Platform.csv
|
CSV
|
1.9 KB
|
|
|
DAU.csv
|
CSV
|
1 KB
|
|
|
DAU.sql
|
SQL
|
1.7 KB
|
|
|
DBeaver Installation Instructions.pdf
|
PDF
|
1.7 MB
|
|
|
Data Issues Dashboard DAU.sql
|
SQL
|
1.4 KB
|
|
|
Data Issues Dashboard IAP.sql
|
SQL
|
2.5 KB
|
|
|
Data Issues Dashboard Installs.sql
|
SQL
|
1.6 KB
|
|
|
Data Issues Dashboard Purchase Funnel.sql
|
SQL
|
3.9 KB
|
|
|
Data Issues Dashboard Retention.sql
|
SQL
|
15 KB
|
|
|
Data Issues_ Case Study.xlsx
|
XLSX
|
220.7 KB
|
|
|
Data Visualization Case Study.pdf
|
PDF
|
866.7 KB
|
|
|
Data Visualization Case Study.xlsx
|
XLSX
|
94.4 KB
|
|
|
Data Viz Case Study.twbx
|
TWBX
|
12.9 KB
|
|
|
Economy Inflows And Outflows.sql
|
SQL
|
3.1 KB
|
|
|
Estimate The Number Of Dentist In The USA.pdf
|
PDF
|
135.2 KB
|
|
|
Estimate The Number Of Dentist In The USA.xlsx
|
XLSX
|
62.5 KB
|
|
|
Example Job Listings For Keyword Matching.pdf
|
PDF
|
136.3 KB
|
|
|
Experimentation Case Study Wordle Engagement Lift.pdf
|
PDF
|
150.6 KB
|
|
|
Experimentation Case Study Wordle Engagement Lift.xlsx
|
XLSX
|
74.1 KB
|
|
|
Feature Lift Analysis.sql
|
SQL
|
7 KB
|
|
|
Five Questions On Data & Analytics With Studio GMs.pdf
|
PDF
|
413.3 KB
|
|
|
Game Analyst Career Preparation Slides & Notes.pdf
|
PDF
|
18.9 MB
|
|
|
Game Analyst Career Preparation Slides.pdf
|
PDF
|
18.5 MB
|
|
|
Game Analytics Case Study Engagement Lift.pdf
|
PDF
|
179.7 KB
|
|
|
Game Analytics Case Study Engagement Lift.xlsx
|
XLSX
|
67.9 KB
|
|
|
Game Analytics Database Information.pdf
|
PDF
|
309.5 KB
|
|
|
Game Analytics Mock Data Taxonomy.pdf
|
PDF
|
136.5 KB
|
|
|
Game Analytics Mock Data Taxonomy.xlsx
|
XLSX
|
141.6 KB
|
|
|
Gaming Metrics & KPIs.pdf
|
PDF
|
231 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
IAP.csv
|
CSV
|
204.8 B
|
|
|
IAP.sql
|
SQL
|
2.3 KB
|
|
|
Installs By Platform.csv
|
CSV
|
921.6 B
|
|
|
Installs.sql
|
SQL
|
1.5 KB
|
|
|
Jason Jasinski Game Analyst Interview Questions.pdf
|
PDF
|
573.1 KB
|
|
|
Join Demonstration With Index.sql
|
SQL
|
2 KB
|
|
|
Join Demonstration.sql
|
SQL
|
1.8 KB
|
|
|
KPIs.csv
|
CSV
|
204.8 B
|
|
|
Logistic Regression Payer Model.pdf
|
PDF
|
4.1 MB
|
|
|
Logistic Regression Payer Model.py
|
PY
|
7.5 KB
|
|
|
MAU.csv
|
CSV
|
1 KB
|
|
|
MAU.sql
|
SQL
|
512 B
|
|
|
Monthy Inflow And OutFlow.sql
|
SQL
|
1.3 KB
|
|
|
MySQL Installation Instructions Windows & Mac.pdf
|
PDF
|
18.8 MB
|
|
|
Nexus Battle Ground Dashboard.twbx
|
TWBX
|
63.8 KB
|
|
|
Pay Model CTE.sql
|
SQL
|
9.9 KB
|
|
|
Payer Analysis.sql
|
SQL
|
5.7 KB
|
|
|
Payer Logistics Regression Model.sql
|
SQL
|
4.4 KB
|
|
|
Pearsons R In SQL.sql
|
SQL
|
1 KB
|
|
|
Purchase Funnel.csv
|
CSV
|
3.5 KB
|
|
|
Purchase Funnel.sql
|
SQL
|
3.9 KB
|
|
|
Resume Examples.pdf
|
PDF
|
555.2 KB
|
|
|
Resume Keywords & Accomplishments.pdf
|
PDF
|
505.3 KB
|
|
|
Retention By Platform.csv
|
CSV
|
1.2 KB
|
|
|
Retention Overall.csv
|
CSV
|
409.6 B
|
|
|
Retention.csv
|
CSV
|
34.2 KB
|
|
|
Retention.sql
|
SQL
|
15 KB
|
|
|
Sample Analytics Plan.pdf
|
PDF
|
276.9 KB
|
|
|
Sampling.sql
|
SQL
|
2 KB
|
|
|
Screenshot (1944).png
|
PNG
|
661.5 KB
|
|
|
Screenshot (1945).png
|
PNG
|
992.5 KB
|
|
|
Screenshot (1946).png
|
PNG
|
926.9 KB
|
|
|
Screenshot (1948).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1949).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1950).png
|
PNG
|
1 MB
|
|
|
Screenshot (1951).png
|
PNG
|
1.2 MB
|
|
|
Screenshot (1952).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1953).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1954).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1955).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1956).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1957).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1958).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1959).png
|
PNG
|
1.3 MB
|
|
|
Screenshot (1960).png
|
PNG
|
1.2 MB
|
|
|
Screenshot (1961).png
|
PNG
|
1.8 MB
|
|
|
Screenshot (1962).png
|
PNG
|
1.8 MB
|
|
|
Screenshot (1963).png
|
PNG
|
1.2 MB
|
|
|
Screenshot (1964).png
|
PNG
|
1.3 MB
|
|
|
Screenshot (1965).png
|
PNG
|
1.3 MB
|
|
|
Screenshot (1966).png
|
PNG
|
1 MB
|
|
|
Screenshot (1967).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1968).png
|
PNG
|
1.4 MB
|
|
|
Screenshot (1969).png
|
PNG
|
1.4 MB
|
|
|
Screenshot (1970).png
|
PNG
|
1.2 MB
|
|
|
Screenshot (1971).png
|
PNG
|
991.9 KB
|
|
|
Screenshot (1972).png
|
PNG
|
999.3 KB
|
|
|
Screenshot (1973).png
|
PNG
|
939.2 KB
|
|
|
Screenshot (1974).png
|
PNG
|
963.9 KB
|
|
|
Screenshot (1975).png
|
PNG
|
758.8 KB
|
|
|
Screenshot (1976).png
|
PNG
|
1 MB
|
|
|
Screenshot (1977).png
|
PNG
|
816.3 KB
|
|
|
Screenshot (1978).png
|
PNG
|
990.9 KB
|
|
|
Screenshot (1979).png
|
PNG
|
955.9 KB
|
|
|
Screenshot (1980).png
|
PNG
|
1 MB
|
|
|
Screenshot (1981).png
|
PNG
|
1.1 MB
|
|
|
Screenshot (1982).png
|
PNG
|
889.2 KB
|
|
|
Session.sql
|
SQL
|
1.5 KB
|
|
|
Validation Query - Run After Loading.sql
|
SQL
|
512 B
|
|
|
Window Functions.sql
|
SQL
|
3 KB
|
|
|
dau.sql
|
SQL
|
1.7 KB
|
|
|
desktop.ini
|
INI
|
204.8 B
|
|
|
game_features.csv
|
CSV
|
3.8 MB
|
|
|
iap.sql
|
SQL
|
2.5 KB
|
|
|
installs.sql
|
SQL
|
1.6 KB
|
|
|
purchase_funnel.sql
|
SQL
|
3.9 KB
|
|
|
raw_event.csv
|
CSV
|
255.7 MB
|
|
|
retention.sql
|
SQL
|
15 KB
|
