Hybrid Training

Data Analyst Training

This training helps individuals learn how to make more effective and efficient data-based decisions.

Make use of Data Masters’ expertise and gain valuable analytical and visualization skills that will facilitate your daily work.

Apply Here

Your Lecturers

Start:

September 2024

Duration:

16 weeks (91 hours)

Schedule:

Two classes per week
(17:30-20:00)

Workshops:

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

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.

At this training, you will gain experience through the workshops, where you will apply the data analysis techniques you learned in the classes to scenarios from real-life projects. You will work with data sets adjusted for making business decisions or performing financial analysis, enabling you to acquire skills you can apply directly in your field.

Modules

Introduction to SQL

Introduction to databases
Introduction to MS SQL Server
Creating and importing spreadsheets
Sending queries to the database
Transforming and interpreting results
Merging tables by key
Selecting columns
Filtering rows
Aggregate functions
Sorting and grouping
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
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 different interactive visualizations
Executing Python scripts directly in Power BI

Introduction to SQL

Introduction to databases
Introduction to MS SQL Server
Creating and importing spreadsheets
Sending queries to the database
Transforming and interpreting results
Merging tables by key
Selecting columns
Filtering rows
Aggregate functions
Sorting and grouping
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
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 different interactive visualizations
Executing Python scripts directly in Power BI

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

Banking
Corporate Finance
Financial Consulting
Accounting
Insurance
Investment Funds
Audit or Supervision
Actuarial Science

Budgeting
Creating and Delegating Reports
Sales and Revenue Projection
Growth and Cost Evaluation
Project Management
A Business in the Marketing, Import/Export, Customs, Transport, Construction, Healthcare, and Manufacturing Fields

Academy Students

0 +

Student Domains

0 +

Successful Career Switches and Upgrades

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

„This 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:

Use new technologies whose application in day-to-day operations is a necessity as a result of digital transformation
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
Connect the performance and the potential of a company to facilitate data-based decision-making
Analyze and interpret unprocessed piles of information and facts from everyday work
Create relationships between different variables and databases and define their interdependence

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

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