DataBoom
Bootcamp: Big Data analysis and work (Power BI, SQL, Excel,AI)
598 000 ₸About course
More on DataBoomA module for data analysis and visualization in Microsoft PowerBI. Building visualizations using the DAX language, the M language and advanced Power Query. You will learn how to create dashboards for key metrics on your own, learn how to connect analytical studies of data from a variety of sources: PDF, CSV, Excel files, SQL, Google Sheets, and many others.You will be able to independently collect, analyze and present important business data, create your own visual interactive personal project and learn how to think like an analyst.A module on databases and SQL language based on Microsoft SQL Server. Creating databases from scratch using DDL, learning subsets of DML, DCL, TCL. Window functions and CTE. You will learn how to structure data and extract the necessary information, create, edit, update databases and upload information for further analysis. Excel module from scratch to PRO using Power Query and Power Pivot. You will learn how to work with formulas, reports, sorting, filtering and data visualization from scratch. This module is aimed at understanding the processes and using the advanced features of the program, which will significantly increase your productivity.AI Module: you will master the basics of AI and implement 5 mini-projects using Computer Vision, Natural Language Processing and of course GhatGPT (Azure OpenAI) using Microsoft Azure services. This module is aimed at understanding workloads: computer vision in Azure, the features of artificial intelligence, the functions of AI-generated workloads in Azure, the features of natural language processing (NLP) in Azure and the basic principles of machine learning. Discover the basic concepts of the cloud and learn how to implement Azure AI services in client applications.The course includes preparation for Microsoft certification in all the modules listed above.
Special condition
Гарантийный взнос в размере 100 000 тг. В срок не позднее 7 (семь) рабочих дней до начала обучения по Договору, Студент обязан внести депозит в размере 100 000 (сто тысяч) тенге на расчетный счет Школы, указанный в Договоре. Депозит возвращается Студенту в течение 10 (десяти) рабочих дней после успешного завершения им обучения в рамках Договора».
level
For allStudy format
OnlineStart
SeptemberEntrance exams
NoDuration, in weeks
31Duration in academic hours
434Education language
RussianClasses days_of_week
Mon-FriTeaching methodology
There are more practices than theoriesQualifications
Junior Data AnalystClasses format
Online webinar 1 time per week (SAT) for an hour and pre-recorded video tasks on the platform, office hours: constant communication with a personal mentor certified by Microsoft,career consultations with HR once a week for an hour.Skills
Learn to analyze and visualize data
Create and manage databases
Build interactive dashboards
Skills in creating combinations using complex formulas
Ability to work with four tools essential for big data analysis: PowerBI, SQL, Excel, AI.
Learn to pass technical interviews and more. Also, add 2 final projects and 1 personal project to your portfolio.
FAQ
-
What is the Tech Orda program?
-
Tech Orda is a human capital development program in the field of IT. The program provides subsidized tunding for the training of IT specialists in private schools of the Republic of Kazakhstan.
-
-
Where will the selection of candidates for training take place?
-
Acceptance and processing of applications will take place at the showcase of IT schools at astanahub.com portal.
-
-
What are the requirements for candidates?
-
The basic requirements for candidates include citizenship of the Republic of Kazakhstan and the age limit from 18 to 45 years. Additional requirements depend on the IT-school / IT-company and the course you choose. It is mandatory to read all the conditions before applying for training.
-
-
How much does the training cost?
-
The amount of financing is 600 000 tenge per person. If the tuition costs up to 600,000 tenge, the tuition fee is fully covered by the Program. If the cost exceeds 600,000 tenge, the remainder of the cost needs to be covered by the student himself.
-
-
How long does the quota training under the Tech Orda program last?
-
The training will take place from 6 months or more, depending on the Course and the IT-school you plan to enroll in.
-
-
How many IT schools participate in the program?
-
The list of all IT schools is available on the showcase of IT schools at astanahub.com portal.
-
-
How many applications can I submit?
-
Candidates can only apply for 5 (five) Participants of the Program.
-
-
How many scholarships/quotas can a candidate receive under the Program?
-
The candidate can only study 1 (one) once within the framework of the Program. There is one exception: A student can get training in 2 (two) Courses during the duration of the Program, only provided that one takes Courses that are pre- and post-prerequisites to each other from the same Participant of the Program (IT school/IT company). For example, if you first study for a Junior Web Developer at School X in 2023 and then apply for a Middle Web Developer at the same school X in 2024.
-
-
Can a student who has completed a quota training under the Program in 2023 apply again?
-
A student can get training in 2 (two) Courses during the duration of the Program, only provided that one takes Courses that are pre- and post-prerequisites to each other from the same Participant of the Program (IT school/IT company).
-
-
If I studied with a Program Participant in 2023 (IT schools/IT companies), but was on the waiting list, can I apply now?
-
Yes, you can. However, we recommend that you contact the Program Participant (where you have completed education) to confirm your status on the waiting list within the Program.
-
-
Is there an opportunity for a student to transfer from one IT school to another, which is also a Participant of the Tech Orda program?
-
As soon as the candidate confirms his choice to apply for a grant at a certain IT-school, there is no possibility to transfer to another school. Therefore, we strongly recommend that you consider all available options before making a decision on accepting/rejecting a grant within the framework of the Program.
-
-
Should Candidates who have received a quota work out after training?
-
No, such counter obligations are not provided for by Astana Hub. Other conditions may be regulated in the contract between the IT-school and the student.
-
-
Can I opt out of studying during the learning process? Is there a penalty if I don't complete the training?
-
The conditions depend on the specific IT school/IT company you choose. In the school card on the showcaseof IT-schools at astanahub.com portal, there is a special 'Special conditions' section where this information can be indicated. Also, we recommend that you contact the IT school directly and find out about all the terms of the contract.
-
-
Can I study at the same time in an IT-company (EPAM) and an IT-school as part of the Program?
-
No, within the framework of the Program, you can study at only one IT-school or IT-company.
-
Similar courses