Data analysis with 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
• create reports and use data analysis tools
• solve complex data analysis problems

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
• Power Query, Data Model
• Power BI Desktop - Reports
• Power BI Pro - Dashboards, Mobile
• Data analysis tools
• Discussions. Examination. Closing the course

Presented tools:

Use of different data sources, 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

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.