PinnedInTowards Data EngineeringbyMadushan Pathirana·Feb 10Why Prefect 3 Wins for Modern Data Engineering - The Power of Ephemeral InfrastructureA data pipeline orchestration platform is a “must-have” for any serious data engineering department. These platforms simplify a data…
PinnedMadushan Pathirana·Mar 11, 2023Top Free Data Science Learning Resources for Absolute Beginners — My Personal Picks and…These are the sources I used to improve my data science skills. Specifically coding and mathematics for machine learning /statistics.A response icon1A response icon1
PinnedMadushan Pathirana·Feb 2, 2023SQL for Data Analytics —Installation and select queriesIf you are looking for a place to learn SQL for Data Analytics you are at the correct place. In this article series we will use sample…
InPower BIbyMadushan Pathirana·Mar 17, 2023SQL Subqueries — SQL for Data AnalyticsThis is the 7th article in SQL for data analytics article series. In this article, we will discuss how to use SQL subqueries on in another…A response icon3A response icon3
Madushan Pathirana·Mar 3, 2023Window Functions — SQL for Data AnalyticsIn this article, we will discuss how to join multiple tables and how to extract informative insights.
Madushan Pathirana·Feb 26, 2023SQL for Data Analytics — JoinsIn this article, we will discuss how to join multiple tables and how to extract informative insights.A response icon1A response icon1
Madushan Pathirana·Feb 18, 2023SQL for Data Analytics — Aggregation FunctionsIn this article, we will discuss what are aggregation functions are and how to use them
Madushan Pathirana·Feb 16, 2023How I became a Data Analyst — with no tech degreeI see many people seeking to change their career path to the IT sector due to the ongoing economic crisis. So this is how I did it. This…A response icon4A response icon4
Madushan Pathirana·Feb 8, 2023SQL for Data Analytics — Like Operator , Case expressions and String FunctionsIn this article, you will learn how to use Like operator to filter data based on patterns in a text field.
Madushan Pathirana·Feb 5, 2023SQL for Data Analytics — Where clauseYou can use SQL not only to extract tables from a database as it is, but you can also filter data based on business logic. We will…