33 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: May 01, 2018

Included In Certifications

This course is included in the following Expert Certifications:

15 CoursesCertified 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

3 Reviews (7 ratings)Reviews

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.
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