COURSE NAME : BUSINESS ANALYTICS
SCOPE OF THE COURSE: This course covers he skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau, Python
REQUIREMENTS
- You’ll need to install MySQL, Tableau Public, and Anaconda. We will show you how to do it step by step
- Microsoft Excel 2003, 2010, 2013, 2016, or 365
|
DAY
|
TOPIC
|
|
DAY 1
|
INTRODUCTION
- Intro to Data and Data Science
- Dıfferent Data Science Fields
- Intro to Business Analytics, Data Analytics and Data Science
|
|
DAY 2
|
Business Analytics
- Business Analytics
- Data Analytics
- Data Science
- About Business Intelligence, Machine Learning and AI
|
|
DAY 3
|
Data and Data Science
- Traditional Data,
- Big Data,
- Traditional Data Science
- Machine Learning
- Data Science Field and Discliplines
|
|
DAY 4
|
Common Data Science Techniques
- Traditional Data
- Real-life Data Examples
- Big Data
- Big Data Technologies
- Traditional MErhods
- Machine Learning Techniques
|
|
DAY 5
|
Programming Languages and Common Data Sciene Tools
Data Science Career Paths
Statistics- Population and Sample
Descriptive Statistics
|
|
DAY 6
|
Inferential Statistics Fundamentals
- Distrubiton
- What is a Distribution
- The Normal Distribution
- The Standard Normal Distribution
- Central Limit Theorem
- Standard error
- Estimators and Estimates
Inferential Statistcics: Confidence Intervals
- What are Confidence Intervals?
- Confidence Intervals; Population Variance Known; z-score
- Confidence interval clarifications
- Student's T Distribution
- Confidence Intervals; Population Variance Unknown; t-score
- Margin of Error
- Confidence intervals. Two means. Dependent
- Confidence intervals. Two means. Independent samples
-
|
|
DAY 7
|
Statistics- Hypothesis Testing
- The Null vs Alternative Hypothesis
- Further Reading on Null and Alternative Hypothesis
- The Null vs Alternative Hypothesis
- Rejection Region and Significance Level
- Type I Error and Type II Error
- Test for the Mean. Population Variance Known
- p-value
- Test for the Mean. Population Variance Unknown
- Test for the Mean. Dependent Samples
- Examples
|
|
DAY 8
|
Relational Databases Theory & Introduction to SQL
- Why use SQL?
- Why use MySQL?
- Introducing Databases
- Relational Database Fundamentals
- Comparing Databases and Spreadsheets
- Important Database Terminology
- The Concept of Relational Schemas: Primary Key
- The Concept of Relational Schemas: Foreign Key
- The Concept of Relational Schemas: Unique Key and Null Values
- The Concept of Relational Schemas: Relationships Between Tables
SQL
- Install MYSQL
- Create Database
- Create Table
- Select, Delete, Import, Update Queries
- Functions
- JOINs
- Subqueries
- Stored Rutins
- Common Table Expressions(CTEs)
|
|
DAY 9
|
Tableu
- Introduction to Tableu
- Install
- Functionalities
- Combining SQL and Tableu
|
|
DAY 10
|
Python
- Python Syntax and Variables
- Python Libs
- Operators
- Conditional Statements
- Functions
|
|
DAY 11
|
Python Sequences
- Lists
- Methods
- Tuples
- Dictionary
|
The Process of Education:
-
The training will be broadcast live simultaneously over the Internet.
-
In order to participate in the training, you must have internet access and a suitable internet package in your current environment.
-
In order for the educational system to be used,camera and microphone equipment have been introduced, a device that can connect to the Internet(smartphone, tablet and preferably computer) is needed.
-
Participants will log in to the system with their cameras and microphones turned on together with our instructor who provides the training during the specified lesson hours.
-
User names and passwords will be sent to the participants' e-mails before the training starts.
-
After the trainings are completed, the system will be kept open for participants for another 7 days. By the end of the seventh day at 23:00, the system will be completely shut down.
-
In order to help us during the training period, a whatsapp group will be created in the form of sending messages only to the administrator, and all kinds of support information will be shared by the administrator during the lesson period. Participants have all kinds of questions and problems usem@uludag.edu.tr they can write to our address. The mail will be followed up instantly during the training.
Important Information:
-
Certificates are issued for participation of 80% and above of the total training period. for participation of 79% and below, no documents will be issued.
-
After the completion of the training period, certificates will be issued after the controls belonging to our institution and will be sent to the addresses you entered at the time of registration with PTT Cargo. Your address and contact information must be up-to-date.
-
Participants have all kinds of questions and problems usem@uludag.edu.tr they can write to our address. The mail will be followed up instantly during the training.
-
Application for education and paying the tuition fee are made via the Internet. Installment payments cannot be paid on the participants' bank credit cards.