Power-BI for
Business Professionals
This program is designed to guide you from basic to advanced concepts of financial analysis using Microsoft Power BI.
The program provides a comprehensive introduction to Power BI, including the installation of the desktop version and an overview of Power BI Service, focusing on report-sharing capabilities. It also covers both basic and advanced applications of DAX for creating complex calculations, as well as an in-depth exploration of various visualization types.
The final three weeks of the program are focused on developing comprehensive reports and dashboards, reinforcing all previously learned concepts. This phase is designed to deepen your understanding and enhance practical expertise in conducting financial analyses.
Mentor
- Introduction and expected outcomes
- Installing Microsoft Power BI Desktop
- Getting Familiar with Power BI Desktop
- Import Data from CSV, Excel and SQL Server files in Microsoft Power BI Desktop
- Modeling Basics
- Modeling and relationships
- Star Schema vs Snowflake Schema
- Calculated columns and creating Measures: when to use one versus the other
- Detailed overview of fundamental calculations in DAX and their applications, including Sum, Average, Min, Max, Divide, Count, and Calculate.
- Detailed overview of various types of visualizations, their applications, and formatting options.
- When to use a specific visualization for optimal data representation
- Solving practical examples from real projects
- Application of learned concepts in real-world scenarios.
- Creating various types of reports and dashboards:
Simple Sales Dashboard
HR Analytics Report
Sales Scorecard Report
Finance Dashboard Report
What If Analysis Report
Balance Sheet Report
Profit and Loss Report
Target audience group
Active proffesionals from the business world, that work with data.
Is prior knowledge required?
Basic knowledge of Excel formulas, use of financial statements: Balance Sheet, Income Statement, HR analytics, or specific tools for tracking progress.
In which language are the classes conducted?
This training is conducted entirely in Macedonian.
What is the concept of the classes?
In the classes, theory is explained and homework assignments are given, with their solutions discussed during the sessions. Experiences from projects on which students are working are shared, and possible solutions, best practices, and more are discussed.
More information about the trainer
Katerina Markoska – Graduated engineer in information science and technology and Data & Analytics Engineer at Qinshift.
Katerina Markoska has extensive expertise in data analysis using a variety of tools, including Microsoft Power BI. She holds a Microsoft certification as a Power BI Data Analyst Associate. Currently employed at Qinshift as a Data & Analytics Engineer, she is gaining experience across multiple projects in various industries. Katerina specializes in data analysis and visualization to facilitate informed decision-making for business advancement.
Power-BI for
Business Professionals
650 €
520 €
(advent price)
- 17.03.2025
- 36 classes
- 6 weeks
- online
- 2 / 3 times a week
- 17:30 – 20:30 h
Start
17.03.2025
No. of classes
36 classes
Duration
6 weeks
Schedule
17:30 – 20:30 h
This program is designed to guide you from basic to advanced concepts of financial analysis using Microsoft Power BI.
The program provides a comprehensive introduction to Power BI, including the installation of the desktop version and an overview of Power BI Service, focusing on report-sharing capabilities. It also covers both basic and advanced applications of DAX for creating complex calculations, as well as an in-depth exploration of various visualization types.
The final three weeks of the program are focused on developing comprehensive reports and dashboards, reinforcing all previously learned concepts. This phase is designed to deepen your understanding and enhance practical expertise in conducting financial analyses.
Mentor
- Introduction and expected outcomes
- Installing Microsoft Power BI Desktop
- Getting Familiar with Power BI Desktop
- Import Data from CSV, Excel and SQL Server files in Microsoft Power BI Desktop
- Modeling Basics
- Modeling and relationships
- Star Schema vs Snowflake Schema
- Calculated columns and creating Measures: when to use one versus the other
- Detailed overview of fundamental calculations in DAX and their applications, including Sum, Average, Min, Max, Divide, Count, and Calculate.
- Detailed overview of various types of visualizations, their applications, and formatting options.
- When to use a specific visualization for optimal data representation
- Solving practical examples from real projects
- Application of learned concepts in real-world scenarios.
- Creating various types of reports and dashboards:
Simple Sales Dashboard
HR Analytics Report
Sales Scorecard Report
Finance Dashboard Report
What If Analysis Report
Balance Sheet Report
Profit and Loss Report
Target group
Active proffesionals from the business world, that work with data.
Is prior knowledge required?
Basic knowledge of Excel formulas, use of financial statements: Balance Sheet, Income Statement, HR analytics, or specific tools for tracking progress.
In which language are the classes conducted?
This training is conducted entirely in Macedonian.
What is the concept of the classes?
In the classes, theory is explained and homework assignments are given, with their solutions discussed during the sessions. Experiences from projects on which students are working are shared, and possible solutions, best practices, and more are discussed.
More information about the trainer
Катерина Маркоска – Дипломиран инженер по информациски науки и технологии и Data & Analytics Engineer во Qinshift.
Katerina Markoska has extensive expertise in data analysis using a variety of tools, including Microsoft Power BI. She holds a Microsoft certification as a Power BI Data Analyst Associate. Currently employed at Qinshift as a Data & Analytics Engineer, she is gaining experience across multiple projects in various industries. Katerina specializes in data analysis and visualization to facilitate informed decision-making for business advancement.
