This training is aimed at professional development, and the certificate obtained does not replace the MYK (Professional Competency) certificate required for MYK-authorized training programs.

BI Analyst Training

This course covers the skills you need to become a BI (Business Intelligence) Analyst (statistics, Database theory, SQL, Tableau, Python).

Requirements:

• You need to install MySQL, Tableau Public, and Anaconda. We will guide you step by step on how to do this.
• Microsoft Excel 2003, 2010, 2013, 2016, or 365

Day 1 - Introduction

• Introduction to Data and Data Science
• Different Fields of Data Science
• Introduction to Business Analytics, Data Analytics, and Data Science

Day 2 - Business Analytics

• Business Analytics
• Data Analysis
• Data Science
• Introduction to Business Intelligence, Machine Learning, and Artificial Intelligence

Day 3 - Data and Data Science

• Traditional Data
• Big Data
• Traditional Data Science
• Machine Learning
• Data Science Areas and Discrete Lines

Day 4 - Common Data Science Techniques

• Traditional Data
• Real-World Data Examples
• Big Data
• Big Data Technologies
• Traditional Methods
• Machine Learning Techniques

Day 5 - Programming Languages and Common Data Science Tools

• Data Science Career Paths
• Statistics - Population and Sampling
• Descriptive Statistics

Day 6 - Basics of Inferential Statistics

• Distribution
• What is Distribution?
• Normal Distribution
• Standard Normal Distribution
• Central Limit Theorem
• Standard Error
• Estimators and Predictions
• Confidence Intervals
• Student's t-Distribution
• Error Margin

Day 7 - Statistics - Hypothesis Testing

• Null and Alternative Hypotheses
• p-value
• Testing the Mean

Day 8 - Relational Database Theory and Introduction to SQL

• Why should I use SQL?
• Why should I use MySQL?
• Creating Databases, Creating Tables
• Queries: Select, Delete, Import, Update
• Relational Schemas Concept: Primary Key

Day 9 - Tableau

• Introduction to Tableau
• Installation
• Functionalities
• Combining SQL and Tableau

Day 10 - Python

• Python Syntax and Variables
• Python Libraries
• Operators
• Conditional Statements
• Functions

Day 11 - Python Arrays

• Lists
• Methods
• Tuples
• Dictionaries

The training is open to institutional collaborations (package for institution/company legal entities), and individual applications are not accepted. The training content can be reorganized according to your institutional participant profile and needs. As a result of mutual discussions, the scope and method of the training (face-to-face / online) are determined and the relevant processes are completed. In case of mutual agreement, the date, time, and location of the training are planned in line with the availability of your institution’s participants and our instructors.