Canvas Logo

[COURSE] DATA MANAGEMENT WITH ADVANCED TOOLS

Atenció!
Activitat anul·lada
Aimed at:

Heads or department directors of any business sector (Technical Office, Purchasing, Sales, Logistics, Operations, Manufacturing, etc.). Self-employed and any professional who wants to base their strategic decisions on the analysis of real data of their department or company.

Dates: From May 21 to June 18 (Thursday)
Schedule: From 4 pm to 8 pm
Attendees: 6/25
Duration: 20 hours

Programming:

 

 

 

 

PivotTables and PivotCharts

  • Create PivotTables
  • Field settings
  • PivotTable options
  • Insert data segmentation
  • Insert time scale
  • Filter connections
  • Dynamic chart report
  • Relate tables and dynamic graphs
  • Generate a dynamic "Dashboard" for data presentation
  • Case studies.

    Data analysis with Power Query

  • Introduction
  • The source of data
  • Create the query
  • Working with Power Query
  • Power Pivot and Power BI
  • Update data
  • Queries with parameters
  • Case studies

     

    Manage data with Power Pivot

  • The data model
  • Prepare queries for Power Pivot
  • Manage the data model with power pivot
  • Create relationships between tables
  • Insert PivotTable
  • Create calculated measures and columns
  • Create KPIs
  • Case studies

Documentation: The documentation will be available on the platform between 24 and 48 hours before the start of the training. In the event that there is additional documentation after the training, we will provide it later.
Certification: Once the training action has been completed, students will obtain a certificate of attendance which can be downloaded to the platform.
Targets:

Excel, in addition to being one of the most popular applications from Microsoft, is for the knowledgeable professional, a tool that offers great possibilities in the field of data analysis. We will discover which are these tools incorporated in Excel since the 2016 version. The aim of the course is to learn how to efficiently develop all these tools and adapt them to professional use within each of the company's departments. Numerous case studies will be presented that will be solved as the knowledge acquired progresses.

Bonuses: We manage the procedures so that you can benefit from the corresponding training bonus.
Instructions for bonuses:

1. Request the forms from CETIT at formacio@enginyerstarragona.cat

2. Provide all information 10 calendar days before the start of the course.

3. IMPORTANT NOTE: bonuses are carried out through an external consultancy. Those who want to take advantage of the bonus for any training action, the price will be increased by 20% (which can also be discounted and recovered).

Conditions:

Cancellation of registrations:

Depending on the registrations made, the training action will be viable or not, which is why it is important that you notify the cancellations.

The cancellation must be communicated 48 hours before the start of the training via email formacio@cetit.org, if 100% of the amount of the training action will not be invoiced.

Images and recording of the course: we inform you that, in compliance with the provisions of the RGPD, the current legal regulations on data protection and Law 1/1982 on civil protection, the right to honor, personal and family privacy and the image itself, photographs will be taken during the course and in certain cases will be recorded and / or broadcast live. In no case will the name of the Interested Party be published. The image is used legitimized by the legitimate interest of the College to promote these courses and their possible subsequent viewing by attendees.

Due to attendance, these images will be kept and while the course is posted on the platform. Once the time has elapsed to be able to view it later, it will no longer be uploaded to the platform and the images will be deleted with the appropriate security measures.

You also have the right to request access, rectification, portability and deletion of your data and the limitation and opposition to its processing by sending an email to dpd@cetit.org. For more information on data protection rights, access our website: http://www.enginyerstarragona.cat/home/article/privacitat.

Speakers

  1. JOSEP ROMERO Enginyer Tècnic Industrial Mecànic. Consultor en gestió de dades a empreses industrials multinacionals, principalment dels sectors d’automoció i packaging. Enginyer de desenvolupament de productes i processos a SONY Espanya. Director Tècnic i assessor en empresa d’automoció TIER 1.