Skip to Main Content

Data Analytics: Data preparation

Data preparation entails cleaning, organising and contextualising of data so that they can be interpreted and analysed.

Web Resources

LinkedIn Learning Videos-Login

LinkedIn Learning - provides access to bite-sized video tutorials covering the areas of architecture, business strategy, cloud computing, digital marketing, design, data analysis, communication, leadership, Microsoft Office and others. - provides access to bite-sized video tutorials covering the areas of architecture, business strategy, cloud computing, digital marketing, design, data analysis, communication, leadership, Microsoft Office and others.

Steps to access LinkedIn Learning

1. Login 

NP

NYP

SP

TP

Login here

Login here

Login here

Login here

2. Click 'Continue without LinkedIn' on the Welcome page.

3. Click 'Do not connect my account'

ONLINE VIDEO COURSE - How to use LinkedIn Learning

MOBILE ACCESS GUIDE - LinkedIn Mobile App |  iOS |  Android & Tablet

Videos

Excel crash course - data cleaning in Excel - Microsoft Excel tutorial by Simon Sez IT

Learn how to do data cleaning in Excel

Google Colab - Clean Google sheets data, Dealing With inconsistent data by Learn Google Spreadsheets

Learn how to clean messy Google Sheets data using Google Colab & Python Fuzzy Pandas.

Data preparation tricks you should know for Power BI solutions | Community Webinars by Microsoft Power BI

Learn how to prepare your data set using Power BI

Contextualization of Manufacturing Data by ARC Advisory Group

Learn how Abbot Nutrition contextualizes their manufacturing data to optimize operations

Data Collection and Preprocessing by Leo Isikdogan

Learn what is data collection and the pre-processing of it

Data preparation tricks you should know for Power BI solutions by Microsoft Power BI

In this video, learn how to prepare your data set using Power BI

Excel Quick Tip A Trick for Finding Inconsistent Data by Microsoft Office Tutorial

In this video, learn how to find inconsistent data using EXCEL