1 CPE 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: March 25, 2024
Included In Certifications
This course is included in the following Certification Programs:
15 CoursesData Analytics Professional (DAP) Certification
- 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
113 Reviews (611 ratings)
Reviews
Edward Thill
(Consultant at None)
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.
Anonymous
(Project Management)
What is this question ?
The Altman Z statistic measures the efficiency of a firm’s marketing efforts over the past:
The Altman Z score is about the probability of bankruptcy in the next two years... It has nothing to do with measuring marketing efforts .. How is this an exam question ?
Anonymous
(senior tax associate)
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.
Anonymous
(VP, WFM and BusTech)
This course provided a great overview of data analysis fundamentals. Admittedly, data analysis isn't my strong suite; however, I have a great appreciation for the insights it provides, so I found this course to be a good refresher in building my data analysis acumen.
Anonymous
(CFO)
This was a lot of information to cover in one class in enough depth to get a clear understanding of the topic. The information was useful for a broad overview. I would have liked to have the copy of the excel file so that I could follow along with the instructor.
Anonymous
(Senior Business Consultant)
Of Michael's Business Intelligence lessons, this was by far the most technical and a bit of a departure from other theory-based lessons; as a result, it was less relevant for me as I'm looking to gain an overview of data analytics principles.
Aaron Walters
(Associate at Grant Thornton)
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.
Anonymous
(Senior Associate)
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.
Brian Leip
(Asst. Controller at Kranz & Associates)
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).
Laura Antunano
(Manager at Carnival)
It was a lot of content for a one-hour course. Would have preferred to have a one hour course to better cover methodology with examples, then maybe get into Strata and SAS in a follow-up course.
Cynthia Lam
(Executive Director, Corporate Controller at CytomX Therapeutic Inc)
The course provides a very high level introduction of data analysis methods but the review questions or the exam questions are not as straight forward as covered by the handout or the recording.
Michael Fairchild
(Retired at Retired)
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.
Nick Zuzula
(Senior Associate at Grant Thornton)
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.
Anonymous
(Tax Associate)
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.
Tal Crook
(RAS Associate at RSM)
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.
Anonymous
(Manager)
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.
Anonymous
(Director of Accounting)
Slides were informative, but not descriptive enough to use to study for final exam. Did we really need to see the coding for SATA or SAS in several of the slides?
Anonymous
(CEO/Founder)
Excellent information in this course but your exam was so far off base and there is no way, even though you say there is, to review missed answers on the exam.
Alejandra Chacon
(Snr.Assistant Controller at Oracle + NetSuite)
I like it veru much, with a seneebof learning more about stadistics, is such a great tool to analyse, and if i get enough expertise it wilk be very valuable.
Anonymous
(Senior Tax Associate)
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.
Anonymous
()
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.
Antoaneta Tasheva
( at European University Institute)
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
I really enjoyed the course. Professor McDonald spoke very well and I enjoyed how he broke down and spoke about Fundamentals of Data Analysis.
Wayne Burns
(CFO at Lone Tree Inc)
great basic intro into fundamentals of data analsys. Excellent overview of regression analysis and variables. shows shortfalls of using excel
Anonymous
(Senior Tax Associate)
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!
Josh Schmitt
(Tax Intern at Grant Thornton)
This course was quite effective at describing data analytic techniques, but did focus a bit on Stata toward the end which narrows the scope.
Anonymous
(Senior Auditor)
Thanks for the well explained data analysis tools. It was clear easy to follow. Examples were helpful in the understanding of concepts.
Anonymous
(Tax Associate)
This course had seemed to revisit/expand on material presented in earlier courses. Overall the material was interesting, and worthwhile
Lawrence Hirsch
(Controller at Builders design)
WOW this was quite an experience. Learned an enormous amount so I can speak the big data analysis language with my statisticians.
Anonymous
(Data Scientist)
this was a good re-introduction to basic linear math from high school however when previously learn used y=mx+b instead of y=B1x+B0
Anonymous
(Tax Associate)
It was nice to move from just theoretical terms and concepts and definitions to actual visuals of regressions and data analysis.
Anonymous
(Assistant Internal Audit Manager)
The course provides knowledge about the different types regression analysis. The information was useful for a general overview
Margaret Winn
(Accounting Professional at .)
More complex statistics in this one & I struggled more with it, but great to learn about more advanced statistical analysis.
Paul Morris
(Director, Compliance and Insurance at Sam Houston State University)
Excellent baseline presentation of complicated material. Michael presents in a format that is easy to follow and re-review.
Anonymous
(Tax Associate)
This was a very good course that taught me a lot about statistics. learning regression analysis would help better my career
Brian Poupore
(Tax Associate at Grant Thornton LLP)
Michael did a great job displaying the importance of the fundamentals of data analysis in a way that was clear and concise.
Anonymous
(Not Provided)
This is a brief course. I believe there is a lot more that could be said on Data Analysis, if there was enough time for it.
Anonymous
(Tax Associate)
This material was less interesting than the concepts covered in previous chapters. Still, I think it was well taught.
Rose Gingrich
(State Report at GCCS)
Great course, it was more complex than the others but very interisting , I learn new concepts.
Thank you instructor
Anonymous
(Board Member)
What this helped me figure out is that I should not do much data analysis without starting with a beginners course!
Anonymous
(Senior Accountant)
Too short of a learning period for those who do not deal with this type of statistical analysis on a regular basis.
Anonymous
(Accounting Technician)
This course was extremely hard for me. People who love statistics and data analysis would thrive in this course.
Anonymous
(Management Analyst II)
Good overview of statistical analysis; difficult topic to get into but supporting materials were useful.
Anonymous
(Tax Associate)
This was an interesting course that gave a good high-level overview of different types of data analysis
Janis Balodis
( at European University Institute)
Course is perfectly designed for a young practitioners, who want to learn about business intelligence.
Anonymous
(Tax Associate)
I like the regression analysis part of this lecture, I feel like it is helpful to gather needed data.
Tim Thomas
( at Tim Thomas CPA LLC)
excellent information. I wish I were more up to speed on this and will probably have to rewatch it.
Anonymous
(Tax Associate)
I liked how the professor gave examples of when each type of statistic or analysis would be used.
Anonymous
(Tax Associate)
I found this course to be helpful. This material was new to me and interesting to learn about.
Anonymous
(Finance and IT Consultant)
Great course, but not seem to be for beginners; could be considered as advanced. great job!!!
Jeff Bone
(Financial Advisor at Northwestern Mutual)
A little too slow for my taste, could find a way to bring some gusto to this subject matter.
Anonymous
(Senior Associate)
This course has allowed for the understanding of the fundamentals of statistical analysis.
Ricardo De Alba
(Controller at Harvest Church)
Very thorough discussion. Much more technical than previous courses, but very informative.
Anonymous
(Associate I)
This provided a very well-rounded review of data analytic measuring formulas and models.
Keith Baker
(Data Analyst at Charter Communications)
good overview of regressing analysis. understanding of types of regression and how used.
Frank Perillo
(Not Provided at Frank Perillo CPA)
A useful and technical course topic which was presented in a clear and concise manner.
Anonymous
(President)
Nice basic course. The SAS vs Stata was not particularly helpful to me, personally.
Forrest Savage
( at Fairfield University)
Informative in learning how to write code for regression analysis and analyzing data
K Harper
( at JLL)
EXCELLENT OVERVIEW OF DATA USAGE AND LIMITATIONS IN THE BI WORLD AND USE FOR CPA'S
Anonymous
(Senior Associate)
Great class as always Michael. Easy to follow along with and good job explaining.
Anonymous
(Tax associate)
Good information, some of the slides discussing the regression were alittle messy
Anonymous
(Associate)
The course was somewhat confusing with all of the different terms and variables.
Anonymous
(Lumen Audit Associate)
Gives you just enough information to be dangerous, but not enough to be reliable.
Andrea Jones
(Accountant at Capital One)
a lot of good information. Would be interested to see this as a longer class.
Anonymous
(Sr. Associate)
I liked that the instructor went over multiple examples to explain the analysis
Anonymous
(Associate)
Course was informative and easy to navigate. I would recommend to a colleague.
Nicole Goodwin
(Director of Chemistry, Stress & Repa.. at GSK)
This was very informative. I didn't know any of this information before hand.
Anonymous
()
Very helpful. Powerpoint and resources made the material easy to understand.
Great course, building upon the previous coursing and connecting the topics!
Anonymous
(Controller)
I would have like more detail and practically how to apply these techniques.
Alex Bonn
(Student at Fairfield University)
great instructor and I would recommend this course to a college student
Anonymous
(Tax Senior Associate)
The presenter did a good job of walking through the regression analysis.
Wendi Finn
View Instructor Profile
I would have liked more examples of analytics and less of a stat class.
jim Klimkowski
(Principal at RSM)
course was confusing even though I have taken many stats courses before
Anonymous
(Sr. Accounting Analyst)
Interesting course laying a basis of what can be used for Data Analysis
Dave Rogers
(Senior Associate at Grant Thornton)
A good build on the previous course. Good for improving my background
Anonymous
(Internal Audit)
Not for the faint of heart. There is real information in this course.
The material was very helpful in teaching this lesson, great job!
Anonymous
(Proprietor)
This is a very useful course for CMAs. I recommend it to everyone.
Anonymous
(International Tax Sr. Associate)
Good course for getting to know the fundamentals of data analysis.
Anonymous
(Staff Accountant)
I would recommend this course to my colleagues. Very informative.
Anonymous
(Tax Associate)
I thought the information presented was dry and hard to follow
Phyllis Chan
( at Golden Krust Caribbean Bakery Inc)
too complicate for someone who are not familiar with BI tools
Anonymous
(Accountant)
Clear and Concise course. Learned a lot about analyzing data.
Bruce Reed
(Chief Financial Officer at PracticeLink)
Well explained, clear and thorough for the intended purpose.
Anonymous
(Associate)
Good dive into regression and various forms of data analysis
Anonymous
(Senior Associate)
Good course. Would recommend. Will be taking more courses.
David Skipper
(Senior Associate at Grant Thornton Public Sector)
Thanks for the interesting course, learned a lot about data
Chris Grimes
(Rules Master at Cisco)
Good overview of basic data analysis tools and techniques.
Lawrence DeParis
(Founder & CEO at C-Level Solutions LLC)
Too complex a topic to try to fit into a one hour webinar
Alisa Gay
(Audit Services Manager at Southwestern Energy)
Very good class, informative materials and well presented
Anonymous
(Innovation Manager)
I wish there were more examples rather than just slides.
Paul Gallagher
(Tax Associate at Grant Thornton)
Everything about this course was absolutely fantastic.
Anonymous
(Senior Financial Analyst)
Complex issues explained in simple way to comprehend
William Lathrop
(- at Artful Home, LLC)
Not as practical as I might have liked.
valerie mclaughlin
(Not Provided at n/a)
not bad, technical but that is a plus
Simon Adell
(Chief Financial Officer at Undisclosed)
Very detailed and thorough.
Henry Guo
(Analyst at Fairfield University)
Informative Lesson!
Amazing course!
John Daniels
(Sutdent at Fairfield University)
Fantastic Course
Michael Maffucci
(student at Fairfield University)
Easy to follow.
Brendan Lynch
(Research Intern at InSite Search A Division of Chaves &..)
Tough but good
Anonymous
()
Great course!
Gianni Sbarro
( at Fairfield University)
Great course.
William Woods
( at Fairfield University)
Great course!
Anonymous
()
Great course!
Anonymous
()
Great course!
Fred Neftin
(student at Fairfield University)
Great Course
great course
Hale Summers
( at Fairfield)
he is great
Joseph Murphy
(None at Fairfield University)
well taught
Erin Milroth
(Assistant Controller at -Edifice, Inc.)
none
Jacob Petersen
(Financial Analyst at DLL Group)
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 Questions and Answers1 Question
There are no questions. Answers to Frequently Asked Questions (FAQs)
Michael McDonaldPresident
About Illumeo
Platform
Resources
Contact Us
- Email: info@illumeo.com
- Phone: 408-400-3993
- Adress: 1608 W Campbell
- Av #221, Campbell, CA 95008
© 2024 Illumeo, Inc.