432 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: November 21, 2019

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

34 Reviews (193 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
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.
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!
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
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
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