Data analysis with Microsoft Excel and Power BI

Category: MS OFFICE
Length: 3 days

Planning:


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.




Address: Bd. Decebal, nr. 18, ap. 2
310133 - Arad, jud. Arad, Romania
Phone: +40 357 805 456
E-mail: office@effectiveflux.com
You cand follow us on:
Access the latest information:
Terms and Conditions / Privacy Policy / Cookie Policy