Home | Prices | Contact Us | Courses: Power BI - Excel - Python - SQL - Generative AI - Visualising Data - Analysing Data
Data Analysis Techniques
We will cover these techniques. The instructor will demo these and we will practice in lab exercises.
Techniques primarily for cleaning data and getting it into a good shape for analysis
- removing (filtering) rows
- removing (or selecting) columns
- splitting a column
- finding and fixing bad data such as outliers or missing values, inconsistencies
Techniques primarily for analysing data
- create new columns with values based on other columns in the same row
- summarise data (group by and aggregate operations)
- bin values in numeric columns
- group values in categorical columns
- visualise to gain insight
- brief descriptive statistics