
DataBoom
8
AI Data Analyst (Power BI, SQL, Excel, Python, AI) Level 1 Junior (for beginners from scratch)
400 000 ₸About course
More on DataBoomThe course prepares specialists with a full stack of skills to start in IT, marketing, finance, and management. You will learn how to collect, process, and analyze data in Excel and Power BI, write SQL queries to databases, automate analysis using Python, and apply basic AI techniques. The program is based on real cases: customer segmentation, report building, sales funnels, forecasting. Suitable for those who want to start a career from scratch and reach the junior level in 6 months.
Special condition
Guarantee fee in the amount of 100,000 tenge. No later than 7 (seven) working days before the start of training under the Agreement, the Student is obliged to make a deposit in the amount of 100,000 (one hundred thousand) tenge to the current account of the School specified in the Agreement. The deposit is returned to the Student within 10 (ten) working days after the successful completion of his studies under the Agreement.
level
For beginnerStudy format
OnlineStart
SeptemberEntrance exams
NoDuration, in weeks
26Duration in academic hours
347Education language
RussianClasses days_of_week
Mon-SunTeaching methodology
There are more practices than theoriesQualifications
Junior AI Data Analyst with Power BI, Excel, AI skillsClasses format
Online lessons 2 times a week for an hour and pre-recorded video assignments 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
TechOrda #1. AI DATA ANALYST (Power BI, SQL, Excel, Python, AI) Level 1 Junior (for beginners from scratch) consists of 5 modules, the purpose of which is to teach the student from scratch the basic key and most popular skills in the field of data analysis, taking into account modern ways to simplify and speed up work with AI. 1. EXCEL FOR DATA ANALYSIS WITH THE HELP OF AI: from scratch learn to work with formulas, pivot tables, visualizations and build a dashboard in Excel. It is no secret that Excel is in demand in almost all areas, it is modern literacy (like the ability to read and write). This module is aimed at studying the basics and advanced capabilities of Excel for data analysis. In this module, you will create a mini project - your first dashboard in Excel 2. POWER BI FOR DATA ANALYSIS WITH AI: learn how to create dashboards on key metrics yourself from scratch, learn how to connect analytical data studies from a variety of sources PDF, CSV, Excel files, SQL, Google Sheets and many others. Learn what Power Query, ETL, M language and DAX are. Learn how to independently collect, analyze, visualize and present business-critical data. In this module, you will defend a personal project that will become part of your portfolio. As part of the PowerBI training, you will also master all the methods and tricks based on AI that simplify work within PowerBI. 3. SQL FOR DATA ANALYSIS WITH AI: SQL has been popular since the 1970s and is found in all vacancies related to data analysis. Having learned SQL, you will be able to create, edit, update databases and download information for further analysis. As part of this module, you will undergo technical interviews twice a week, which will prepare you for further employment, because the probability that you will be asked SQL tasks at an interview for an analyst position is close to 100% 4. PYTHON FOR DATA ANALYSIS WITH AI: PYTHON is the #1 programming language for Data Science, Machine Learning, Deep Learning, Artificial Intelligence. In this module, you will master the basics of Python programming, as well as the basics of data processing and analysis using specialized libraries for analytics: Pandas, Numpy and others. 5. ARTIFICIAL INTELLIGENCE (NEURAL NETWORKS) FOR DATA ANALYSIS: you will master the basics of AI and implement 2 mini-projects using computer vision (Computer Vision), natural language processing (Natural Language Processing) using Microsoft Azure services.
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 500 000 tenge per person. If the tuition costs up to 500,000 tenge, the tuition fee is fully covered by the Program. If the cost exceeds 500,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-2024 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
Other courses from DataBoom