logo

DataBoom

8

AI Data Analyst (Power BI, SQL, Excel, Python, AI) Level 1 Junior (for beginners from scratch)

400 000 ₸
Submit application
Allocated 12 Quotas

About course

More on DataBoom

The 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.

Course details

level

For beginner

Study format

Online

Start

September

Entrance exams

No

Duration, in weeks

26

Duration in academic hours

347

Education language

Russian

Classes days_of_week

Mon-Sun

Teaching methodology

There are more practices than theories

Qualifications

Junior AI Data Analyst with Power BI, Excel, AI skills

Classes 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

Similar courses

Other courses from DataBoom