🅰🅰🅰 Day

1️⃣ Overview

◽ AAA Day(Advanced Azure Data Analytics Day)란?

• 게임사를 위한 Advanced Azure Data Analytics Training Day
• 실무자를 위한 개념부터 Hand-on Lab까지 Ons-Stop 진행 구성
• Azure Synapse Analytics로 통합된 환경에서 데이터 처리 및 분석하는 활용법 Training
• (ingest, explore, prepare, manage, machine learning, BI)

---

◽ Development Environment

Page_type	Languages	Products	Description
Training	Pyspark SQL Python Scala	Azure Synapse Analytics Service Azure Machine Learning Service	Advanced Azure Data Analytics Training

---

◽ AAA Day Training Intro

---

2️⃣ PreRequirement

◽ Download Resource

• Part0 : Overview

• Overview.pdf

• Part1 : SQL pool
• Part2 : Apache Spark pool
• Part3 : ML Modeling ( Code-Free & Apache Spark MLlib )

• Hands On Labs Guide.pdf

---

3️⃣ Methodology

◽ Azure Synapse Analytics Architecture

---

◽ Additional Info

◽ Part0 : Overview

◽ Part1 : SQL pool

• Part1_copy_data.sql
• Part1_create_tables.sql
• Part1_join_tables.sql

◽ Part2 : Apache Spark pool

• Part2_preprocessing.py | Part2_preprocessing.ipynb
• Part2_sqlpooltospark.py | Part2_sqlpooltospark.ipynb

◽ Part3 : ML Modeling ( Code-Free & Apache Spark MLlib )

• Part3_sparkmllib_regression.py | Part3_sparkmllib_regression.ipynb

---

4️⃣ Appendix

◽ Next Step of AAA Day Training

• ① : Azure Synapse Analytics를 활용한 User Segmentation기반의 Target Marketing
• ② : Azure Machine Learning Service를 활용한 Abuser Detection
• ③ : Azure Cognitive Service를 활용한 챗봇 및 in-game translation 개발

---

5️⃣ Reference

• URL What is Azure Synapse Analytics? | Microsoft Docs