1. Start Analytics Canvas.
2. Import Data.xlsx using Excel File Import Block (New source
> Excel File
).
3. From the Data Profiler
- Assess the number of columns and rows
- Review summary statistics
3. Become familiar with the following statistics:
- Cardinality
- Missing rows
- Minimum and maximum, and other statistics
4. Use the Data Profiler Block, to
- Select columns to profile, and create a rule
- Review the results
Time to complete the exercise:
10 min
You can download a free trial of Analytics Canvas to complete the exercises.