Study Roadmap for Beginners

Embark on your journey in data engineering with our specially curated study roadmap for beginners. The following are different guides written by people to help learners out. They provide a structured path for newcomers, covering foundational concepts, essential tools, and key technologies in the field. Ideal for those starting out, these roadmaps are your first step towards mastering data engineering and other data roles. Good luck!

Roadmaps

Data Engineering by Sandy

Roadmap.sh

I.AM.AI

Surfalytics

Data Camp Roadmaps By Nicksy

These are specific courses from Data Camp curated by Nicksy.

Data Engineering

Data Engineering

Foundational Data Engineering Skills

  • Understanding Data Engineering (Beginner)
  • Introduction to Data Visualization (Beginner)
  • Understanding Cloud Computing (Beginner)
  • Introduction to Git (Beginner)
  • Introduction to Shell (Beginner)
  • Project: Designing a Bank Marketing Database (Project)

SQL Data Management

  • Introduction to SQL (Beginner)
  • Intermediate SQL (Intermediate)
  • Joining Data in SQL (Intermediate)
  • Introduction to Relational Databases in SQL (Intermediate)
  • Database Design (Advanced)
  • Streamlined Data Ingestion with pandas (Intermediate)

Python Programming and Data Handling

  • Introduction to Python (Beginner)
  • Intermediate Python (Intermediate)
  • Introduction to Importing Data in Python (Intermediate)
  • Data Manipulation with pandas (Intermediate)
  • Joining Data with pandas (Intermediate)
  • Python Data Science Toolbox (Part 1) (Intermediate)
  • Python Data Science Toolbox (Part 2) (Intermediate)
  • Software Engineering Principles in Python (Intermediate)
  • Cleaning Data in Python (Intermediate)
  • Data Types for Data Science in Python (Intermediate)
  • Writing Efficient Python Code (Advanced)

Data Analyst

Data Analyst

Data Analyst in SQL Path

  • Introduction to SQL (Beginner)
  • Intermediate SQL (Intermediate)
  • Joining Data in SQL (Intermediate)
  • Data Manipulation in SQL (Intermediate)
  • PostgreSQL Summary Stats and Window Functions (Advanced)
  • Functions for Manipulating Data in PostgreSQL (Advanced)
  • Data-Driven Decision Making in SQL (Advanced)
  • Exploratory Data Analysis in SQL (Advanced)
  • Project: When Was the Golden Age of Video Games? (Project)

Data Analyst in Python Path

  • Introduction to Python (Beginner)
  • Intermediate Python (Intermediate)
  • Data Manipulation with pandas (Intermediate)
  • Introduction to Data Science in Python (Intermediate)
  • Introduction to Data Visualization with Seaborn (Intermediate)
  • Introduction to Statistics in Python (Intermediate)
  • Joining Data with pandas (Intermediate)
  • Sampling in Python (Advanced)
  • Hypothesis Testing in Python (Advanced)
  • Exploratory Data Analysis in Python (Advanced)

Data Analyst in R Path

  • Introduction to R (Beginner)
  • Intermediate R (Intermediate)
  • Introduction to the Tidyverse (Intermediate)
  • Data Manipulation with dplyr (Intermediate)
  • Introduction to Data Visualization with ggplot2 (Intermediate)
  • Introduction to Statistics in R (Intermediate)
  • Joining Data with dplyr (Intermediate)
  • Sampling in R (Advanced)
  • Hypothesis Testing in R (Advanced)
  • Exploratory Data Analysis in R (Advanced)

Globe.engineer

  • You can use this to generate your own custom study roadmap.

Data Engineering 101

Philippines Skills Framework

Below is an on-going project to propose a professional skills framework for data, analytics, and AI careers in the Philippines.

Formal and Continuing Education

This list provides options for formal education in the Philippines with respect to data and technology programs.

Open Universities

An open university is a university with an open-door academic policy, with minimal or no entry requirements. Open universities may employ specific teaching methods, such as open supported learning or distance education.

Expanded Tertiary Education Equivalency and Accreditation(ETEEAP)

The ETEEAP is a comprehensive educational assessment program at the tertiary level that recognizes, accredits and gives equivalencies to knowledge, skills, attitudes and values gained by individuals from relevant work.

Internships and Work Opportunities in the Philippines

This list provides curated links to sites offering internship and work opportunities in the Philippines, focusing on various sectors and fields.

Internships in the Philippines

Here are some valuable resources for finding internships across a wide range of industries:

Work in the Philippines

Explore these links for career opportunities and job postings in the Philippines, particularly for startup and technology-related positions:

Finding Creative Work Experience

