299 Enrolled
0.5 Hours (On-Demand)
CPE Not Available
Instructor for this course
more

This course is a case study hands-on module giving participants experience in using unstructured data to do analysis through Excel.

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

Learning Objectives

  • Identify unstructured versus structured data
  • Explore how to turn a text document into quantitative data in Excel
Last updated/reviewed: October 23, 2018

Included In Certifications

This course is included in the following Certification Programs:

15 CoursesCDAP (Certified Data Analyst 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. Regressions in Excel (Hands-on module)
  9. Financial Forecasting
  10. Advanced Analytics – Omitted Variables
  11. Advanced Analytics – Fixed Effects
  12. Case Study in Data Analytics
  13. Using Regressions for Forecasting
  14. Financial Forecasting in Excel (Hands-on module)
  15. Blockchain for Business

16 Reviews (127 ratings)Reviews

1
Anonymous Author
As part of an overall course, the topic needed to be presented but it was on a very basis level. The case study was exceptionally hard to follow as they did not show it. Some of the steps for cleaning the data and moving it to excel were not described so if you did not have knowledge on how to perform those steps, the rest of the steps could not be accomplished.
4
Anonymous Author
I love how it gives a breakdown of the steps for taking completely unstructured data and organizing it so it is easier to read and analyze. This is something I can see doing on a regular basis.
4
Anonymous Author
Course was straight-forward, to the point, and relatively easy to understand. Getting all of the words into one column as presented by the instructor for the example was a nuisance.
3
Anonymous Author
This would have been significantly more useful had the instructor actually walked through the example in the presentation in excel, instead of just reading the slides.
4
Anonymous Author
This class was a very basic intro for those who are completely new to analytics but does not really provide any depth for those who are experienced
5
Member's Profile
I like the hands on learning with the case study since it allows me to go through the motions instead of just writing down steps.
5
Member's Profile
Michael was clear and concise during this textual analytics case study, and made it easy to follow along.
4
Anonymous Author
I liked that we were able to use a real life example and that the course broke it down step by step.
4
Anonymous Author
I liked that we were able to use a real life example and that the course broke it down step by step.
2
Anonymous Author
Would have been nice to see what we should be doing in Excel. Hard to know if we did it right.
4
Member's Profile
Informative as always. I wish the lecturer had shown this work using an excel sheet.
4
Anonymous Author
Instructor mentioned excel spreadsheet to practice on but I don't see it anywhere.
5
Anonymous Author
I thought this course was helpful because there was a real-life example used.
5
Anonymous Author
Course was informative and easy to navigate. I would recommend to a colleague
5
Member's Profile
Everything about this course was absolutely fantastic.
4
Member's Profile
Quick and easy video and quiz to follow and understand

Prerequisites

Course Complexity: Intermediate

Viewers should have completed all prior modules in the certification program before advancing to the hands on portion.

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
  5:15Introduction to Case Study in Data Analytics: Textual Analysis
  4:34Steps 1-3
  3:42Steps 4-6
  3:46Step 7
CONTINUOUS PLAY
  17:16How Does Industry Use Big Data: A Case Study
SUPPORTING MATERIALS
  PDFSlides: Case Study in Data Analytics
  DOCCase 1 Background
  DOCCase 1 Exercise File
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM