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.

***Please download and open all supporting materials before starting the course videos.***

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

Last updated/reviewed: June 28, 2018

Included In Certifications

This course is included in the following Expert Certifications:

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

78 Reviews (441 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.
4
Anonymous Author
The course had good information about the different types of aspects of the regression analysis and good definitions. I think the showing of the regression outputs and reports didn't really do much for me as the explanation didn't help. Went a little fast at that point.
4
Member's Profile
Course helped to explain predictive statistical techniques. Was a nice refresher of topics covered in our grad school statistics course. Felt a little bit like an ad for other software platforms that won't ever be covered in this series.
3
Anonymous Author
This seemed to be highly repetitive of the earlier courses for Business Intelligence, with an over emphasis on using Stata. An example that is walked through would have been more useful that screenshots for stata inputs/setup.
4
Member's Profile
A deep and technical dive into Data Analysis techniques such as: univariate analysis, regression analysis, advanced regression analysis. As well as giving an overview of various statistical techniques (z-score, etc).
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.
5
Member's Profile
Very thorough on how to use statistical analysis and other types of analysis for analyzing different types of data. Excellent job tying the information back to real-world application.
5
Anonymous Author
There was a little bit of duplicated information between this lesson and past lessons, but overall the information was helpful and taught specific techniques and vocabulary.
4
Member's Profile
I wish that the course was just slides. I think having a live screen where what he is saying is actually being done would be really engaging for those trying to learn.
4
Anonymous Author
Good course, a little difficult because it is a bit technical for non statistical professionals or auditors who have not been exposed to data analysis at such level.
3
Anonymous Author
A little hard to follow if you have never done a regression analysis. Having an easy sample regression and walking through all the steps would help.
4
Anonymous Author
This course was interesting. I liked the examples used. I didn't like the use of code or reference to not being able to discuss in this course.
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.
5
Member's Profile
great basic intro into fundamentals of data analsys. Excellent overview of regression analysis and variables. shows shortfalls of using excel
4
Anonymous Author
I liked the material covered in this course. I have not been exposed to this information in any of my prior learning experiences. Thank you!
3
Anonymous Author
This course had seemed to revisit/expand on material presented in earlier courses. Overall the material was interesting, and worthwhile
5
Member's Profile
WOW this was quite an experience. Learned an enormous amount so I can speak the big data analysis language with my statisticians.
4
Anonymous Author
It was nice to move from just theoretical terms and concepts and definitions to actual visuals of regressions and 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.
5
Anonymous Author
This was a very good course that taught me a lot about statistics. learning regression analysis would help better my career
5
Member's Profile
Michael did a great job displaying the importance of the fundamentals of data analysis in a way that was clear and concise.
4
Anonymous Author
This material was less interesting than the concepts covered in previous chapters. Still, I think it was well taught.
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.
3
Anonymous Author
This course was extremely hard for me. People who love statistics and data analysis would thrive in this course.
5
Anonymous Author
This was an interesting course that gave a good high-level overview of different types of data analysis
5
Member's Profile
Course is perfectly designed for a young practitioners, who want to learn about business intelligence.
5
Anonymous Author
I like the regression analysis part of this lecture, I feel like it is helpful to gather needed data.
4
Member's Profile
excellent information. I wish I were more up to speed on this and will probably have to rewatch it.
4
Anonymous Author
I liked how the professor gave examples of when each type of statistic or analysis would be used.
5
Anonymous Author
I found this course to be helpful. This material was new to me and interesting to learn about.
3
Member's Profile
A little too slow for my taste, could find a way to bring some gusto to this subject matter.
5
Anonymous Author
This course has allowed for the understanding of the fundamentals of statistical analysis.
4
Anonymous Author
This provided a very well-rounded review of data analytic measuring formulas and models.
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
4
Anonymous Author
Good information, some of the slides discussing the regression were alittle messy
3
Anonymous Author
The course was somewhat confusing with all of the different terms and variables.
5
Member's Profile
a lot of good information. Would be interested to see this as a longer class.
4
Anonymous Author
I liked that the instructor went over multiple examples to explain the analysis
5
Anonymous Author
Very helpful. Powerpoint and resources made the material easy to understand.
5
Member's Profile
Great course, building upon the previous coursing and connecting the topics!
5
Member's Profile
great instructor and I would recommend this course to a college student
3
I would have liked more examples of analytics and less of a stat class.
5
Member's Profile
course was confusing even though I have taken many stats courses before
5
Member's Profile
A good build on the previous course. Good for improving my background
4
Member's Profile
The material was very helpful in teaching this lesson, great job!
4
Anonymous Author
Good course for getting to know the fundamentals of data analysis.
3
Anonymous Author
I thought the information presented was dry and hard to follow
5
Member's Profile
Well explained, clear and thorough for the intended purpose.
4
Anonymous Author
Good dive into regression and various forms of data analysis
4
Anonymous Author
Good course. Would recommend. Will be taking more courses.
5
Member's Profile
Good overview of basic data analysis tools and techniques.
2
Member's Profile
Too complex a topic to try to fit into a one hour webinar
5
Anonymous Author
I wish there were more examples rather than just slides.
5
Member's Profile
Everything about this course was absolutely fantastic.
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