Version control and Git What is Version Control and Git? A Version Control System (VCS) is a tool or a methodology that enables developers to track changes to their files, typically code files, over time and to reinstate previous versions of these files if something was to go wrong. A very primitive example of
Introduction to Data Build Tool Welcome! Before we begin, I recommend you to read my previous article where I covered data pipelines following the traditional data workflow of Extract, Transform and Load or ETL. In the modern age, with the advent of technology, compute and storage resources are much cheaper than what they used to
Data Pipeline Basics If you work in tech, especially in data, you'll often come across the term 'Data Pipeline'. In this article, I distil what exactly a data pipeline, just enough so that you can be sure to know what your data engineer is talking about next time they
Databases, Datawarehouses, Datalakes. All too often I hear terms like "datawarehouses", "datalakes" and even "datalakehouses" in analytics. They are often used interchangeably with no clear picture in my mind of their differences and how they are related. These terms come across very elusive like a black box
How to create a Shape Map for Power BI Are you bored of bar charts? Do you want to be more creative with geographic data? Are the standard point maps not useful? Look no further, as in this article I will walkthrough how to create shapemap visuals for Power BI. If you don't know what a shapemap
Machine Learning House Price Prediction - Ames Housing Dataset Predicting a value from data is a very common data science problem for example, predicting house prices based on neighbourhood or number of acres. A popular dataset of this sort is the Ames Housing dataset which can be found on Kaggle. In this article, I will walkthrough, step by step,
Business Storytelling Presenting Last week, I attended a course organised by my employer called 'The Power of Storytelling'. Now when we attend presentations, meetings or lectures, how often are they memorable? I bet no more than a handful. The reason behind this has a lot to do with the way our
Data GDPR Laws - bringing order to the messy data landscape. In this article, I explain what GDPR is, why it is important and the consequences it can have for companies that fail to comply with it. What is GDPR? GDPR stands for General Data Protection Regulation. It came into force in the European Union in May 2018. The regulation sets
Data Power BI - VertiPaq Engine Power BI is a data visualisation tool and what makes it incredibly efficient from an end users perspective has largely to do with its underlying architecture, specifically the Vertipaq Engine. In this article I will explain what it is, why it is important and how it works. What is it?
Data 6 Dimensions of Data Quality Data quality is crucial for data analysis and insights. Many business decisions are data driven, so poor data quality will lead to poor decision making. This consequently leads to companies lacking trust in their insights. For example, Gartner estimates that on average companies lose $15 million a year due to
Machine Learning Titanic Dataset - Key Machine Learning Concepts The sinking of the Titanic in 1912 was the most disastrous shipwreck of its time. It also makes for a great dataset for machine learning beginners. In other words, the titanic dataset is the "Hello World" of data science and can be found on Kaggle here [https://www.
Getting Started From university to industry - the finer details. My Background After graduating from University in 2019, I didn't have a clear vision of what I wanted to do as a career. I began my career by joining Sparta Global on a 8 weeks course on Data Analytics as this was the role that best suited my
