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
APRIL-JUNE
JULY 2024
AUGUST 2024
SEPTEMBER 2024
OCTOBER 2024
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
APRIL - JUNE (16 hours)
Starting module
Starting module
﹅Emerging Technologies: AI, IoT, blockchain.
﹅Agile Explorer: Methodologies, Scrum.
﹅Your Future Job in Data Analytics.
JULY 2024 (60 hours)
Introduction to Data Analytics
Introduction to Data Analytics
﹅ DA Fundamentals
﹅ Business Intelligence and Data Mining
﹅ Excel from 0 to advanced
﹅ Professional Proyect
AUGUST 2024 (90 hours)
Exploratory Data Analysis
Exploratory Data Analysis
﹅ Databases. SQL and MySQL
﹅ Relational Bases
﹅ Power Query + Power BI
﹅ Professional Proyect
SEPTEMBER 2024 (45 hours)
Visualization and Command Dashboards
Visualization and Command Dashboards
﹅ Create reports with Excel and Power BI
﹅ Looker Studio and Google Sheets
﹅ Professional Proyect
OCTOBER 2024 (44 hours)
Profesional Practice
Profesional Practice
﹅ Real integrative project for NGOs
TRIPLE SUPPORT METHODOLOGY
﹅ 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
Exploring Emerging Technologies (7 asynchronous hours)
- 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 explorer (8 hours asynchronous)
- Agile values and principles to transform work environments.
- Practical implementation of Agile and fostering dialogues about its use.
Your future in Data Analytics (50 asynchronous minutes)
- 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).
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
Sprint 1: Introducción a Data Analytics
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
Sprint 2: Exploratory Data Analysis
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
Sprint 3: Visualization and Dashboards
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
Sprint 4: Professional project
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.
ASYNCHRONOUS CONTENT
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.
JOB COACHING AND HUMAN SKILLS STRENGTHENING WORKSHOPS (OPTIONAL)
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
CAREER CONVERSATION IBM (OPTIONAL)
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.
JOB COACHING (OPTIONAL)
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.
If you are selected, you will receive an email to register on the IBM Skills Build platform.
You must complete the Initial Module courses in one week.
Complete the Data Analytics course eligibility form.
If you meet the requirements, you will receive an email confirming your scholarship and access to synchronous classes.
Complete the registration form for the Initial Module.
Selected people will receive an email with access to IBM's Skill Build platform to register.
Complete the Initial Module courses uploaded to the Skill Build platform.
Complete the Data Analytics course eligibility form.
If you meet the requirements, you will receive an email confirming your scholarship and access to synchronous classes.
Inscribete al programa y completa el formulario de admisión al Módulo Inicial.
De ser seleccionado/a recibirás email para registrarte en la plataforma IBM Skills Build.
Deberás completar los cursos del Módulo Inicial en una semana.
Completa el formulario de elegibilidad para el curso de Data Analytics.
De cumplir con los requisitos, recibirás un email confirmando tu beca y acceso a las clases sincrónicas.
Program Registration
Questions and doubts? Write to us at admisiones@guayerd.com