Program: Data Analytics Fundamentals

Prepare for a career in the
growing field of data analytics

Official Certificate

A training program created by IBM and Guayerd for young Latinos, which will allow you to become a data analyst, in addition to strengthening the human skills necessary to enter the job market in technology companies that offer challenging positions and competitive salaries. This program will teach you the fundamental data analysis skills that employers look for for entry-level positions. No previous experience or academic degree is necessary.

Full Schedule

FROM APRIL

AUGUST 2024

SEPTEMBER 2024

OCTOBER 2024

NOVEMBER 2024

16 hours
60 hours
90 hours
45 hours
44 hours

Starting
Module

๏น… Emerging technology: AI, IoT, blockchain.

๏น… Agile Explorer: Methodologies, Scrum

๏น… Your Future Job in Data Analytics

Introduction to
Data Analytics

๏น… DA Fundamentals

๏น… Business Intelligence and Data Mining

๏น… Excel from 0 to Advanced

๏น… Professional Proyect

Exploratory
Data Analysis

๏น… Databases, SQL and MySQL

๏น… Relational Bases

๏น… Power Query & Power BI

๏น… Professional Proyect

Visualization and
Command Dashboards

๏น… Create Reports with Excel and Power BI

๏น… Looker Studio and Google Sheets

๏น… Professional Proyect

Professional Practice

REAL INTEGRATIVE PROJECT FOR NGOS

Triple Support Methodology

Expert mentors

Human Skills Workshops

Job Coaching Workshops

Flip phone to see full schedule

๏น…Emerging Technologies: AI, IoT, blockchain.
๏น…Agile Explorer: Methodologies, Scrum.
๏น…Your Future Job in Data Analytics.

๏น… DA Fundamentals

๏น… Business Intelligence and Data Mining

๏น… Excel from 0 to advanced

๏น… Professional Proyect

๏น… Databases. SQL and MySQL

๏น… Relational Bases

๏น… Power Query + Power BI

๏น… Professional Proyect

๏น… Create reports with Excel and Power BI

๏น… Looker Studio and Google Sheets

๏น… Professional Proyect

๏น… Real integrative project for NGOs

Durante el curso contarรกs con:

๏น… Mentores expertos
๏น… Talleres de Habilidades Humanas
๏น… Talleres de Coaching Laboral

How is the course?

Starting module: Introduction to the tech world with IBM certification

Modality:
100% virtual, asynchronous

Duration:
1 week (16 asynchronous hours)

Scholarships:
100% free for 7000 students

Requirements

๏น… Live in Argentina ๐Ÿ‡ฆ๐Ÿ‡ท, Chile ๐Ÿ‡จ๐Ÿ‡ฑ, Uruguay ๐Ÿ‡บ๐Ÿ‡พ, Bolivia ๐Ÿ‡ง๐Ÿ‡ด, Perรบ ๐Ÿ‡ต๐Ÿ‡ช, Paraguay ๐Ÿ‡ต๐Ÿ‡พ, Colombia ๐Ÿ‡จ๐Ÿ‡ด, Venezuela ๐Ÿ‡ป๐Ÿ‡ช, Ecuador ๐Ÿ‡ช๐Ÿ‡จ.

๏น… Being over 18 years.

๏น… Complete the admission form to the Initial Module.

Module Content

  • Knowledge of technologies such as AI, blockchain, cloud computing, cybersecurity, data and analytics, and IoT.
  • Focus on concepts, terminology and practical applications in business and organizations.
  • Agile values and principles to transform work environments.
  • Practical implementation of Agile and fostering dialogues about its use.
  • Exploring careers in data-related fields.
  • Covers the changing landscape of data jobs and skills needed for roles such as analysts, scientists, engineers, etc.
  • Discusses hard skills (coding, statistics, machine learning) and soft skills (communication, critical thinking).

Official Certificate

Data Analytics course with IBM certification

Modality:
100% virtual

Duration:
16 weeks (3 synchronous hours and 12 asynchronous hours per week)

Scholarships:
100% free for 2000 students (Course cost without scholarship: USD 400)

Requirements to obtain the scholarship:

๏น… Complete the initial 16-hour asynchronous module.
๏น… Complete the admission form for the Data Analytics Course.

Requirements to maintain the scholarship:

๏น… 80% attendance in synchronous classes.
๏น… Have 100% progress in the asynchronous content of the platform.
๏น… Comply with the project deliverables in a timely manner.

Schedules in one of the following day options:

Tuesday or Wednesday or Thursday

7 to 10 PM (GMT-3)

6 to 9 PM (GMT-4)

5 to 8 PM (GMT-5)

Module Content

Data Analysis Fundamentals (1 hour asynchronous)

  • Be a data analyst
  • What is data analysis?
  • Organizing and managing data: Databases
  • Data visualization

Introduction to Business Intelligence and Data Mining (3 asynchronous hours)

  • Business Intelligence, ETL and Data Mining Solutions
  • Examples with QlikView, MS PowerBI among other tools
  • Dashboards

Complete Excel: From Beginner to Advanced (19 asynchronous hours)

  • Prepare averages and KPIS with DAX
  • Manage Excel like a professional
  • Develop complex, nested functions
  • Prepare high-impact reports
  • Relate tables from different sources with Power Pivot
  • Business Intelligence tools like Power Query

Pivot tables, dashboards, macros and more with Google Sheets (7 hours 20 minutes)

  • Create and edit graphics
  • Create professional dashboards
  • Manage dynamic tables and graphs
  • Macros and custom functions
  • Forms connected to Google Sheets
  • Data Studio to exploit Google Sheets data
  • Add plugins to our spreadsheets for more functionality

