This tutorial is part of the SQL Made Easy series of posts. In this tutorial we will discuss: Sometimes when working with large tables in SQL you will come across columns that contain duplicate values. Most of the time these duplicates aren’t an issue as they aren’t meant to be a unique identifier or primary…
Working with multiple data sets in excel can be quite a time consuming and manual process. Depending on the complexity of the data and how much it needs cleaning there is often a fair bit to do in order to get it into a single clean sheet that you can work with for analysis or…
If you are looking to start out a career in the world of data and analytics, or just want to up your skills in data analysis in general, one of the most common terms you will come across is SQL. There are a whole lot of different concepts and tools in this field from spreadsheets…
For many years my go to platform of choice for anything related to data was Microsoft Excel. Hours spent downloading various sources of data into a spreadsheet and running sums, counts, vlookups, countifs, pivot tables and lots and lots of formatting. As requirements got more complicated and datasets grew larger, Excel started to display some…