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.
![](https://academy.datamasters.ai/wp-content/uploads/2022/12/bdm-cover-person-new.png)
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
![](https://academy.datamasters.ai/wp-content/uploads/2022/12/vlatko-chubrinovski.png)
Vlatko Chubrinovski
![](https://academy.datamasters.ai/wp-content/uploads/2022/12/martin-martinoski.png)
Martin Martinoski
![](https://academy.datamasters.ai/wp-content/uploads/2022/12/aleksandra-kocevska.png)
Aleksandra Kocevska
![](https://academy.datamasters.ai/wp-content/uploads/2022/12/natasa-panovska.png)
Natasha Panovska
![](https://academy.datamasters.ai/wp-content/uploads/2022/12/ana-sekulovska.png)
Ana Sekulovska
![](https://academy.datamasters.ai/wp-content/uploads/2022/12/martina-isaieva.png)
Martina Isaieva
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