Excel: Create data models with Power Pivot
Excel: Create data models with Power Pivot
Deepen the capabilities of Power Pivot with this course, learning how to analyze and manage large volumes of data efficiently in Excel. Optimize your efficiency in the analysis of data and the creation of business models.
Specific goals | Temary
OBJECTIVES
- Master Power Pivot functionalities for data import and combination
- Learn to create and manage pivot tables and relationships between tables
- Develop skills to create measures using DAX (Data Analysis Expressions)
- Use Power Pivot to create interactive reports and dynamic visualizations
SYLLABUS
- Introduction to Power Pivot and its advanced functionalities
- Data import and combination from multiple sources
- Creation of pivot tables and relationships between tables with Power Pivot
- Creation of measures with DAX
- Creation of interactive reports and dynamic visualizations with Power Pivot
- Practical exercises to apply the learned concepts
- Discussion of specific use cases with Power Pivot
EXCEL POWER PIVOT LEARNING PATH
Level 0
Excel: Power Pivot - Online
Level 1
Excel: Create data models with Power Pivot
Editions
Mon 18/11/24 (16:00-19:00h)
Tue 19/11/24 (16:00-19:00h)
Wed 20/11/24 (16:00-19:00h)
Virtual classroom
Wed 11/12/24 (15:00-20:00h)
Thu 12/12/24 (15:00-20:00h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
General information
>> In case the format is virtual via streaming, it will be carried out through the free platform Microsoft Teams. Registered individuals will receive the invitation link and access instructions by email before the session starts.
>> Entry to the classroom will not be allowed after 15 minutes once the activity has started.
>> The language in which each session is conducted is informed in the description of each activity.
>> Any of the training actions of Cibernàrium may be recorded through an image capture system that aims to subsequently disseminate them through a medium or support within the scope of the mission of Barcelona Activa to contribute to economic promotion and employment. In the recording process, images of attendees may eventually be recorded. Registration for Cibernàrium activities implies authorization for Barcelona Activa to use these images for the aforementioned purpose.
Course ratings
Lesson taught by
FERRER ARNALDO
Related courses
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.