468 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: June 17, 2021

Included In Certifications

This course is included in the following Certification Programs:

15 CoursesCertified Data Analytics Professional (CDAP)

  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

37 Reviews (209 ratings)Reviews

4
Anonymous Author
This course was very informative and helpful. However, there was a slight confusion regarding the course supporting materials. For example 'Case 1 Exercise File" was referenced as Excel, but the actual file was a Word document. Apart from this, I will definitely recommend this course to others.
4
Anonymous Author
This textual analysis subject is new and interesting to me. However, the steps are not clear and there is a better way to summarize the data in Excel. Wish the case study were demonstrated during the course including the analysis of the results.
3
Anonymous Author
Good information but it was difficult to follow since I am not familiar with the Excel functions being used in the demonstration. I would like to see examples as the steps are discussed completed in the lesson.
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
It would be better to present the course in a detailed example rather than outlining the process, which made the technique a little elusive. Thanks for Mr. Michael‘ work.
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.
3
Anonymous Author
To complete the exercise takes a very long time to sort through Excel. Perhaps provide the .doc and a .xlsx that has been pre-formatted to speed things along.
3
Anonymous Author
This course was difficult to follow for those without a background in data analytics. It would be nice to be able to watch the instructor perform the tasks.
4
Anonymous Author
A good introduction to data analytics, but as previous reviewers have noted, it would have been helpful to see the actual process versus hearing about it.
5
Anonymous Author
Very useful. I will be able to use this for my internal audit function data analytics training for future analysts. Thanks for putting this together
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
Interesting topic. Presentation would be improved if the Excel worksheet were being illustrated in parallel with Mr. McDonald's narrative.
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.
4
Anonymous Author
This course was an interesting introduction on the concepts of using text documents to get an objective analysis of the data.
3
Member's Profile
I would have preferred to see a demonstration, but he demonstrates a good way to think about these types of problems.
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
Member's Profile
It would be helpful to have screenshots or a video of the instructor working through the exercise.
2
Anonymous Author
Would have been nice to see what we should be doing in Excel. Hard to know if we did it right.
5
Member's Profile
Excellent case study on converting text for analysis. Like the fact that there were notes!
2
Member's Profile
This course could have been really cool, but I couldn't follow the Excel directions....
4
Member's Profile
Informative as always. I wish the lecturer had shown this work using an excel sheet.
5
Member's Profile
This course was really easy, however, I got new concepts. The instructor is awesome.
4
Anonymous Author
Instructor mentioned excel spreadsheet to practice on but I don't see it anywhere.
5
Anonymous Author
Great course, learned about structuring big data and how to fit into spreadsheets.
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
Anonymous Author
Case study was a helpful example to follow and relevant to many businesses.
4
Anonymous Author
Very good explanation of data analytics and how it is intended to be used.
5
Anonymous Author
Good course for understanding the basics in unstructured data. Recommend
3
Member's Profile
I wish there was an visual step-by-step of the case analysis.
5
Anonymous Author
Very good class, informative materials and well presented
5
Member's Profile
Everything about this course was absolutely fantastic.
4
Anonymous Author
The answers to the exam questions are not in the slides.
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