From the course: Introduction to Career Skills in Data Analytics
Join today to access over 25,100 courses taught by industry experts.
Assessing and adapting the data for transformation
From the course: Introduction to Career Skills in Data Analytics
Assessing and adapting the data for transformation
- [Instructor] Have you ever heard of data profiling? It's where we create a high-level profile of the characteristics of the data that we're working with. We should apply this approach to every data set. The greatest thing about profiling data is that when we use this approach, we get to learn about the data we're working with at a high level. Profiling helps to inform us on some pretty valuable items. It tells us how much data we have in this set. It can also tell us what the totals counts or averages of any number may be. This helps us validate our numbers later. It can also inform us about the data cleaning we will need to complete when we get ready to transform our data. I have some sales order data here, and I want to profile this data to help me get started working towards a report on sales orders. I'll first start by profiling the amount of data. I want to take a look at the record counts. How…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.