Udemy - Game Analyst Career Preparation

Files:

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