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.
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/obukanew1.png)
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
Student Testimonials
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/dimitar-karapanchev.png)
Dimitar Karapanchev
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/katerina-m.-sarkisian.png)
Katerina M. Sarkisian
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/elena-gligorova.png)
Elena Gligorova
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/matej-bojchev-.png)
Matej Bojchev
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/nikolina-tashevski.png)
Nikolina Tashevski
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/ivana-todorovska.png)
Ivana Todorovska
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/nebojsha-abtic.png)
Nebojsha Antic
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
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.“
![](https://academy.datamasters.ai/wp-content/uploads/2020/04/martina-naumovska-1.png)
Examples of Case Studies Included in the Training
Creating a Dashboard for Credit Portfolio Analysis
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/noun-interest-rate-3409410.png)
Interest rate movement by product (car loans, housing loans, consumer loans) over different time periods
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/noun-loan-term-4316552-01.png)
Loans that have been liquidated early (according to the current balance and years of repayment)
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/noun-portfolio-5315134.png)
Participation of products in the credit portfolio in different periods
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/noun-risk-5305998.png)
Credit risk exposure analysis
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/noun-performance-1584276.png)
Credit portfolio performance in a given period of time
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/noun-mortgage-197162-01.png)
Quality and value of collaterals
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/noun-clients-3311338.png)
Diversification of the portfolio according to customer segmentation (job position, experience, residence)
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/noun-shield-5244891.png)
Relations between collateral value and other variables
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/erer.png)
Collateral risk assessment
![](https://academy.datamasters.ai/wp-content/uploads/2022/11/noun-loan-term-1.png)
Calculating net interest income for different time intervals
Creating a Dashboard for Wholesale Business Analysis
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/ucestvo-na-produkti-vo-razlicen-period-01.png)
Participation of products in the total portfolio across different time periods
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/trendovi-na-prodazba-01.png)
Correlation between sales trends and other variables
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/predviduvanje-na-kupovnata-mokj-01.png)
Forecasting client purchasing power
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/uvid-vo-zalihi-01.png)
Constant product inventory monitoring
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/odrduvanje-popusti-za-razlicni-kategorii-01-done.png)
Determining discounts for different procurement categories
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/maksimiziranje-na-profitabilnosta-01-01.png)
Maximizing the profitability of a wholesale company
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/popusti-vrz-bruto-profit-01-01.png)
Gross profit monitoring by month, product, and region
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/sledenje-na-zalihi-01-done.png)
Monitoring inventory and its life cycle in real-time
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/provite-niz-mesec-po-produkti-i-regioni-01.png)
Discount distribution by categories and their effect on gross profit
![](https://academy.datamasters.ai/wp-content/uploads/2024/03/kpi-na-performans-01.png)
Product KPIs (Key Performance Indicators)
Take the First Step
Toward Your New Future