Instructor for this course
more

This course prepares participants to begin running data analysis on databases. Both univariate and multivariate analysis are covered with a particular focus on regression analysis. Regression analysis is done in Excel, SAS, and Stata to give viewers a sense of familiarity with a variety of different software package structures. The focus in this course is on financial data though the techniques are also applicable to more general forms of data like that used in marketing or management analyses.

Course Series

This course is included in the following series:

7 CoursesBusiness Intelligence

  1. The Fundamentals of Business Intelligence (BI): What it Does and Why it's so Essential
  2. Business Intelligence – Collecting, Cleaning, and Merging Data
  3. Business Intelligence - Structuring Data for Business Analysis
  4. Business Intelligence - Fundamentals of Data Analysis
  5. Business Intelligence – Applying and Using Data Analysis
  6. Pricing Strategy with Business Intelligence
  7. Financial Forecasting and Business Intelligence

Learning Objectives

  • Explore how to run basic univariable analysis of means, medians, and percentiles on a dataset
  • Explore how to run simple regression analysis on a dataset
  • Explore how to run instrumental variables analysis on a dataset
  • Explore how to run probit/logit analysis on a dataset
  • Explore how to run fixed effects regression on a dataset
  • Explore how to run difference-in-differences analysis on a dataset

*Each of the objectives above will be covered in Excel, SAS, and Stata

38 Reviews (121 ratings)Reviews

Member's Profile
Highly knowledgeable instructor, I found the first 3 programs in this BI series very interesting. This one however gets too deep into statistical methods -- too deep to be considered informational but not nearly deep enough (due to time constraints) to be instructional at a level that you could utilize the techniques. Makes me think I need to retake my stats class.
3
Member's Profile
Completely correct and accurate, but a bit more sophisticated and academic for most simple business analysis. More applicable if working with large scale sophisticated analysis projects.
4
Member's Profile
Insightful but at times extremely specific for a basic course like this, which made it confusing rather than helping, but all in all useful course
5
Member's Profile
I really enjoyed the course. Professor McDonald spoke very well and I enjoyed how he broke down and spoke about Fundamentals of Data Analysis.
4
Member's Profile
More complex statistics in this one & I struggled more with it, but great to learn about more advanced statistical analysis.
4
Anonymous Author
What this helped me figure out is that I should not do much data analysis without starting with a beginners course!
4
Anonymous Author
Too short of a learning period for those who do not deal with this type of statistical analysis on a regular basis.
5
Member's Profile
Course is perfectly designed for a young practitioners, who want to learn about business intelligence.
4
Member's Profile
excellent information. I wish I were more up to speed on this and will probably have to rewatch it.
3
Member's Profile
A little too slow for my taste, could find a way to bring some gusto to this subject matter.
5
Member's Profile
A useful and technical course topic which was presented in a clear and concise manner.
4
Anonymous Author
Nice basic course. The SAS vs Stata was not particularly helpful to me, personally.
5
Member's Profile
Informative in learning how to write code for regression analysis and analyzing data
5
Member's Profile
a lot of good information. Would be interested to see this as a longer class.
5
Anonymous Author
Very helpful. Powerpoint and resources made the material easy to understand.
3
I would have liked more examples of analytics and less of a stat class.
5
Member's Profile
Well explained, clear and thorough for the intended purpose.
5
Member's Profile
Good overview of basic data analysis tools and techniques.
5
Anonymous Author
Complex issues explained in simple way to comprehend
3
Member's Profile
Not as practical as I might have liked.
5
Member's Profile
not bad, technical but that is a plus
5
Member's Profile
Very detailed and thorough.
5
Member's Profile
Informative Lesson!
5
Member's Profile
Amazing course!
5
Member's Profile
Fantastic Course
5
Member's Profile
Easy to follow.
4
Member's Profile
Tough but good
5
Anonymous Author
Great course!
5
Member's Profile
Great course.
5
Member's Profile
Great course!
4
Anonymous Author
Great course!
5
Anonymous Author
Great course!
5
Member's Profile
Great Course
5
Member's Profile
great course
5
Member's Profile
he is great
5
Member's Profile
well taught
3
Member's Profile
none
5
Member's Profile
na

Prerequisites

Course Complexity: Foundational

No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.

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
  1:17Introduction to Business Intelligence - Fundamentals of Data Analysis
Fundamentals of Data Analysis
  9:26Overview of Analysis
  14:23Univariate Analysis
  11:51Regression Analysis
  9:04Advanced Regression Analysis
  9:00SAS V. Stata
CONCLUSION
  3:22Preview of Using Analysis
Continuous Play
  58:23Business Intelligence - Fundamentals of Data Analysis
SUPPORTING MATERIALS
  PDFSlides: Fundamentals of Data Analysis
  PDFFundamentals of Data Analysis Glossary/Index
REVIEW and TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM