1.1. About Bootcamp
1.2. What is Data Analyst and Business Intelligence?
1.3. Data Types
1.4. Basic Statistics Concepts
1.5. Data Visualization and Reporting
Microsoft Excel, SQL and Tableau
Within 3 months, you can specialize in data analysis, business intelligence and reporting, and open the door to the data world.
Chapter 1: Data Analyst Basics
Chapter 2: Introduction to Microsoft Excel
2.1. Table Basics
2.2. Formula and Function Concepts
2.3. Basic Functional Operations
2.4. Advanced Functional Operations
2.5. Error Concept and Error Control
2.6. Sorting and Filtering
Chapter 3: Advanced Excel Applications
3.1. Data Cleaning
3.2. Conditional formatting
3.3. Data Verification
3.4. Data Visualization
3.5. PivotTable Operations
3.6. Report Dashboard Preparation
Chapter 4: Introduction to Tableau
4.1. About Tableau
4.3. Connecting to Data
4.4. Data Preparation
4.5. Creating Graphics
Chapter 5: Intermediate Topics in Tableau
5.1. Discrete and Continuous Concepts
5.2. Chart Types
5.3. Detail Level Concept, Group, Set and Hierarchy
5.4. Analytical Panel
Chapter 6: Tableau Advanced Level
6.2. Data Merge
6.3. Connecting to Different File Types
6.4. Advanced Statistics Calculations
6.5. Dashboard and Story Creation
Chapter 6: SQL Basics and MySQL
7.1. SQL and Data Access Methods
7.2. Introduction to Databases
7.3. MySQL Installation and Database Definition
7.4. SQL Basics
7.5. Clustering and grouping
7.6. Joins Cte Case
7.7. Writing a SQL Query in Tableau
7.8. MySQL for Excel
Project 1: Excel Project
Project 2: Tableau Project
Frequently Asked Questions
How does Bootcamp work?
You access the curriculum through our online platform (which will be available unlimitedly with updates to the curriculum). A data science mentor will be assigned for you. Your mentor plans how to follow the curriculum and follows you through two online audio/video conferences. In these conferences: You are reviewing the material you are working on that week. You ask the problems encountered in the lessons and you find solutions together. Your mentor sets weekly goals and motivates you to progress at the required pace for graduation and decide how to proceed.
How is the curriculum content?
A very comprehensive curriculum awaits you. A curriculum that encompasses all the basic techniques and concepts needed in today’s world. Application and practice is in the foreground. The curriculum consists of chapters and lot of courses within each chapter. At the end of each lesson, hands-on exercises will be waiting for you. At the end of the main sections, you will have projects to do.
What additional support is available outside the curriculum?
Every two months, we will be organizing workshops that bring you together with professional data scientists. So, you will be able to see what is going on in the business world and ask questions to professionals
Who can participate in the Bootcamp?
Anyone interested in Data Science can attend bootcamp. You don’t even have to have any coding knowledge before. Bootcamp starts by teaching you coding with Python. The only need is enthusiasm. Since you set the time you can study on Bootcamp, it doesn’t matter if you’re working somewhere. Working students prefer to study and interview with own mentor in the evenings and weekends. There is a similar situation for students.
Is Graduation guaranteed?
No it is not! Your projects and presentations will be evaluated, you may be asked to develop or redo them if necessary. You must complete the bootcamp within the specified time. This is a motivation element for you.