Data Analysis
Advanced Game Analysis With SQL
Building on the Game Analysis With SQL course, this course includes SQL techniques such as sub-queries, temporary tables, window functions and query optimization.
4 Weeks
16 hrs Of Instruction
Next Course:
​
September 2024
What You'll Learn
Window Functions: How window functions can simplify complex game data analysis. Window function FRAMEs, PARTITIONs and ORDERing. RANKing and percentile functions. Rolling averages, cumulative sum and improve game analysis efficiency and insight.
Jupyter Notebooks: How to install and use Jupyter, a web-based notebook for analytics. How to use Jupyter to analyze data using SQL and Python. How to use Python libraries for game analysis. Common Python libraries for statistics, visualization, machine learning and more.Â
Advanced Game Analysis: Using SQL to analyze game economies. Understanding game network health. Using SQL to monitor game inflows and outflows. Advanced monetization analysis and pricing. How to determine economy balance. How to use SQL for cohort analysis and LTV prediction.Â
Predictive Models & Dashboards: SQL techniques for preparing data for dashboards, reports and predictive models. Examples of churn and payer prediction using SQL. Combining SQL extraction, data and Python libraries to forecast player behavior.Â
Common Table Expressions (CTEs): How to use CTEs. The purpose of CTEs and code maintainability. Reducing queries complexity and improving analysis throughout. Recursive queries and when to use CTEs, sub-queries and temporary tables.
Query Optimization: The best way to run queries against large datasets. The impact of indexes. Which index type is best suited to which data. The EXPLAIN function and query performance. How to sample with SQL and increase query throughput.Â
Player Segmentation: How we can use SQL to discover player segments. Advanced analysis techniques using SQL and Python for K-Means clustering and decision trees. Using SQL and Python for visualization and model development.Â
Capstone Project: Capstone project requirements. Capstone project template and recommended approach. How to utilize assignments and course work for your capstone project.
This Course Includes
Office Hours With Instructor, Schedulable Instructor 1-On-1s
16 Hours of Instruction Delivered Over 8 Lessons
Downloadable Lesson Slides, Downloadable SQL and Python code
Lesson Assignments, Lesson Quizzes, In-Class Exercises
Final Course Quiz, Capstone Project For Analytics Portfolio
Certificate Of Completion, Digital Certificate Credentials
Course Content
LESSON 01: Window Functions - Part I
| LESSON 05: Query Efficiency
|
LESSON 02: Window Functions - Part II
| LESSON 06: Jupyter Notebook & Python Integration
|
LESSON 03: Sub-Queries & Temporary Tables
| LESSON 07: Advanced Analysis Workshop - Part I
|
LESSON 04: Common Table Expressions
| LESSON 08: Advanced Analysis Workshop - Part II
|
Requirements
As an advanced course, we recommend learners complete the Game Analysis With SQL course first before taking this course, or have some previous experience in data analysis using SQL.
Learners can benefit from the Masterclass: Game Analysis With SQL course, which includes both the Game Analysis With SQL and Advanced Game Analysis With SQL course as a bundled discount.
Learners will need to be able to install MySQL, DBeaver, Python and Jupyter Notebook software on their Windows or Mac PCs to access and use the course data and code.
Description
This course is a natural progression from the Game Analysis With SQL course. If you are new to SQL, we recommend taking the Game Analytics With SQLÂ course first or the Masterclass: Game Analysis With SQL, which features both SQL courses with a bundle discount.Â
Building on top of the Game Analytics With SQL course, this course brings several practical and hands-on workshops for advanced SQL analysis techniques used widely in gaming. In this course, learners will have the opportunity to install and use a MySQL database with game data and Jupyter Notebooks for analysis using SQL with supplied Python code.
Learners will understand and use advanced SQL analysis techniques such as window functions and common table expressions and how these are applied in gaming to understand economies, segment players and prepare data for dashboards, reports and use them in predictive model building.Â
Finally, learners will understand how queries are executed and how to use database tools and SQL techniques to improve query efficiency and throughput using indexes, sampling and other advanced SQL constructs.Â
This course features several assignments and quizzes to ensure that learners develop a full understanding of the course materials, are able to complete their capstone project and are eligible for a course completion certificate with distinction.