3.83 out of 5
6 reviews on Udemy

Business Intelligence – Collecting, Cleaning, Merging Data

This course prepares participants to begin business intelligence projects.
Illumeo Learning
45 students enrolled
English [Auto-generated]
Explore how to critically examine databases produced by Business Intelligence (BI) software packages like those from Salesforce, Tableau, Oracle, IBM for issues or concerns.
Recognize how to gather relevant data from publicly available databases.
Explore how to merge datasets together based on unique identifiers to create a single useable database.
Identify and examine data via automated tools and processes to weed out questionable or erroneous data points.

This course prepares participants to begin business intelligence projects with a hands-on approach to gathering and cleaning data. After taking this course, participants will be ready to create their own databases or oversee the creation of databases for their company.

The focus in this course is on “Big Data” datasets containing anywhere from tens of thousands to millions of observations. While the tools used are applicable for smaller datasets of a few hundred data points, the focus is on larger datasets. The course also helps participants with no experience in building datasets to start from scratch.

Finally, the course is excellent for users of Salesforce, Tableau, Oracle, IBM, SAP and other BI software packages since it helps viewers see through the “black box” to the underlying mechanics of Business Intelligence practices.

If you would like Continuing Education Credit (e.g. CPE, CE, CPD, etc.) for this course, it is available if you take this course on the Illumeo dot com platform under course title: Business Intelligence – Collecting, Cleaning, and Merging Data. Illumeo is certified to provide CPE in over two dozen different professional certifications covering finance, accounting, treasury, internal audit, HR, and more. However, in order to receive CPE credit the courses must be taken on an ‘approved-by-the-governing-body’ CPE platform, and for over two dozen corporate professional certifications, that is the Illumeo platform. Go to Illumeo dot com to learn more.


Introduction to Business Intelligence: Data Collection and Cleaning
Assessing Data Bases
Gathering Data
Merging Data Sets
Cleaning Databases
Pitfalls In Building Datasets

Supporting Materials

Slides: BI Collecting, Cleaning, and Merging Data
BI Collecting, Cleaning, and Merging Data Glossary/Index

Review and Test

Review Questions

Review Questions: Business Intelligence – Collecting, Cleaning, and Merging Data


FINAL EXAM: Business Intelligence – Collecting, Cleaning, and Merging Data

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.8 out of 5
6 Ratings

Detailed Rating

Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
30-Day Money-Back Guarantee


1 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion