logo

DataBoom

8

AI Data Analyst (Power BI, SQL, Excel, Python, AI) Level 2 Middle (for continuing students)

400 000 ₸
Submit application
Allocated 10 Quotas

About course

More on DataBoom

The course is for those who have already mastered basic analytics and want to improve their skills. Advanced Excel includes arrays, macros, and dashboards. In Power BI and SQL, you'll learn how to optimize queries, build complex data models, and combine sources. In Python, you can work with the Pandas, NumPy libraries, and visualizations. The AI block will help apply machine learning to real business problems. Suitable for analysts who want to move to the middle level and increase their value in the market.

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

Для повышения квалификации

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

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

Classes format

Уроки в онлайн-режиме 2 раза в неделю по часу и предзаписанные видео задания на платформе, office hours: постоянная связь с личным наставником сертифицированным Microsoft,карьерные консультации с HR раз в неделю по часу.

Skills


TechOrda #3. AI DATA ANALYST (Power BI, SQL, Excel, Python, AI) Level 2 Middle (for continuing students) consists of 5 modules, the purpose of which is to teach the student from scratch the advanced use of key and most in-demand skills in the field of data analysis, taking into account modern ways to simplify and speed up work with AI. 1. ADVANCED EXCEL FOR DATA ANALYSIS WITH AI: the student will learn to analyze and visualize data in Excel using advanced AI tools and capabilities (Copilot), including automatic generation of formulas and building analytical dashboards. He will also master working with Power Query and Power Pivot add-ins - from connecting and transforming data to creating calculations in the DAX language. 2. ADVANCED POWER BI FOR AI-POWERED DATA ANALYSIS: The student will learn advanced data processing in Power Query and build complex analytical models using DAX, including aggregations, filtering, ABC analysis and many-to-many relationships. They will also master visual storytelling in Power BI, apply AI to improve visualizations and present a final project ready for inclusion in a professional portfolio. 3. ADVANCED SQL FOR AI-POWERED DATA ANALYSIS: The student will master advanced SQL tools: window functions, conditionals, text manipulation, views, indexes, procedures, functions and triggers - all with a focus on real-world use cases and performance. They will also undergo regular technical interviews to confidently solve analyst tasks during interviews and successfully pass the final oral exam. 4. ADVANCED PYTHON FOR DATA ANALYSIS WITH AI: the student will master in-depth work with Pandas: from creating, filtering and combining tables to grouping, data visualization and business cases (for example, churn analysis). He will also study regular expressions, the basics of AI and work with Azure Cognitive Services - including speech generation, text translation and interaction with API. 5. ADVANCED ARTIFICIAL INTELLIGENCE (NEURAL NETWORKS) FOR DATA ANALYSIS: the student will master key areas of artificial intelligence: computer vision, natural language processing (NLP), text generation via Azure OpenAI and automated learning with Azure ML. He will learn to apply these technologies in real cases and complete the course by creating and defending his own AI project.

FAQ

Similar courses

Other courses from DataBoom