Listen Top Shows Blog

47. Three practical ways to fast-track the data cleansing process

47. Three practical ways to fast-track the data cleansing process

Update: 2021-08-01

Share

Description

In this episode we discuss three simple ways to improve the data cleansing process - easier, faster and higher quality.

Find the optimal data source (e.g., don't use a poorly structured dataset)
Cleanse iteratively - you may not need all of the fields/columns
Import iteratively - start with a subset of the data and build on that as needed

About this podcast
The podcast for performance auditors and internal auditors that use (or want to use) data.
Hosted by Conor McGarrity and Yusuf Moolla.
Produced by Risk Insights (riskinsights.com.au).

Comments

In Channel

58. The final episode

58. The final episode

2024-08-2744:11

57. Michael Drechnowicz, Head of Internal Audit, TK Elevator

57. Michael Drechnowicz, Head of Internal Audit, TK Elevator

2023-12-1335:06

56. Cathy O'Neil, Algorithm Auditor, Author of WMathD

56. Cathy O'Neil, Algorithm Auditor, Author of WMathD

2023-02-2844:06

55. Data Science and KNIME with Maarit Widmann

55. Data Science and KNIME with Maarit Widmann

2022-03-2120:36

54. Analysis

54. Analysis

2022-01-2419:17

53. The Data-Confident Internal Auditor

53. The Data-Confident Internal Auditor

2021-12-1223:49

52. Simplicity

52. Simplicity

2021-11-1616:28

51. Performance Audit Mini-Series #4: Conduct/Fieldwork

51. Performance Audit Mini-Series #4: Conduct/Fieldwork

2021-10-1413:34

50. Performance Audit Mini-Series #3 Planning with data

50. Performance Audit Mini-Series #3 Planning with data

2021-09-2817:58

49. Performance Audit Mini-Series #2 Work Program Balance

49. Performance Audit Mini-Series #2 Work Program Balance

2021-09-0715:55

48. Performance Audit Mini-Series #1 Forward Work Planning

48. Performance Audit Mini-Series #1 Forward Work Planning

2021-08-1817:59

47. Three practical ways to fast-track the data cleansing process

47. Three practical ways to fast-track the data cleansing process

2021-08-0109:41

46. Combining data to create risk indicators for audits and risk monitoring/exploration

46. Combining data to create risk indicators for audits and risk monitoring/exploration

2021-07-1814:52

45. How ANAO uses data in performance audits - with Xiaoyan Lu and Christine Chalmers

45. How ANAO uses data in performance audits - with Xiaoyan Lu and Christine Chalmers

2021-06-2019:34

44. ESG and Sustainable Investing with Tiina Landau

44. ESG and Sustainable Investing with Tiina Landau

2021-06-0628:36

43. Microsoft 365 Compliance with Erica Toelle

43. Microsoft 365 Compliance with Erica Toelle

2021-05-2324:59

42. Michael DeCero, a Data Professional at TDS with an Internal Audit background

42. Michael DeCero, a Data Professional at TDS with an Internal Audit background

2021-05-0925:58

41. Steve Rummel, Senior IA Analytics Manager at CVS Health

41. Steve Rummel, Senior IA Analytics Manager at CVS Health

2021-04-2534:35

40. A CIO/CRO perspective on risk, security and internal audit with Ari Levien

40. A CIO/CRO perspective on risk, security and internal audit with Ari Levien

2021-04-1225:54

39. Four Quality Assurance Steps - Data in Audit

39. Four Quality Assurance Steps - Data in Audit

2021-03-2810:35

00:00

00:00

1.0x

47. Three practical ways to fast-track the data cleansing process

47. Three practical ways to fast-track the data cleansing process

Risk Insights, Yusuf Moolla, Conor McGarrity