Microsoft Excel - Business Intelligence

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 data analysis tools

Target audience:

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

Duration: 2 days

Agenda:

• Introduction
• Advanced Excel techniques
• Excel Data Model
• Power Query. Power Pivot
• Dashboards
• 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

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.