Data Analytics and Video Tutorials
Ensure that your data is correct before using it.
Normalization is a process of organizing data in a database to reduce data redundancy and ensure data integrity. There are several types of normalization, each with its own set of rules for eliminating data redundancy and improving data integrity. The most commonly used normalization levels are: There are also higher levels of normalization, such as…
Read More “Explain different types of data Normalization.” »
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…
Using r programming functions to cleanse data In our recent post Python Tutorial: How do I remove unwanted characters we walked through the concepts behind data cleansing. We demonstrated several different approaches to data cleansing, and the use of regular expressions was also shown. Here we look at that approach using rstudio and the following…
Read More “how to remove unwanted characters from your data” »
Validating cells in Excel quickly – how to do it easily!Are you working with large spreadsheets and looking to quickly at data validation exercise to save you time? The aim would be to run your code and test it against some predefined rules you or your data analyst would have written to make sure it…