Canvas Logo

[Online streaming course] DYNAMIC TABLES AND GRAPHS WITH POWERQUERY AND POWERPIVOT. Advanced Excel.

Atenció!
Activitat ajornada
Motiu:
Modality: The course will be online, streamed with access to the virtual classroom, where you will connect with the teacher to follow the course through the CISCO WEBEX platform.
??Aimed at: Anyone who dedicates part of their working time to obtaining indicators from data, mainly in departments such as: Finance. Shopping. Manufacturing. Engineering. Operations. HR. Etc.
?Dates: July 20, 22 and 24 (Monday, Wednesday and Friday)
⏰Schedule: From 9.30 am to 1.30 pm
Attendees: Maximum 25 students
Duration: 12 teaching hours
Programming:

The course will be divided into 3 days of 4 hours each, with the following content:

Day 1

  • The concept of Table
  • Structure of a database.
  • Conditioners to be able to manage the dynamic tables correctly
  • PivotTables, their full potential and what they can do
  • Beginning of the practice

Day 2

  • Insert data segmentation
  • Insert time scale
  • Filter connections
  • Dynamic chart report
  • Relate tables and dynamic graphs
  • Generate a "Dashboard"
  • Dynamic control panel for data presentation
  • Introduction to PowerQuery
  • The source of data
  • Create the query

Day 3

  • Work with PowerQuery, Power Pivot and Power BI
  • Update data
  • Queries with parameters
  • Case study
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: Until the 2013 version of Excel, they had a fundamental tool for calculations based on data that was the PivotTable. From this version, Excel offers us two much more powerful tools for data management which are: PowerQuery and PowerPivot. This course will study in depth the handling of tables and dynamic graphs as well as the handling of the new table management tools: PowerQuery and PowerPivot. The video with the presentation of the course can be found at: https://www.youtube.com/watch?v=48WvsfscxK0&feature=youtu.be Although the video specifies a duration of 20 hours, this course, of 12 hours, will see the same points that are explained in the video.
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 external advice. 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:

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.