This training is for professional development purposes, and the certificate obtained does not replace the MYK authorization certificate required in trainings where it is mandatory.

Learning Outcome of the Training

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

Training Content

You need to install MySQL, Tableau Public and Anaconda. We will show you step by step how to do it. Microsoft Excel 2003, 2010, 2013, 2016 or 365 is required.

• DAY 1: Introduction, Introduction to Data and Data Science, Different Data Science Fields, Business analytics, Introduction to Data Analytics and Data Science

• DAY 2: About business analytics, Data Analysis, Data Science, Business intelligence, machine learning and artificial intelligence

• DAY 3: Data and Data Science, Traditional Data, Big Data, Traditional Data Science, Machine Learning, Data Science Field and Discrete Lines

• DAY 4: Common Data Science Techniques, Traditional Data, Real Life 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 Sample, Descriptive statistics

• DAY 6: Fundamentals of Inferential Statistics, Distribution, What is Distribution, Normal Distribution, Standard Normal Distribution, Central Limit Theorem, Standard error, Estimators and Estimates, Inferential Statistics: Confidence Intervals, What are Confidence Intervals?, Known Population Variance, z-score, Confidence interval explanations, Student's T Distribution, Unknown Population Variance; t-score, Margin of Error, Dependent and Independent samples

• DAY 7: Statistics- Hypothesis Testing, Null and Alternative Hypothesis, Rejection Region and Significance Level, Type I Error and Type II Error, Testing the mean, p-value, Dependent Samples, Examples

• DAY 8: Relational Database Theory and Introduction to SQL, Why should I use SQL?, Why should I use MySQL?, Introduction to Databases, Fundamentals of Relational Databases, Comparison of Databases and Spreadsheets, Important Database Terminology, Relational Schemas: Primary Key, Foreign Key, Unique Key and Null Values, Relationships between Tables, SQL, Install MySQL, Create Database, Create Table, Select Queries, Delete, Import, Update, Functions, Subqueries, Stored Procedures, Common Table Expressions (CTEs)

• 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, Dictionary

Training Process

• The training will be broadcast live over the internet.

• Participants must have internet access and suitable devices.

• Cameras and microphones must be turned on during the lessons.

• Username and password will be sent via e-mail before the course starts.

• The system will remain open for 7 days after the course ends.

• Only the administrator will send messages in the WhatsApp group and share support information.

• For all questions and issues: usem@uludag.edu.tr

The training is open to corporate collaboration (institution/company legal entity packages), and individual applications are not accepted. The training content can be reorganized according to your corporate 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 agreement, suitable dates and times for your institution’s participants and our instructors, as well as the training location, are determined.