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.

Apply Here

Your Lecturers

Start:

TBD

Duration:

16 weeks (91 hours)

Schedule:

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

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

Consultations:

Two individual classes (30 minutes)

Price:

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.

Modules

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

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 in directly 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

Dimitar Karapanchev

“Personally, working together with other students helped me with learning the new material, especially when we had an opportunity to complement our solutions”.

Katerina M. Sarkisian

“It was a great pleasure and a real challenge to successfully complete the training and to learn the material, as well as implement it in practice”.

Elena Gligorova

“I really like that the classes are interactive and they combine the theoretical part with self-initiative task solving".

Matej Bojchev

“The advantage of the online lectures is that I can follow them from any location I’m currently at. Meanwhile, all the materials are recorded and available at any time”.

Nikolina Tashevski

„The DAF training is the perfect choice for anyone that wants to extract conclusions from the current situation and make plans based on the data they are working with.“

Ivana Todorovska

“I had no prior knowledge of the tools included in the modules, but the lectures are adapted in a way that is easy to understand and easy to learn.”

Nebojsha Antic

“The lecturers conveyed the knowledge clearly and simply and helped me to improve the knowledge I already possess."

Our Goal is to Teach You How To:

Analyze and interpret unprocessed piles of information and facts from everyday work
Independently use Python and SQL for data manipulation in your company/organization
Independently create reports in Power BI for full automation and apply calculated indicators
Create relationships between different variables and databases and define their interdependence
Use new technologies whose application in day-to-day operations is a necessity as a result of digital transformation
Connect the performance and the potential of a company to facilitate data-based decision-making

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