Selecting and Preparing Data
Completion requirements
Preparing data for BI analysis is commonly known as data scrubbing or cleaning. Generally, it can be a very long, large, and complex process, but the concepts are fairly straightforward. Watch this video, which describes the data cleaning process in Excel. How could you extend these concepts to a more complex, multi-vendor database environment? What would be some of your first steps if you were in charge of data cleaning for a BI system? What challenges do you expect to encounter?
Source: Alex The Analyst, https://www.youtube.com/watch?v=_jmiEGZ6PIY
This work is licensed under a Creative Commons Attribution 3.0 License.
Last modified: Friday, 8 November 2024, 2:48 AM