Business Intelligence - Data Collection and Cleaning 1 CPE

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.

Of the many, many courses I have taken on the Illumeo platform, this was definitely one of the best and most insightful. I have always found elements of "behavioral finance" to be fascinating and powerful in planning, strategy, and business performance. Mr. Stephens has bundled the leading theories and presented them as a unified new "dimension" for planners and leaders to factor in. He has done so in a manner that CFO's and other business leaders will undoubtedly find easy to digest, replete with useful examples. The consideration of these concepts will undoubtedly add value via improvement decision-making and more enlightened risk assessments. Thank you for such a quality contribution to the Illumeo portfolio!!

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!

I just went through a difficult situation and thus was taking this class so as to understand how I handled the whole situation. This is a great course and very helpful. I will definitely come back to review the slides from time to time. When Lynn mentioned that we should really pat ourselves on the back for handling the difficult situation, I truly felt relieved. My family and friends could not understand my decision of disconnect with the gangs of difficult leaders, perhaps perceiving me as a loser; however, Lynn appears to really understand what I went through and her lecture covers all aspects of this kind of situation. I recommend this course to anyone who needs it!

Good overview of the budget process. The materials are really helpful.

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.

good course, a lot of good information provided verbally and not in slides.

Detailed instruction by author. Refresher course still if you know Excel.

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

It's in a very high level . The slides are good but very difficult to understand for ppl without accounting background.

Love Blair's webinars! Definitely wish there were more available on Illumeo. He is one of my facotire presenters!

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.

Well thought-out content and presentation. Periodic mis-spell and various fonts made it seem less professional and the course was prepared on the fly with heavy Covid-19/Zoom fatigue :)

This was a great course to introduce me to features of excel that I have never used to give me a great understanding of how they might be used in practical everyday applications of Excel.

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.

good me gusto a lot, i want to be the best controller

Very well explained the concept with proper examples. Helps a lot for the corporate cost analysis. Really enjoy the course and easy to follow on his explanation. Great lectures and I will take more of Erik's courses.

Well structured overview of the course by instructor

Super clear instructions with excellent examples provided to work through.

The lecture is very organized and easy to follow. I am experienced user of Pivot table so the Final exam was not difficult, yet I have learned some functions I did not know. I really enjoyed it!

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.

This is, in no way, a 1.5 hour course if you are to attempt to "Learn by Doing" as instructed on slide 11.

Excellent! This will lead better comunication. White spaces are realy an important.

Good material and overview of SAAS metrics. Sound was a little low could be increased but otherwise good

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.

The Course was very engaging and provided great examples of real life. The instructor is very enthusiastic and content is to the point.

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!

I found this course to be alright at most. There was so much being said and too much information on the slides, it made my head hurt trying to learn just the principles

Having a calculator to practice with, embedded in the course would be most helpful

Very simple and effective. Learned so much that I took for granted. Your approach in using simple examples to focus on the feature and function is very practical.

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.

Lynn, the generational divide is an important concept to understand when hiring. This class helps me to understand the challenges in how I must lead the different members on my Team. The biggest challenge is in group meetings and in Team building. This course is very helpful. Thank you, Larry

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.

Great training and course. Easy to understand. Thank you.

A little dated. Needs to be updated to current outlook. some of the strategies go beyond outlook software and these are useful.

this is a good course for anyone who wants to get involved in the fp&a process

The best ethics course that I have taken. Thank you!

It was a good high level summary of the financial statements

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.

Great class- one of the better ones! As someone who has a published book, I can attest to the importance of editing.

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.

Very good information given in this course, and given in a way that was very informative, not too wordy, and easy to understand.

Clear and Concise course. Learned a lot about analyzing data.

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

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.

One of the presentation sections was not included, but rather a repeat presentation of the previous section.

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.

now that I WFH full time because of the pandemic, this was SO helpful!

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

There should be a handout which can be referred to with more information that assists with the exam. This took longer than 3 hours.

