Excel III 250312
The main objective is to provide users with advanced skills and
knowledge in Excel, especially those focused on data extraction and
processing, taking advantage of all the program's resources to increase
efficiency and effectiveness in daily tasks.
Instructor: David Monsó Morera, Pitagora Group
Power BI General 250306
The main objective of the course is to understand the different
elements inside Power BI, and their presence in MS Excel, with the
intention of having an overview of the tool to be able obtain reports
from raw data.
Topics that are going to be addressed:
· What is Power BI
· Elements in Power BI
· Power BI elements in MS Excel
· ETL: Extract, transform and loading data (Power Query)
· Relate Tables (Power Pivot)
· Pivot tables involving more than one table
· Graphics and dashboards in Power BI
· Different elements in a dashboard
Instructor: David Monsó Morera, Pitagora Group
Power BI Finance 250306
The main objective of the course is to understand the different
elements inside Power BI, and their presence in MS Excel, with the
intention of having an overview of the tool to be able obtain reports
from raw data.
Topics that are going to be addressed:
· What is Power BI
· Elements in Power BI
· Power BI elements in MS Excel
· ETL: Extract, transform and loading data (Power Query)
· Relate Tables (Power Pivot)
· Pivot tables involving more than one table
· Graphics and dashboards in Power BI
· Different elements in a dashboard
Instructor: David Monsó Morera, Pitagora Group