Online Training

Data Analytics For Business Decision Making

Learn how to make data-based decisions for your own business or the organization you’re working for by using data analytics and its visualization. By applying the right tools and the Data Masters methodology, you will gain knowledge that will help you make the right business decisions with a minimal error threshold.

Apply Now
Your Lecturers

Start date:

TBD

Duration:

16 weeks (91 hours)

Schedule:

Classes:

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

Workshop:

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

Consultations:

Two individual classes   (30 minutes)

Price:

Early Bird Price:
33.000 MKD

Regular Price: 
36.000 MKD

Training Description

Data Analytics for Business Decision Making is a powerful combination of SQL, Python, and Microsoft Power BI.

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

It continues with importing the data into a Python script and its analysis and manipulation.

In the third module, the same script is imported into Power BI, all to obtain a valuable report as a final product.

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
  • Loading, collecting, and analyzing data with Python
  • Data structures
  • Manipulating data structures
  • Python functions
  • Libraries for analysis and visualization

Data Visualization with Microsoft Power BI

  • Introduction to Power BI
  • Connecting Power BI to different data sources
  • 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
  • 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
  • Loading, collecting, and analyzing data with Python
  • Data structures
  • Manipulating data structures
  • Python functions
  • Libraries for analysis and visualization

Data Visualization with Microsoft Power BI

  • Introduction to Power BI
  • Connecting Power BI to different data sources
  • 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

Who is this training for?

This training is for you if you work with Excel and:

  • You manage budgets, create and delegate reports, project sales and revenue, and evaluate growth and costs

     

  • You want to upgrade your knowledge, improve your current career or start a new career working with data

     

  • You are a project manager
  • You work or own a business connected to marketing, importing/exporting goods, customs, transport, construction, healthcare, and manufacturing

  • You are a general/marketing/financial manager or head of a department

Student Testimonials

Vlatko Chubrinovski

“The general concept of the training, the creativity, the way of presenting the tools, and the knowledge-sharing structure, as well as the availability of the trainers for additional questions, significantly facilitates the possibility of mastering the material”.

Martin Martinoski

“The main attraction to the Data Masters Academy is their strict focus on Data Science. Specifically, this training (Data Analytics for Business Decision Making) was interesting to me because of the great combination of practical modules such as SQL, Python, and Power BI”.

Aleksandra Kocevska

"The training is conducted at a very high, professional level by all the lecturers from Data Masters. Each lesson is recorded, so that every participant has the opportunity to return to the material or rewatch a lesson or part of the lesson, to consolidate their knowledge."

Natasha Panovska

“The training curriculum is great for understanding and learning these tools (Python, SQL, Power BI) through interactive lessons. There is also an opportunity for additional exercises.”

Ana Sekulovska

“I would recommend Data Analytics for Business Decision Making for everyone that works with large databases and has to draw conclusions from that data”

Martina Isaieva

“This training completely facilitates my everyday work. I am able to restructure, upgrade and simplify the reports I do on a daily basis, and do the work more efficiently. This makes the overall operations more precise and the process is easy to understand.”

Our Goal is to Teach You How To:

  • 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
  • Use the benefits of digitalization to enhance your value in the company
  • Create relationships between different variables and databases and define their interdependence
  • 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

Take the First Step
Toward Your New Future