logo

DataBoom

8

Financial AI-Data Analyst: Data & AI (Excel, Power BI, AI) Level 1 Junior (for beginners from scratch)

400 000 ₸
Submit application
Allocated 10 Quotas

About course

More on DataBoom

The program is designed for future BI analysts, accountants and financial specialists who want to move from Excel reports to automated BI systems. You will learn Excel as a basic calculation tool, master Power BI for visualizing financial metrics and building dashboards, and also learn how to collect reports from 1C. Graduates will be able to quickly process data sets, collect budgets, P&L and other financial reports, and automate regular reporting.

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 Financial 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 #2. FINANCIAL AI DATA ANALYST: DATA & AI (Excel, Power BI, AI) Level 1 Junior (for beginners from scratch) consists of 3 modules, the tasks of which are: 1. EXCEL FOR DATA ANALYSIS WITH 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. Within this module, you will make a mini project - your first dashboard in Excel. Master Excel from scratch to an advanced level. 2. POWER BI FOR DATA ANALYSIS WITH AI: learn how to create dashboards for key metrics yourself from scratch, learn how to connect analytical data studies from a variety of sources PDF, CSV, Excel files, SQL, Google Sheets, etc. You will learn what Power Query, ETL, M language and DAX are. Learn how to independently collect, analyze, visualize and present business-critical data. As part of 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. Master PowerBI from scratch to an advanced level. 3. POWER BI for accountants and financiers: financial reporting in PowerBI based on data from 1C: from scratch we will master unloading from 1C, construction, visualization and automation of all three financial reports DDS, OPUIU, Balance.

FAQ

Similar courses

Other courses from DataBoom