Instructor for this course
more

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.

***Please download and open all supporting materials before starting the course videos.***

Learning Objectives


  • 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


Last updated/reviewed: May 14, 2018

Included In Certifications

This course is included in the following Expert Certifications:

14 CoursesCertified Data Analytics Professional

  1. The Fundamentals of Business Intelligence (BI): What it Does and Why it's so Essential
  2. How is Industry Using Big Data? – A Case Study Reading
  3. Business Intelligence - Data Collection and Cleaning
  4. Business Intelligence - Structuring Data for Analysis
  5. Business Intelligence - Fundamentals of Data Analysis
  6. Business Intelligence - Using Big Data Analytics
  7. Doing Data Analytics In Excel (Hands-on module)
  8. Financial Forecasting
  9. Advanced Analytics – Omitted Variables
  10. Advanced Analytics – Fixed Effects
  11. Case Study in Data Analytics
  12. Using Regressions for Forecasting
  13. Financial Forecasting in Excel (Hands-on module)
  14. Blockchain for Business

42 Reviews (120 ratings)Reviews

5
Anonymous Author
I really enjoyed learning about the different ways to collect, merge and validate data. I thought is was very interesting and useful to know that there is an excel add-in where you can get data from the Federal Reserve (Fred) as well as data from the U.S. Census, and Google Trends.
5
Member's Profile
It introduced me to statistical analysis CONCEPTS that I think I missed in my statistics classes in college…
5
Member's Profile
Excellent course - I very much enjoyed the material and found it to be particularly insightful and rewarding.
5
Member's Profile
Supporting material followed nicely with the videos. Explanations were easy to comprehend.
5
Member's Profile
Slides were extremely helpful to review, concepts laid out very plainly but informatively
5
Member's Profile
Loved learning about Benford's law. I also did not know a stock ticker was not unique!
5
Member's Profile
Very insightful, clearly explained and presented in a highly professional manner.
5
Member's Profile
Informative course, real examples separate from slides help drive concepts.
5
Member's Profile
Great instructor, Learned a lot and would suggest this to a college student.
5
Member's Profile
Helpful for understanding datasets and making sure your data is not fake
5
Member's Profile
Thorough explanations and good insight into techniques for merging data
5
Anonymous Author
Good course. Wish the answers to the quiz were available afterwards.
5
Member's Profile
Excellent course, very interesting topic and applicable knowledge.
5
Anonymous Author
learned ideas about excel that I did not know before, well done!
4
Member's Profile
Solid intro course - I'd be interested in the next level!
3
Member's Profile
Federal Reserve Bank data was useful information to have.
4
Member's Profile
Learned concepts on data base issues. Neat presentation
5
Member's Profile
Really good overview of data gathering and collection.
5
Member's Profile
I liked this course. Intersting subject matter.
3
Anonymous Author
changed my mindset as to the importance of BI
5
Anonymous Author
Very interesting information, good course
4
Anonymous Author
Useful material, well structured course
5
Anonymous Author
This material knocked my socks off!!!
4
Member's Profile
Very clear, concise and informative.
5
Member's Profile
I enjoyed the powerpoint very much
5
Member's Profile
Great course! Very informative.
4
Anonymous Author
enjoyable and informative
5
Member's Profile
Informative lesson
5
Member's Profile
insightful class
5
Member's Profile
Excellent Course
5
Member's Profile
liked the course
5
Anonymous Author
Great overview
5
Anonymous Author
Great course.
4
Anonymous Author
Great Lesson
5
Anonymous Author
Good course.
5
Anonymous Author
Great video!
5
Member's Profile
great course
4
Member's Profile
Good course
5
Anonymous Author
Very clear
5
Anonymous Author
Informative
4
Member's Profile
Very good
5
Member's Profile
Great

Prerequisites

Course Complexity: Intermediate

No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION and OVERVIEW
Collecting, Cleaning, and Merging Data
  5:32Assessing Data Bases
  10:08Gathering Data
  7:06Merging Data Sets
  8:48Cleaning Databases
CONCLUSION
  9:09Pitfalls In Building Datasets
Continuous Play
  41:41Business Intelligence – Collecting, Cleaning, and Merging Data
SUPPORTING MATERIALS
  PDFSlides: BI Collecting, Cleaning, and Merging Data
  PDFBI Collecting, Cleaning, and Merging Data Glossary/Index
REVIEW and TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM