To Access This Course:
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)
- The Fundamentals of Business Intelligence (BI): What it Does and Why it's so Essential
- How is Industry Using Big Data? – A Case Study Reading
- Business Intelligence - Data Collection and Cleaning
- Business Intelligence - Structuring Data for Analysis
- Business Intelligence - Fundamentals of Data Analysis
- Business Intelligence - Using Big Data Analytics
- Doing Data Analytics In Excel (Hands-on module)
- Regressions in Excel (Hands-on module)
- Financial Forecasting
- Advanced Analytics – Omitted Variables
- Advanced Analytics – Fixed Effects
- Case Study in Data Analytics
- Using Regressions for Forecasting
- Financial Forecasting in Excel (Hands-on module)
- Blockchain for Business
35 Reviews (200 ratings)Reviews
Anonymous
(Manager)
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.
Anonymous
(Senior Internal Auditor)
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.
Anonymous
(Consultant)
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.
Anonymous
(Tax Associate)
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.
Anonymous
(Associate)
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.
Anonymous
()
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.
Anonymous
(Senior Associate)
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.
Anonymous
(Senior Analyst)
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.
Anonymous
(Manager, Programming Accounting)
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.
Anonymous
(Information Systems Support Analyst II)
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.
Anonymous
()
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
Anonymous
(Data Scientist)
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
Lawrence DeParis
(Founder & CEO at C-Level Solutions LLC)
Interesting topic. Presentation would be improved if the Excel worksheet were being illustrated in parallel with Mr. McDonald's narrative.
Hallie Chu
(Tax Associate at Grant Thornton LLP)
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.
Anonymous
(Regional Controller, North America)
This course was an interesting introduction on the concepts of using text documents to get an objective analysis of the data.
Tyler Hooks
(Derivatives Intern at Novelis)
I would have preferred to see a demonstration, but he demonstrates a good way to think about these types of problems.
Brian Poupore
(Tax Associate at Grant Thornton LLP)
Michael was clear and concise during this textual analytics case study, and made it easy to follow along.
Anonymous
(Sr. Associate)
I liked that we were able to use a real life example and that the course broke it down step by step.
Anonymous
(International Tax Sr. Associate)
I liked that we were able to use a real life example and that the course broke it down step by step.
Emily Peter
(Accountant at Charter Communications)
It would be helpful to have screenshots or a video of the instructor working through the exercise.
Anonymous
(Tax Manager)
Would have been nice to see what we should be doing in Excel. Hard to know if we did it right.
Devery Adair
(CFO at PLI Industries LLC)
Excellent case study on converting text for analysis. Like the fact that there were notes!
Martin Williams
(Finance Manager at think global Milengo GmbH)
Informative as always. I wish the lecturer had shown this work using an excel sheet.
Rose Gingrich
(State Report at GCCS)
This course was really easy, however, I got new concepts.
The instructor is awesome.
Anonymous
(Owner)
Instructor mentioned excel spreadsheet to practice on but I don't see it anywhere.
Anonymous
(Sr. Administrative Clerk)
Great course, learned about structuring big data and how to fit into spreadsheets.
Anonymous
(Tax Associate)
I thought this course was helpful because there was a real-life example used.
Anonymous
(Associate)
Course was informative and easy to navigate. I would recommend to a colleague
Anonymous
(Consultant)
Case study was a helpful example to follow and relevant to many businesses.
Anonymous
()
Very good explanation of data analytics and how it is intended to be used.
Anonymous
()
Good course for understanding the basics in unstructured data. Recommend
Christina Torres
(IA Coordinator at Loews Corporation)
I wish there was an visual step-by-step of the case analysis.
Paul Gallagher
(Tax Associate at Grant Thornton)
Everything about this course was absolutely fantastic.
Anonymous
()
The answers to the exam questions are not in the slides.
Andrea Gawkins
(Tax associate at Grant Thornton LLP)
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 .