Online Training

Data Analytics in Finance

Training for effective and efficient financial decision-making using SQL, Python, and Power BI. Learn from the Data Masters experts and acquire analytical skills to facilitate your everyday work.

Play Video




16 weeks (91 hours)


Two times a week (17:30-20:00)

Every other Friday (17:30-20:00)


Two individual classes (30 minutes)


Early Bird Price:

36.000 MKD

Regular Price:

39.000 MKD

Training Description

The training begins with an introduction to data types in MS SQL Server and learning the syntax for creating, updating, and deleting data.

It continues with reading, understanding, analyzing, and preprocessing the same data in Python. 

The training is completed with a descriptive visualization of the performed analyses in Microsoft Power BI.


Introduction to SQL

  • Introduction to databases
  • Introduction to MS SQL Server
  • Creating and importing spreadsheets
  • Query requests
  • Transforming and interpreting results
  • Merging tables by key
  • Selecting columns
  • Filtering rows
  • Aggregate functions
  • Sorting and grouping data
  • ETL (Extract, Transform, Load)

Data Processing with Python

  • Introduction to Python programming
  • Data types
  • Uploading, collecting, and analyzing data  with Python
  • Data structures
  • Manipulating data structures
  • Python functions
  • Libraries for analysis and visualization

Data Visualization with Microsoft Power BI

  • Using the Power BI tool for data visualization
  • Understanding Power BI Desktop and its components
  • Connecting Power BI to different data sources
  • Data models
  • Working with different data model views
  • Combining graphs in a dashboard
  • Creating calculated columns and metrics
  • Building relationships between different tables
  • Creating a report with multiple interactive visualizations
  • Executing Python scripts directly in Power BI

Who is this training for?

Data Analytics in Finance is for everyone who works with product profitability reports, employee performance, determining credit risk, term structures, indicators for bank liquidity, profitability and efficiency, analysis of interest rate movements, analysis of payment systems, and many other tasks. 

If Excel is your main tool, you have the possibility to use the Data Masters expertise to gain analytical and technical skills that will significantly facilitate your work.

This training is for you if you work in/have knowledge of:

  • Banking
  • Corporate Finance
  • Financial Consulting
  • Accounting
  • Insurance
  • Investment Funds
  • Audit or Supervision
  • Actuarial Science
  • Evaluating stock market performance
  • Work with Excel files and reports
  • Creating strategies for banks and financial institutions
  • Making data-based decisions
  • Making calculated decisions about risk prediction
Number of students that completed the training
0 +
Domains of our students
0 +
Students who successfully made a career change
0 +

Student Testimonials

Our Goal is to Teach You How To:

Martina Naumovska, co-founder of the Academy and partner at Data Masters

„From our experience so far, everyone who decided to make a change in their lives and career did not regret their decision. Investing in yourself and your future is the best gift you can give yourself. We as Data Maters are ready to selflessly transfer our knowledge and guide our students to achieve their goals.“

Case Study

As part of the training, we covered different types of financial case studies. One of them is the following:

Interest rate movement by product (car loans, housing loans, consumer loans) over different time periods

Loans that have been liquidated early (according to the current balance and years of repayment)

Participation of products in the credit portfolio in different periods

Credit risk exposure analysis

Credit portfolio performance in a given period of time

Quality and value of collaterals

Diversification of the portfolio according to customer segmentation (job position, experience, residence)

Relations between collateral value and other variables

Collateral risk assessment

Calculating net interest income for different time intervals

Take the First Step
Toward Your New Future