Databases. Learn SQL and MySQL (34 hours 40 minutes asynchronous)

  • Databases from 0
  • Database Fundamentals
  • Basics of a database administrator
  • Perform queries with SQL
  • MySQL Database Engine
  • Perform Views in databases
  • Perform Triggers
  • Create and carry out transactions
  • Implement Database on the web
  • Present data from different tables
  • Create Stored Routines
  • Database Cardinality

Microsoft Power BI - Power BI Desktop Course (23 hours 58 minutes)

  • Transform data and analyze reports
  • Business intelligence phases with Power BI
  • Complex Power BI features

Power Query -Master Data Transformation in Power BI (2 hours 52 minutes asynchronous)

  • Data extraction from multiple sources
  • Data cleaning and transformation operations
  • ETL process automation
  • Power BI Query Editor Mastery

Excel and Power BI Course โ€“ Data Analysis and Visualization (13 hours 53 minutes asynchronous)

  • Transform data into interactive visualizations with Excel and Power BI
  • Create reports dynamically for data analysis
  • Design live quality reports for decision making.

Learn all about Looker Studio 2023-Data Studio (12 hours)

  • How to connect Data Studio to Google Sheets
  • Calculate averages, highest values, lowest values, variances
  • Create dashboards to display exportable data charts and results cards
  • Create analysis charts easily
  • Create temporary calculations with comparisons
  • Create filters and periods
  • How to combine different data sources
  • Share reports and dashboards with other users

In this last module, participants will have the opportunity to practically apply the knowledge acquired throughout their training in a real integrative project. Through this initiative, they will not only consolidate their skills and knowledge, but also contribute tangibly in collaboration with an NGO, translating theory into concrete actions, strengthening their understanding and fostering a valuable commitment to social impact.

The contents of the program are subject to possible updates that will not modify the learning objectives.

Professional Development

We offer you tools that enhance the development of the professional profile and job placement of program participants.

Exploring Mindfulness (3 hours asynchronous)

  • Understand mindfulness concepts and techniques.
  • Develop greater concentration and self-awareness.

This section has the badge:ย Exploring Mindfulness from SkillsBuildย , co-created by IBM and the Mindfulness Center at the University of Oxford.

Training plan in Professional Skills (6 asynchronous hours)

  • Effective collaboration with teams;ย creating and delivering presentations;ย high impact communication;ย management of challenges in a dedicated and controlled manner;ย utilizing an agile approach to work professionally and provide quality work and experiences to clients;ย and problem solving and solution implementation.

This plan has the badge: โ€œWorking in a Digital World: Professional Skillsโ€ issued by IBM.

Job Application Basics (6 asynchronous hours)

  • How to position yourself effectively for your first job opportunityย 
  • How to Build a Strong, Professional Online and Social Media Presence
  • How to Conduct Thorough and Effective Workplace Research Customized to Your Interests and Skills
  • How to Create a Strong Basic Resume, Even Without Any Previous Work Experience

This section has the badge: โ€œJob Application Essentialsโ€ issued by IBM.

Throughout the training, in 100% online mode, synchronous meetings for optional assistance are held that will be held on Fridays, with the presence of IBM collaborators who are industry leaders who will share their experience and good practices in the search with the participants. labor.

In turn, participants access available material asynchronously, inviting them to be protagonists of their professional development.

In the different proposed instances, content such as:

  • Presentation of the labor market
  • Professional profile
  • Job Skills and Competencies
  • CV Creation and Design
  • Introduction to Job Portals
  • Introduction to Linkedin
  • Linkedin profile development
  • Networking and personal image
  • Introduction to Job Interviews
  • Practical Interview Simulation

Upon completing the first three synchronous modules of the training in a timely manner, interested participants will be able to access career conversations with IBM professionals willing to guide their job search in a personalized way.

Once the training is completed, those who meet all the approval criteria access the job search advisory service provided by the Talent Placement Guayerd professional team.ย It is optional and free, provided for a period of up to 6 months from the conclusion of the course, where graduates will be able to participate in group and individual mentoring, workshops with themes that promote professional development and the detection of job opportunities in the industry.

Program Benefits

Hands-on learning with a variety of data sources and project scenarios

Development of technical and human skills

Preparation for job placement

IBM SkillsBuild Certificates and Guayerd Certification upon completion of the Program

What is the admission and access process to the scholarship?

Register for the program and complete the admission form for the Initial Module.

Register for the program and complete the admission form for the Initial Module.

Step 1
If you are selected, you will receive an email to register on the IBM Skills Build platform.

If you are selected, you will receive an email to register on the IBM Skills Build platform.

Step 2
You must complete the Initial Module courses in one week.

You must complete the Initial Module courses in one week.

Step 3
Complete the Data Analytics course eligibility form.

Complete the Data Analytics course eligibility form.

Step 4
If you meet the requirements, you will receive an email confirming your scholarship and access to synchronous classes.

If you meet the requirements, you will receive an email confirming your scholarship and access to synchronous classes.

Step 5
Complete the Data Analytics course eligibility form.

Complete the Data Analytics course eligibility form.

Step 4
If you meet the requirements, you will receive an email confirming your scholarship and access to synchronous classes.

If you meet the requirements, you will receive an email confirming your scholarship and access to synchronous classes.

Step 5

Are you interested in this course?

Currently not available, leave us your details and we will contact you when a new call opens!

Program Registration

Questions and doubts? Write to us at admisiones@guayerd.com

ยกTHANK YOU!

We appreciate your interest in joining the course.
Our team will contact you when a new call is opened.

THANK YOU.

You will receive an email from Guayerd in your email with access to the next step.