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 (corporate/entity packages) and is not open for individual applications. The content of the training can be re-planned according to the institutional participant profile and needs. After mutual discussions, the scope of the training and the method (Face-to-Face or Online) will be determined, and the relevant processes will be completed. If an agreement is reached, the suitable days and times for the participants from your institution and our instructors, as well as the training location, will be determined.