299 Enrolled
0.5 Hours (On-Demand)
CPE Not Available
more
Michael McDonald, President
Michael is an associate with TRI Corporation, a training firm focused on cross functional and financial training doing work for Fortune 500 firms and holds a PhD in finance from the University of Tennessee.
This instructor has 21 courses »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: October 23, 2018
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
16 Reviews (127 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
(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
(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
(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
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.
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.
Anonymous
(Tax Manager)
Would have been nice to see what we should be doing in Excel. Hard to know if we did it right.
Martin Williams
(Finance Manager at think global Milengo GmbH)
Informative as always. I wish the lecturer had shown this work using an excel sheet.
Anonymous
(Owner)
Instructor mentioned excel spreadsheet to practice on but I don't see it anywhere.
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
Paul Gallagher
(Tax Associate at Grant Thornton)
Everything about this course was absolutely fantastic.
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 .