At The End Of The Course You Will Be Able To

• Define what the Power BI tool is and when to use it.
• Identify the different data sources and the methodology for obtaining them.
• Apply basic Power BI functions such as connector types, basic table transformations and more complex ones such as pivoting, data grouping, combining, conditional columns, among others.
• Use Data Analysis (DAX) expressions to improve created models.
• Know the general rules for data tables.
• Create data visualizations for decision making.
• Build reports that include different types of graphics.
• Evaluate a situation based on data provided by applying the Power BI knowledge covered during the course.

Course Content

1. Introduction to Power BI
   • What is Power BI and when to use it?
   • Explanation of the benefits and uses of the product.
   • Installation and version considerations
   • Information about the available versions and how to install.
2. Getting Data
   • Data sources: databases, files, and web
   • How to connect different types of data in Power BI.
   • Remapping moved data sources
   • How to handle changes in the location of data sources.
3. Basic Functions
   • Deleting columns and rows
   • Tools to clean up unnecessary data.
   • Changing data types
   • How to adjust data to the appropriate types.
   • Filters
   • Using basic filters for visualization and analysis.
4. Complex Functions
   • Grouping, splitting, and duplicating data
   • Advanced techniques for organizing data.
   • Data Blending: Aggregating and Merging
   • Pivoting and Unpivoting Data
   • Adding Columns and Custom Columns
   • Conditional Column and Index
5. Relationships and Hierarchies
   • Model View and Relationship Management (30 minutes)
   • Types of Joins and Hierarchies
   • Working with Related Tables
6. DAX Formulas and Measures
   • Formulas and Measures
   • Introduction and practice with basic formulas and measures.
   • Quick Actions
7. Data Tables and Time Intelligence
   • Data Table Rules and Configuration
   • Automatic Date Tables and Time Intelligence
8. Visualizations
   • Matrices and Charts
   • KPIs and Spatial Intelligence
9. Managing Visualizations
   • Slicers and Drilling
   • Basic and Advanced Filters
10. Publishing and Sharing Reports
    • Publishing on the Web
    • Exporting to PDF
11. Final Project and Practice
    • Group Project Solution and Presentation

This course provides a comprehensive understanding of lasers applied to marking, from basic principles to practical applications and specialized maintenance. Participants will gain knowledge of the operation and essentials of lasers, explore laser-matter interaction, specific marking applications and learn safety practices. In addition, they will focus on the maintenance of fiber lasers, including necessary care. Upon completion, students will be equipped with skills to apply and maintain laser marking systems, consolidating their expertise in this technological field

At the end of the course you will able to:

• Understand the basic operation of lasers.
• Classify the dierent types of lasers and understand their applications.
• Analyze the essential parameters in the use of lasers for marking.
• Implement safety measures when working with lasers.
• Explore general laser marking applications.
• Perform typical maintenance on fiber lasers.
• Apply care necessary for optimal maintenance and performance of laser marking systems.
• Understand the relevance of laser marking machines within the industry

Main topics

• Laser Fundamentals
  • Laser definition
  • Characteristics and operation
  • Laser types
  • Parameters and propagation
• Safety
  • Laser and risk
  • Damage mechanism
  • Other hazards
  • Equipment classification
  • Control measures
• Aplications
  • Laser Marking Applications
  • Marking materials
• Laser source maintenance:
  • Typical Maintenance
  • Required Care

This course introduces participants to Programmable Logic Controllers (PLCs), providing a solid foundation in understanding and programming these essential devices in industrial automation. From a detailed introduction to PLCs to an exploration of internal architecture, terminology and numbering systems, the curriculum covers fundamental aspects of hardware, installation, and hands-on programming in Ladder language. Participants gain skills in interlocks, timers and arithmetic functions culminating in a hands-on project that consolidates their understanding and skills in PLC programming.

At the end of the course you will able to:

• Understand the internal architecture of PLCs and their associated terminology
• Identify and work with diferent types of controllers and I/O modules.
• Apply wiring principles in PLC installation and connection.
• Become familiar with memory mapping and physical I/O addressing.
• Program in Ladder language, from latching to linear and sequential programming.
• Apply concepts of digital logic, timers and arithmetic functions in PLC programming.
• Develop a final project that demonstrates their ability to apply the fundamentals of PLC programming in practical
• industry situations.

Main topics

• Introduction to PLCs
  • Definition and types of PLC.
  • Internal architecture
  • Basic concepts and terminology
  • Numbering systems
• Introduction to hardwareController
  • I/O modules
  • Special modules
  • Communication modules
  • Power supply selection
• Installation and connection
  • General wiring principles
  • Internal circuit of input module
  • NPN and PNP sensors
  • Principle of input wiring.
  • Principle of output wiring.
• Memory map
  • PLC memory layout
  • Physical I/O addressing
• Introduction to programming
  • Ladder language introduction
  • Interlocks
  • Timers
  • Basic arithmetic functions
  • Data movements
  • Basic logic programming
  • Linear and sequential programming
  • Final Project

Al final del curso usted aprenderá a:

• Conocer el entorno de dibujo de SolidWorks, así como dominar sus herramientas y
• representación y visualización
• Generar modelos tridimensionales
• Generar dibujo (planos) normalizados para la representación de modelos 3D
• Generar ensambles de partes e integrar sus relaciones de funcionamiento
• Mostrar por medio de videos y/o presentaciones el funcionamiento de los elementos
• mecánicos ensamblados

Contenido del Curso

1. Conceptos básico e interfaz de usuario de SolidWorks
2. Introducción a los croquis
3. Modelado básico de piezas
4. Creación de patrones y geometrías de referencia
5. Operaciones para la generación de sólidos
6. Herramientas de edición
7. Configuración, variables y ecuaciones
8. Dibujo (Planos)
9. Ensambles