Unfortunately, not all data sources you will work with are clean and easy to use. Because of that, we will discuss concepts (e.g. RegEx, coalesce, and string functions) to clean unstructured data and correctly extract insights from data.

In the next 1.5 weeks, we will focus on writing complex queries that combine many data sources and how to simplify them. We will use this knowledge to teach out how to create hierarchical queries that can be used to build datasets for business analysis, dashboard views, or data science modelling.

In the last week, we will go through a real-life business case that combines all the theories discussed in the previous weeks. This will allow you to become more comfortable in applying these skills in an actual business environment. You will receive the certificate of completion after passing the business case.