This course prepares participants to begin business intelligence projects at their own firm. The focus of the course is a hands-on approach to structuring data including generating new variables based on comparative and relative metrics. The structuring of these variables will be 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.***Prerequisites
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.
Learning Objective
- Discover how to evaluate data for accuracy using Benford’s Law
- Explore how to develop ratios and relative metrics to better evaluate data
- Explore how to develop moving average and other tools to smooth data over time
- Discover how to create binary variables and decile rankings to evaluate data structure
***Each of the objectives above will be covered in Excel, SAS, and Stata
Last updated/reviewed: July 27, 2025
(218) Reviews
(304 rating)This instructor gave an easy to follow overview of FBAR Issues. We must take into account that 2024 may have some differences such as maximum penalty. But this was a clear and concise presentation of the nuances regarding FBAR and Form 8938 Filings.
The course did a nice job and explained important, relevant information in a manageable and easy-to- digest manner.
I found the personality style quadrant very helpful in understanding my need for flexibility and learning "how to read the room." Much more flexibility compared to Myers-Briggs. I particularly appreciated the instructor's perspectives on how we can adapt our behaviors to work effectively work with counterparts who demonstrate different styles.
I've been using pivot tables for years and still picked up a few helpful hints in this lesson. This is a very useful session for any user.
This course relates specifically to ASC 985-605 - the prior revenue recognition standard. ASC 606 fully supersedes ASC 605, meaning that no specific components or guidance from ASC 605 are applicable to ASC 606. Companies must use the five-step model in ASC 606 as the sole guidance for revenue recognition. This course should be relabeled to ASC 985-605 to prevent new accountants from learning the revenue recognition rules that no longer apply.
This was an excellent course and I felt like it provided a guidebook for necessary courses of action and reminders for those trying to ascend in his/her careers.
This course provided a nice overview of safety and ergonomics in the workplace, including many best practices and tips. Several good takeaways that I can easily implement. Supporting materials were also helpful and aligned with the content presented during the course.
Good discussion but I don't think the answer for the first review question is correct.
I hope this could be a recording course. It took me a white to read this material. It may be easier if the instructor can show us how the formula works.
Rob does an outstanding job of effectively teaching the Key Performance Indicators and KPI Dashboards. The course was well-structured, providing a comprehensive understanding of KPIs and their critical role in measuring and driving business performance. The content was insightful and easy to follow, with a perfect blend of theory and practical examples. The section on creating KPI dashboards was particularly valuable, offering hands-on guidance on designing and implementing effective dashboards that provide real-time insights into business performance. The instructor was knowledgeable and engaging, making complex concepts accessible and relevant. The interactive elements and practical exercises helped reinforce the learning and provided me with the confidence to apply these concepts to my own work. Overall, this course is a must for anyone looking to deepen their understanding of KPIs and enhance their ability to track and manage performance effectively. I highly recommend it!
Good instructor and very informative. Gives a good overview of what should be considered.
What a fantastic course! This course was chock full of great tips and general ideas. Definitely a ton of "a ha" kind of moments and very helpful for those of us at the middle management level who would like to try to convince the Executive level that moving even at least to data mining would be helpful. Also, really appreciated the presenter's use of helpful visuals as well.
The excitement of the content combined with the enthusiasm and insight of Mr. Wasny make this course, along with those he presents on AI, the most inspiring and motivational I've experienced on this platform.
I believe that there is some audio repetition about half way through. Great course, might just want to take a look at that.
Very knowledgeable instructor with many years of experience. Appreciated the inclusion of strategies for every person involved as well as examples of risk factors.
The material is dense and detailed. Be prepared to read and reread to fully comprehend.
Both summary and detail examples were very helpful to introduce this power tool.
Its just an introduction, you wont learn practical uses of gpt in accounting, he just give us a bunch of example and why this tech is so life changing
Love Blair's webinars! Definitely wish there were more available on Illumeo. He is one of my facotire presenters!
Good ethics overview course with real life examples
Broader than payroll, also includes general accrual accounting steps
I thought this was a thorough and helpful course as a manager who deals with many different types of personalities on a daily basis.
Excellent refresher course and reference for future use. Instructor and materials are also excellent.
I especially appreciated the David Foster Wallace commencement speech at the end.
Great course covering many important concepts and history behind evolution of current accounting standards
Terrific insights and very applicable. I pulled out my notebook for this one.
Good information that should be revisited frequently.
good me gusto a lot, i want to be the best controller
Super clear instructions with excellent examples provided to work through.
Great introduction and clearly defines the various non profits and purposes.
This is a very comprehensive overview of the IPO process from the CFO perspective. It is particularly helpful to know the flow of the process from beginning to end, what parties are involved and their respective responsibilities during the IPO process as well as what one needs to pay attention and any related rules should be considered.
I suggest including study cases material that would allow us to understand more deeply the concepts with real life examples.
This a trending topic in current industries and gaining more focus for its use cases and utilization. The course provided a good introduction to this topic.
Great review of cash flows. The presenter does a great job of explaining, in an intuitive and common sense manner, the "Whys" of the trickiest financial statement.
I love this course! Practical and motivating, actionable advice to drive your business forward. Implementing advice right away.
I liked the easy explanations and the quality of the supporting materials. Having an excel workbook with quality examples is a huge plus. Thank you!
Mr McDonald moves at a fast pace; however, there are many individual skills apart from regressions I became more familiar with through this course. Specifically, I now understand IF statements and Is Number statements better.
Having a calculator to practice with, embedded in the course would be most helpful
Highly effective examples incorporated into the course.
Great information available in this course, will recommend to others.
The examples are very detailed, but if a simplified example could be shown, including the how the calculations are done, it would be very helpful.
I am very satisfied with the introduction of this course.
Might be too much information in once course, but it is great stuff.
This is a high-level overview of how to organize data analytics efforts and sell these services to the business.
The presentation was extremely well-ordered and seamlessly moved through teaching the facts then applying with examples of each approach.
Course is to the point, recognizes the pitfalls of risk management in todays large companies and provides relevant content.
Great Course. Very Motivating. Makes you think about what kind of leader you want to be.
A little dated. Needs to be updated to current outlook. some of the strategies go beyond outlook software and these are useful.
The best ethics course that I have taken. Thank you!
It was a good high level summary of the financial statements
I liked this course as I found that it was very informative and a great refresher on all the many methods and ways in which fraud can occur and be prevented as well.
Your courses have all been so wonderful, so informational, and so thorough--in short, greatly appreciated by me! Thank you for sharing your expertise, your wealth of knowledge, your inclusion of examples! I have greatly enjoyed reading and listening to all of your lectures thus far.
effective course for entry level email writing. course could show how to avoid so many emails to start with
Easy to follow. Relatable content. Clear presentation.
Excellent, is a great introduction to start and put hands on the data and work with it.
A very good course for providing best practices on how to run a presentation along with the actual research to back them.
Segregation of duties: one of my favorite topics in audit. This is definitely a much harder concept to implement in smaller companies where staff are limited.
Though the material in this course was well thought out and presented, I found it distasteful and unpatriotic to include a former president, not just as an example of an amoral/immoral leader, but also the answer to an exam question. Keep your politics out of my professional learning materials...
Excellent overview of the topic, with engaging examples and pulse checks. Wide range of subjects covered.
This is a good, quick refresher course to get your mind going during Covid isolation.
Being able to do each section individually and review it before moving on to the next section. I also liked being able to run the entire course to refresh before taking the exam.
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.
This course was very helpful. new tools for me to practice and master. If you work with data and excel this is the right course. take it and you will find that worth more than you imagine.
Very good class, informative materials and well presented
This course could have been really cool, but I couldn't follow the Excel directions....
I appreciate all of the practice. Lot's of problems help to develop proficiency at speed.
Fraudulent expense disbursements may happens at any kind of organization. This course will provides interest and necessary knowledge about the most common fraud type, also provides the techniques on how to identify it. Good course for everyone in professional organizations.
I found this second module to be more instructive/informational than the first with more actionable information.
This course was really interesting because I learned about some of the new things I can do with 365. Definitely recommended. However, digging into the differences between various versions of Excel is not too interesting.
It was great to review and/or learn anew these important topics.
Good accounting class that serves as a refresher for accounting basics.
the final exam questions are not clearly addressed in the slides.
Very well done explaining job costs. I have been in manufacturing for 30+ years and highly recommend this to anyone just entering this sector.
Awesome course. I finally understand what the Blockchain is and does. Many thanks
Explanation/presentation was very conversational and provided a lot of insight based on real experience with the legislation.
Great course for being introduced to the Blockchain world
The course itself was fantastic. I would take pieces of it again as refreshers. Given the final exam is 160 questions, I would have been better suited to take the classes in two hour chunks with credit after each class. It was also incredibly frustrating to answer the same question numerous times in the final exam.
Fraud: Focus on Internal Controls to Prevent and Detect Fraud is a good overview course. The instructor used good examples and highlighted good outside resources.
Great info! Informative and easy to understand. I liked that it was broken up into smaller chunks.
Great tips for Excel! Instructor has a very energetic and entertaining style!
This course is very practical. The instructor made the topic very relatable and provided simple, easy to implement tools for connecting. Excellent!
Outstanding course! Learned a ton in a short amount of time.
The hands-on part of this module was effective, but the final exam had some grammatical errors that made it more esoteric than necessary.
I notice that most audits are not using this risk based auditing mentality, so learning about it now makes me want to find a way to implement it into my firm!
Great introduction to Blockchain and how it can be used for business. I hope that this catches on and that businesses will use block chain in day to day business.
Presenter gave an effective overview of the topic, including benefits and applications. Briefly discussed why it has not yet "arrived," but explains the potential.
Good course and interesting material presented. Would recommend to anyone interested in blockchain.
The hands-on application of regression analysis, though simplified, was helpful in understanding how to interpret the results
Sussman is excellent. He was one of my MBA professors so I was excited to see him on this platform. If he's teaching a class, you want to take it.
Great stuff as always, Michael. Thanks to Grant Thornton for making this available.
Seems silly to have an exam on this topic, probably because I watched the video after completing 10 Illumeo courses. :-)
The course is general enough for most audiences, but doesn't expand on topics enough for those who work in a cyber-related role.
This was a nice comprehensive overview of blockchains and their uses.
Overall good. Some repetition from prior courses but actually this one pulled together the earlier concepts and made them more relevant.
This course was great. The material was clear to understand.
Would have been nice to see what we should be doing in Excel. Hard to know if we did it right.
Although I thought the examples to be very helpful, I felt a little confused throughout this one.
It is interesting to learn about how to choose variables and how to look out for omitted variables.
Course was informative and easy to navigate. I would recommend it to a colleague.
The course did a very nice job and explained important, relevant information in a manageable and easy-to-digest manner. The instructor was efficient and broke down the topics in an understandable way.
This course was informative and provided the basics beyond using regressions for forecasting.
This course provides a good overall view of what composes ethics and what influences it within an organization
The real life examples were helpful to walk through
Gives you just enough information to be dangerous, but not enough to be reliable.
Great course, always insightful content. Learned a bunch of new regression material
Many supporting materials didn't open. Many supporting materials didn't open.
I do not think that this explained block chain well
this was good. it seemed similar to the last course i took, but it was good to learn.
This course provides a good general overview of how to structure data appropriately. The emphasis on financial ratios and metrics seems overly specific to one domain, but makes sense given the instructor's background.
The course had a large amount of overlap between the Data Collection and Cleaning course
I liked this course's description of BI tools like Tableau and data analytic tools like R.
Liked the next steps section especially that concisely illustrates what is to come in analytics. Very straightforward course in general and easy to understand.
Overall great webinar. It would be helpful to reduce the number of abbreviations in the slides though.
Some people just aren't great managers and lack the common knowledge even taught in this course to improve.
Very nice - I like the course and the image of the flat file...as it is probably similar to what a lot of people are seeing.
The modules were very helpful to understand the material.
I appreciated how the instructor took his time in explaining definitions and how to manipulate the data.
good course except that the presenter's screen was blurry and I couldn't see clearly
This was an excellent overview of fundamental excel functions. I love the multiple uses of examples.
Good review of strategic business partnerships that help prepare for change management projects.
Great introductory course. Love how the presentation was well prepared.
Decent look into regression, sample size of the data was unrealistically small which took away from the learning possibilities.
Michael made it easy to understand the importance of fixed effects in advanced analytics
Regression in excel is very helpful to analyze dummy data. I would like to recommend this course to anyone who is working on analyzing data. By learning this skill is helpful to increase work efficiency.
I thought this course was helpful because there was a real-life example used.
Great course. wish there was more time to learn. had hard time following along.
This course did a very good job of going in depth with its explanations of regression analysis.
Great class!
Good review course. Fairly simple accounting concepts.
I found this module somewhat confusing and abstract compared to previous modules. Hands-on examples would've helped distill your points.
Very informative and organized in an easy to follow method. Enjoyed the training.
Manipulating the data and walking through step by step is very helpful
I think it's a widely held belief that in order to be considered smart just throw the word bitcoin around. I think I can hang in there now.
This course was short, sweet, and straight to the point. The material was interesting and it was easy to stay engaged throughout.
I found this course to be helpful. This material was new to me and interesting to learn about.
Great Comprehensive review of this decision to those unfamiliar with SALT concepts.
this one, although hands on, was dry and difficult to hold my attention the entire time
This exam was more challenging than the others! Good to see.
It says that theory is easy but applying is hard. We are doing theory....
Very informational course. The mid-section can be a bit bland, but it's very useful knowledge.
This course provided great examples of data collection techniques.
The speed of the presenter when talking was way too fast. We were learning about presenting to non financial managers and I could not keep up with the flow of information. Way too fast and way too much.
This was a good but examination of ethics starting with various scandals and ethics violations to COSO standards to the best practice policies in creating an ethical culture from the top down at a company.
Good discussion on recognizing revenue under the new revenue standard.
Great refresher for terms and ideas I learned in college. Also helped me find more practical applications of each topic
Good insight in personalities and leadership. Excellent explanations of human behavior
Continues to build on the past courses well. I look forward to the next courses
One of the questions was wrong. It asked about the Z score but referenced marketing rather than bancruptcy.
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.
I wish there were more examples rather than just slides.
Everything about this course was absolutely fantastic.
It was very helpful to see a live excel demonstration of how data can be analyzed in real time.
Interesting and easy to follow. Taught some topics that I had doubts on.
Very interesting and insightful course on new data analytics techniques.
Good course.... does a good job of introducing basic concepts.
Great introductory course covering data gathering, merging large data sets, and data cleaning.
This course was very useful. It was a good follow up to the Business Intelligence: What is it and why course.
I thought the course was fine for a basic level of knowledge on what BI was as well as some of the advantages and disadvantages.
Good introduction and overview of data collection and cleaning.
This course helped me prepare for a training. I really feel like I got a good foundation.
very good introduction into an area I've never studied
It met all the stated objectives. I thought it was more interesting than the previous two sections.
The course material was good and simple. I would suggest adding more examples at each level.
The course highlights some key strategies to "clean" your data. Before this course, I did not know the importance of cleaning data. I now feel that I can take these strategies and directly improve my analysis.
I think this was a good introduction to Business Intelligence.
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.
I thought the course provided good detail on a number of the tools available to use for analytics. The time allotted was also very reasonable.
Pretty interesting, especially the stuff on benfords law
Great final course to take that sums up data and analytics. good examples
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.
Although shorter and more applicable than the last course I completed (Business Intelligence), the case study seemed to be more a repeat of the slides, as opposed to a case study under the academic definition.
I felt the valid test data question was confusing, but other than that, it was a good course!
Very in depth overview of TCJA. This really helped my understanding of which tax items have been modified or kept.
I thought the review was thorough and introduced the site very well.
Exactly what I needed, added many of the missing pieces for me. I like the format, showing what to do then, doing it. My only gripe is that the exam has questions on charts when no charts were in the course material.
The overlap of information on the slides makes it hard for reference purposes.
very interesting and I would suggest this course to a college student.
I like how the course was broken up, and how you are able to access the slides.
This was a very informative video to help me learn more.
Really enjoy how Marc & Paul present together - engaging!
Good overview of models and high level theories, but would have liked to see some of the examples actually done in Excel or another tool.
I love how you used very clear and specific examples! Thank you Leslie!
Good overview of the Segregation of Duties method of review and of why its important
The instructor explains the concepts with relevant examples which makes it easy to understand and apply. The course is well structured and detailed to provide step by step procedure for creating RBIA approach.
Some more error rectification technique may be included in this course.
Solution for problems - if you can show via formulas with data input or in excel that would be very helpful
Very comprehensive and extremely thorough.
Didn't realize QB was this powerful. Good overview.
Great Course!
Great Course
Very helpful
Very informative course!
Tough overall but a great course
Tough course
Great course.
Short, but very well put together and very informative, nicely done!
Great Course!
Difficult but enjoyable
Great Course!
Great time.
Great Course!
Good course.
Helpful for understanding datasets and making sure your data is not fake
detailed and informative
Slides were extremely helpful to review, concepts laid out very plainly but informatively
Fantastic Course
Great course. Even better teacher. Sorry it's late.
Interesting stuff
Great slides and easy to follow. Highly Recommend!
I worked as an accounting professor for a few years and had a similar style to teaching. It is extremely effective. Nice review sir.
Great tips!
Great overview
Excellent course
Enjoyed it.
Great course!
excellent refresher
Good refresher on SEC Reporting and structure of reports
The course is great, however, the video sometimes disconnect in the middle and have to wait and drag to make it work




Ask the instructor a question about this lesson