Academy for Data Analysis with Python, SQL & Power BI
+ (Excel & Cloud Computing)

Start: 14-November 2024

Duration: 5 months

650 EUR (up to 8 installments)

SQL | Python basics | Data Analysis Python | Power BI

BONUS MODULES: Excel for Data Analysis & Cloud Computing

Monday and Thursday (18.00 - 21.00)

Class: Online(Zoom)

Fill out the short form, and our team will contact you soon.
Pay online
If you have any questions or need consultations, click the 'Contact Us' button for a phone call.
Contact Us

Testimonials from previous students

Andrijana Jovanova

What helped me the most during the learning process were the 'real-life' examples that were constantly shared, as well as the homework where I could identify gaps in my knowledge.

Ivana Vicentijevikj

My experience with the academy is excellent! The instructors are fully dedicated to their work, and every class is maximally productive, with everything being taught during the lessons.

Vasko Stojanoski

The instructor creates a pleasant working atmosphere every class; I never felt uncomfortable asking a question because every question was answered without any issue, and no one ever felt embarrassed. Additionally, the coordinator is always there to ensure everything runs smoothly.

Program

I Module: Excel in Data analysis

  • VLOOKUP, INDEX/MATCH, Statistical functions
  • Pivot tables, Data validation, conditional formatting

II Module: SQL

  • Intro to Databases
  • Types of Databases
  • Joins
  • Grouping
  • Reports

SQL Advanced Concepts: Subqueries, window functions, and performance optimization tips

III Module: Python & Data Analysis Python

  • Intro Python
  • Types of Data
  • Structures
  • Intro to Python libraries for data analysis
  • Numpy
  • Pandas
  • Basic functions
  • Cleaning Data
  • Visualizing data

IV Module: Cloud

  • Introduction to Cloud
  • Computing
  • Cloud Storage
  • Basics of Virtual Servers
  • Cloud Databases
  • Basics of Data Warehouses
  • Building Data Pipelines with Azure Data Factory

V Module: Power BI

Data Preparation:

  • Using different data sources
  • Clean, Transform, and Load
  • Data Modeling:
    *Design the model
    *Calculation using DAX
  • Data analysis and visualization:
    *Creating reports
    *Enhancing Reports
    *Deep dive to data
    *Deploying and maintaining

Meet the instructors

Teodora has over 7 years of experience in financial and data analysis.

Expertise in: MS Power BI, SQL, Python, Machine Learning, and Advanced Excel.

Teodora Zivkovikj

Business Intelligence Specialist

LinkedIn

Nenad Ristov

Python Developer & Data Engineer

nenad-ristov
LinkedIn

Nenad is a programmer with extensive experience. He has vast knowledge in Python and JavaScript, the latest technologies for Web Development like Django, Flask, React, cloud platforms such as AWS and Google Cloud Platform, SQL and No-SQL databases. He describes himself as ambitious, adventurous, an adrenaline junkie, and a lifelong learner.

Nenad will ensure that you master the Python programming language from the very beginning all the way to working independently and handling complex tasks.

Registration

To apply for this course, you need to fill out the short form by clicking the APPLY button, or you can contact us directly at the phone number 077 648 049.

Once we receive your application, our team will contact you shortly after by phone, Viber, or email to cover all the important points you’re interested in regarding joining the group and starting the course.

PAYMENT

  • Installment payment without interest to our company’s account
  • Full payment directly to our company’s account
APPLY NOW
CONTACT US

A FEW IMPORTANT POINTS:

Start:

Novemeber 2024

Duration:

5 months

Schedule:

Monday and Thursday - 18.00-21.00

Price:

650 EUR (8 installments)