TalentLabs

This is the repo for assignments by TalentLabs --

• Foundation Certificate in Data Analytics pathway
• Certified Associate in Business Analytics pathway

Foundation Certificate in Data Analytics

Skills learned:

1. Fundamentals of Python
2. Fundamentals of SQL
3. Data Analytics in nutshell

Table of contents:

No.	Name	Programming Language/Technical skills	Code
1	Tic-tac-toe	Python	Code
2	Titanic Dataset	SQL	Code
3	eCommerce Database design	SQL	Code
4	Google Universal analytics	Spreadsheet / Tableau	Code
5	Extra credit - Credit Risk	SQL	[Code]

Tic-tac-toe

Building a tic-tac-toe game in Python using Visual Studio Code.

Part 1: Game Functions

• markBoard(position, mark) - fill the box with either mark X or O
• printBoard() - print the game board
• validateMove(position) - validates player input
• checkWin - check if the player win
• checkFull - check if the board is full
• winCombinations - a list of 8 winning combinations

Part 2: Game Play

• consolidate the functions from part 1
• testing the game scenarios
• includes function to restart the game

Titanic Dataset

Exploring Titanic Dataset using SQL

Data exploration framework:

1. Understanding the business context
2. Understanding the technical context
3. Understanding the Tables and Fields
4. Free Exploration

eCommerce Database Design

Design a database for the eComm platform

Steps:

1. Think about all the entities involved
2. Think about the relationship between the entities
3. Draw the ER Diagram
4. Building DB in SQLite

Google Universal analytics

Exploring the data from the Google Universal Analytics Demo Account.

Steps:

1. Data collection
2. Data cleaning
3. Data wrangling
4. Data Analysis
5. Data Visualization

Extra credit - Credit risk

Reviewing a list of loan applications

2 tables:

• application - loan applications
• bureau - other loans of the applicants from other lenders

Certified Associate in Business Analytics

Skills learned:

1. Data collection
2. Data cleaning & wrangling
3. Data Analysis
4. Data Visualization

Table of contents:

No.	Name	Programming Language/Technical skills	Code
1	Data Analytics Plan for Game Company	Data collection	Code
2	Data Wrangling Project: Sharks Attack Dataset	Data cleaning & Wrangling - Python & SQL	Code
3			Code