Explanation/presentation was very conversational and provided a lot of insight based on real experience with the legislation.

This instructor courses are always very helpful and are well thought out. I always look for her courses on-line as I always learn something new and interesting from her classes.

I wish I saw this training at my previous job. What a good, straightforward approach to managing the situation.

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.

Great review of some items and nice to learn some new tips and tricks. Benford's Law was a nice nugget to discover. Sales Reps who care about good data need to watch this. Many times they do not understand how data can be skewed and they could benefit from learning how to assess the quality of the data they are looking at. Great overview for executive too.

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 course. Stated prerequisite requirements were appropriate and sufficient. Program materials were relevant and contributed to the achievement of the learning objectives.

Great info! Informative and easy to understand. I liked that it was broken up into smaller chunks.

I learn better when I can read-along with the narration script; providing that would be helpful.

Great tips for Excel! Instructor has a very energetic and entertaining style!

An important aspect that companies forget to look at because cyber attacks are seldomly experienced by them. Great refresher on how to react to cyber attacks

Business Intelligence - Data Collection and Cleaning gives you a good grasp of gathering data and processing.

Outstanding course! Learned a ton in a short amount of time.

very good high level information for lending business details

Great stuff that every financial person should understand.

The hands-on part of this module was effective, but the final exam had some grammatical errors that made it more esoteric than necessary.

Audio makes it more easier. Text while good for a busy professionals having audio will be easier to follow

Very well spoken and concise summary of the major updates

I like seeing the screenshots of actions to be performed and then performing the actual actions live in Excel.

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!

I wish there was an visual step-by-step of the case analysis.

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.

I like how cutting edge the topic is, but the lecturer style is a bit too academic.

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.

This course was informative and provided the basics beyond using regressions for forecasting.

Helpful information on those pesky error messages that we tend to live with rather than fix.

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

Great course, the documents are relevant are properly explain the material covered. I would argue that some of it is outdated and should consider tools available to be used with Excel. Some of the questions in the test need to be reviewed too.

Many supporting materials didn't open. Many supporting materials didn't open.

I do not think that this explained block chain well

good refresher course for auditors who may not have manufacturing clients regularly

Once again a knowledge of the exam questions is dependent on the participants enrollment in other programs within this certification program. Useful information but not connection to final exam questions.

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

great class, easy to use, material presented well, very organized, key points listed for every subject

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.

Great overview of Big Data, now understand the foundation to continue learning.

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.

Course content was good and the materials provided were helpful.

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.

Great refresher on basic accounting topics. The materials were easy to follow, and navigate.

This was an excellent overview of fundamental excel functions. I love the multiple uses of examples.

Great introductory course. Love how the presentation was well prepared.

I found the theoretical information interesting; however, struggled to pick up the excel examples in the webcast format.

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.

Well thought out and presented. Nice 30,000 foot view on what data is and how to work with it. No complaints here!

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.

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.

Very interesting and insightful course on new data analytics techniques.

I feel as though I could apply these lessons to my job. While I feel like I knew most of the material beforehand, this was a good refresher.

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.

good course well done good job 50 characters. windsorizing is a funny name

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.

I appreciated the use of current and relevant topics to help explain concepts, such as the use of the Dunkin Donuts and Starbucks examples.

Another great course. This course utilizes a case study to really give you deep insight into real world evaluations of the big data revolution.

Good introduction and overview of data collection and cleaning.

Thank you so much for this great learning experience. I look forward to continueing with the CDAP program.

The course explained the importance of learning about using appropriate data to achieve predictable results and how to obtain data that will satisfy those conditions.

Breaking up the information into easy to digest modules is a great way to really digest this information

Interesting that we have a PwC case for a mandatory GT training.

great course!!!!!!! going to show my grandkids this course one day so they can learn all this rockin information too!!!!!

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 made complex concepts very easy to understand.

Very good background! Very good breakout of the steps that need to be taken to collect, clean, merge, and analyze final data.