For individuals interested in data-related fields, finding the right internships and experience-building opportunities can greatly enhance their career prospects.

  1. Hackathons and Data Competitions: Engage in local hackathons or online data competitions focused on Filipino concerns or sponsored by local companies. Try to start here and here.
  2. Volunteering for Nonprofits: Offer your data analysis skills to local nonprofits in the Philippines, this includes NGOs, Churches, and Community Orgs. You can start here.
  3. University Research Projects: If you’re a student or have connections with educational institutions, consider joining research projects at universities which frequently conduct studies requiring significant data analysis. You can start here.
  4. Freelance Projects: Filipino data enthusiasts can find freelance data gigs on platforms like Onlinejobs.ph and Freelancer.ph, which cater to local freelancers and often have postings for data analysis projects. I suggest connecting with the r/buhaydigital group and starting with their list here.
  5. Open Source Project Contributions: Contributing to open source projects that benefit the local community or address specific Filipino issues can be particularly rewarding. This not only builds your portfolio but also helps address local challenges through technology. You can start by joining their group here.
  6. Industry Conferences and Meetups: Participate in industry conferences or meetups in major cities like Manila, Cebu, or Davao. Events that provide networking opportunities with data professionals and can lead to internship offers. Orgs such as AAP and DEVCON are great places to start.
  7. Online Internship Platforms Specific to Tech: Utilize platforms like kalibrr.com and jobstreet.com.ph, which frequently list internships and entry-level positions in tech-focused roles within the Philippines.
  8. Government and Public Data Initiatives: Get involved with projects sponsored by the Philippine government. Places to start are PSA, DOSTA-ASTI, and DICT.
  9. Corporate Summer Trainee Programs: Look into summer trainee programs in companies which have data-intensive roles focusing on business intelligence and customer data analytics. A place to start is this list.
  10. Social Media Groups and Online Communities: Join local groups on social media such as r/TechCareerShifter, Linkedin Filipino Professionals, and Data Analyst Job Hiring Philippines in Facebook.

Build A Portfolio

Building a professional portfolio is crucial for showcasing your skills and projects to potential employers or clients. Here are some valuable resources to help you create and enhance your portfolio:

Data Engineering Projects

This list provides a selection of data engineering projects suitable for beginners to advanced learners, offering practical experience and skills development in various aspects of data engineering. We do not advise doing all of them but try to do AT LEAST ONE.

Beginner Projects

Start your data engineering journey with these projects, which are designed for those new to the field.

Intermediate Projects

These projects are designed for those who have some foundational knowledge and are looking to tackle more complex tasks.

Advanced Projects

For those ready to challenge themselves, these advanced projects require a solid understanding of data systems and engineering principles.

/post/de_best_practices/) - Trino Getting Started with Hive and MinIO - Magic The Gathering Data Project

Data Analysis and Visualization Projects

  • Adventure Works - Create your own version of the AdventureWorks analysis, use any tool for the analysis and visualization. The dataset is also available on the internet, an example is in Kaggle.
  • Northwind Traders - Create your own version of the Northwind Traders analysis, use any tool for the analysis and visualization. The dataset is also available on the internet, an example is in Kaggle.
  • Wide World Importers - Create your own version of the Wide World Importers analysis, use any tool for the analysis and visualization. The dataset is also available on the internet, an example is in Kaggle.

Data Science Projects

Project Guides From Community

You can check project suggestions and guides from the community here.

Getting Certificates

One of the common ways professionals use to validate their knowledge is thru the presentation of certs. Just know that experience and actual projects are still better than certificates! In general Certs != Jobs okay? Let’s get on by looking at the two kinds:

Aspect Certificate Certification
Definition A document awarded after completing a specific course or program. A credential awarded after passing an exam, showing proficiency in a field.
Scope Focused on a specific subject or skill. Covers a comprehensive range of skills or knowledge in a professional field.
Duration Short-term, ranging from a few hours to several months. Often requires ongoing education and re-certification to maintain validity.
Issued By Educational institutions, online platforms, or professional training bodies. Professional organizations or certification bodies that set industry standards.
Purpose Educational, aimed at broadening skills and knowledge for personal or career development. Validates professional expertise and typically required for certain jobs or career advancement.

Certificates for Government Work

  1. Civil Service Eligibility: This is usually required for government jobs. If you’ve graduated with honors or passed professional board exams, you might not need to take the general eligibility exam. Here are the qualifications and you can look for more information how to take the exam here.
  2. EDPSE Certification: If you’re in IT, this certification is tailored for tech roles in the government and can replace the general eligibility exam. You can check the qualifications here and you can also take a look at the ICT Proficiency examination which can be found here.
  3. Advanced Degrees: Earning a Master’s or Doctorate can really

help if you’re aiming for higher positions. You can check our recommended data related graduate programs here. 4. Webinars and Courses: Look out for free webinars and courses offered by TESDA some of which you can find here. In addition to this, DICT also has similar offerings found here.

Free Certificates

There are options for free certificates, which merely represent your participation and completion of training courses and programs. You can find our curated list here which we have filtered to those that are FREE and relevant to data careers.