Data Analytics and Video Tutorials
Is the process of making sure there are no errors in the output.
Have you learnt how to connect to your data in Tableau and now want to understand how to group your Tableau data? Here we go through a number of steps to help you understand better how to approach this, and what benefits it will bring to your data analytics project. Why would I group in…
Livestream #2 – What does a data analyst do? You are probably sitting there hearing about big data and databases, data analytics and machine learning, and wondering where a data analyst fits in. Here we will look to break it down step by step. Difference between a Data Analyst and a Business Analyst Data Analyst…
In recent posts on SQL here on this website, we have covered off a number of ways to extract your data from wildcards to filters. Here we are going to build on that learning, but bring in a new dimension in the use of case statements. These are very handy to use when you may…
Do you want to validate with Tuples, that is easy, making changes not easy. In our recent video Python – how do I remove unwanted characters lists were used as a lookup to validate data that we need to be check for invalid data items. The most apparent difference between the two is that tuples are…
Read More “Python Tutorial: How to validate data using tuples” »
Removal of unwanted errors in your data, the easy way.The process of importing data can take many formats, but have you been looking for a video on how you do this? Even better are you looking for a video that shows you how to import a CSV file and then data cleanse it, effectively removing…
Read More “How to remove characters from an imported CSV file” »
Removing the unwanted, that is holding you up.A situation has arisen of you having information, which has erroneous data inside it, what do you do? Data issues are a common scenario faced by many data analytics professionals and the industry as a whole. Data quality now has become more critical, especially as we move more…