Microsoft Excel and Power BI

Objectives - at the end of the course the participants will be able to
• import and transform data from different sources, create and use data models and dashboards
• solve complex problems with Power Query and Power Pivot
• create reports and use Power BI data analysis elements

Target audience:
Personnel from production or service companies, involved in analysis and reporting - departments: quality, production, logistics, human resources, financial, etc.

Duration: 3 days

Agenda:
• Introduction
• Advanced Excel techniques
• Excel Data Model. Power Query. Dashboards
• Power BI Desktop - Reports
• Discussions. Examination. Closing the course

Presented tools:
Dynamic Array. Data Analysis. Use of different types of data, Power Query data transformation, M language, Data Model, relational system, Power Pivot, Data Analysis Expressions (DAX), Dashboards - case studies, Use of Power BI analysis tools

Note: Full practical course. Requires your own computer with Office 2016/2019/2021/Microsoft 365.
Power BI Desktop must be installed before the course.

Trainer:
He is certified as a Microsoft Certified Trainer (MCT) and has over 20 years of experience in professional training, consulting, and teaching activities in information technology.

For more information, please contact us.