Effective course! I now have a better understanding why BI is so important.

the course was clear and very informative, i look forward to implementing this in my every day work life.

Thank you for the course. Learned about interpreting data and analyzing data. Helpful course.

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.

this was a very engaging webcast and I think I will be able to use this going forward

this course was a great learning experience for tax professionals

I think the questions given were applicable to the training and although tricky I considered them useful.

This informational video achieved its objectives. It was very thorough in its instructions and examples.

Pretty interesting, especially the stuff on benfords law

I liked the relatability to the industry. This day in age, business is driven by data analysis and using that information to become more efficient.

This course provides an informative foundation to BI.

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.

This was a quality course related to Data Collection and cleaning 0- I thought that the information provided was very relevant.

some interesting facts here. also learned a few things

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!

Interesting course with a lot of specific examples which help to illustrate the practicality of the subject.

One of the best explanations of the the cash flow statement that I have seen--his logic helps me better understand the cash flow statement from an intuitive perspective. Also, I didn't really like the floating box around the text. The workbook PDF also should be in a PDF form, Excel or something that I wouldn't need to print out to complete.

Straight to the point and well organized. Great way to get some high level knowledge of business intelligence.

Very in depth overview of TCJA. This really helped my understanding of which tax items have been modified or kept.

Some of the review and exam questions were irrelevant or out right wrong. The bullet points could have been organized better to be more communicative and concise. The course failed to bring up that there might be any ethical concerns regarding big data and instead expected us to drink the "kool aide" without introducing that there might be any critical analysis regarding the topic.

I thought the review was thorough and introduced the site very well.

This class needs dramatic improvement. The class is simply a reading of the course materials in a monotone voice. There is no captivating element in it. It is challenging to learn from a class presented in this manner.

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.

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 is an excellent starter course to get anyone who is interested in the new revenue recognition standards, ASC 606, familiar with the new requirements. It breaks down the 5 step model and explains what is required for each step.

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.

Harder to understand than i thought with my pivot experience.

Helpful information!

Liked to keep up to date with new changes.

Interesting real life cases.

Instructor is very animated - good basic overview/refresher.

I really enjoyed learning about the different ways to collect, merge and validate data. I thought is was very interesting and useful to know that there is an excel add-in where you can get data from the Federal Reserve (Fred) as well as data from the U.S. Census, and Google Trends.

Some more error rectification technique may be included in this course.

excellent course on a much needed topic

Good information especially for someone new to accounting.

Very comprehensive and extremely thorough.

Excellent, great summary

Didn't realize QB was this powerful. Good overview.

seems like a good class for today's environment

Great Course!

Very helpful

Very informative course!

Tough overall but a great course

Tough course

Great course.

Good overview of Digital Marketing.

Easy content, presented nicely.

Short, but very well put together and very informative, nicely done!

Instructor was effective at presenting the content, as well as introducing new ideas

Great course to learn all the functions. Worksheets are extremely helpful to "ingrain" the formulas so they aren't forgotten when you next need them.

Great Course!

Good course

Difficult but enjoyable

Amazing. You should try being a professor because I think you would do well

Great refresher on financial statement analysis

Great Course!

Great time.

Great Course!

Good course.

Helpful for understanding datasets and making sure your data is not fake

Very interesting information, good course

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

A+

interesting, lot of material

Good course

I loved this course, very interesting!!

Great overall course, wish I watched this sooner!

Great tips!

Great overview

One of the best Illumeo classes I've taken.

Excellent course

Enjoyed it.

Test questions were not captured in the presentation materials.

Great course!

I enjoyed how informative and positive the speaker was during the Session. He provided real life small examples to help understand some terminology.

excellent refresher

Good refresher on SEC Reporting and structure of reports

I usually don't write reviews but in this case I will. I really enjoyed listening to this presenter. He is very knowledgeable and interesting and well worth my time taking this course. Thank you. Kim

The course is great, however, the video sometimes disconnect in the middle and have to wait and drag to make it work